Sounds like it might be a bug. Can you do ‘explain plan’ and send the result? Also check for leading and trailing spaces in your data.
> On Sep 26, 2017, at 11:11 AM, Nuwan Abeysiriwardana <[email protected]> > wrote: > > Hi All, > i have following csv tables. > > TableA TableB > +------+ +-------+ > | Q | | A | > +------+ +-------+ > | aaaa | | aaaa | > | 1111 | | ssss | > | 555 | | 22222 | > +------+ +-------+ > > 'select Q,Q not in(select A from TableB) as output from TableA' produce > following result > > +------+--------+ > | Q | output | > +------+--------+ > | aaaa | true | > | 1111 | true | > | 555 | true | > +------+--------+ > > but I'm expecting false for value 'aaaa'. > > also i have tested the following query and it work as expected. > 'select Q,Q not in('aaaa','1111') as output from TableA' > > output : > +------+--------+ > | Q | output | > +------+--------+ > | aaaa | false | > | 1111 | false | > | 555 | true | > +------+--------+ > > i have tested similar query with PostgreSQL ,it works fine. > > thanks > nuwan
