Subquery with "NOT IN" fails to return results in NDB tables

Hello Giuseppe,

Thanks for the report!
I verified this and created a bugreport :

http://bugs.mysql.com/5367

you may use this url to track the progress of the issue.

> A subquery with a "NOT IN" operator fails to return the right result
> when using NDB tables.
>
> SELECT
> *
> FROM
> table1
> WHERE
> ID_column NOT IN
> (
> SELECT
> ID_column
> FROM
> table2
> )
>
> Even though there are rows in table1 not matching the corresponding
> ID_column in table2, the query returns an empty set.
>
> The same operation returns the right result when using MyISAM tables.
>
> Test done using MySQL-max 4.1.4, binaries compiled by MySQL AB
> (mysql-max-4.1.4-gamma-pc-linux-i686.tar.gz)

--
Victoria Reznichenko, Support Engineer
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org