Getting a very strange issue with a query just now. Is anybody else experiencing similar issues. The query works as expected in Tim's query editor but doesn't filter the results properly in a map/reduce script. The query returns results that have the status of 'G' even although it should be filtered out

SELECT

t.tranid AS transaction,

t.trandate,

t.status,

t.memo,

v.entityid AS supplier

FROM

transaction t

LEFT JOIN vendor v ON v.id = t.entity

WHERE

t.type = 'PurchOrd'

AND

t.employee = ?

AND

t.status NOT IN ('A','C','G','H')

ORDER BY t.trandate