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/[email protected]