Hi, Version 7.6.00.16 on linux, when used stmnt like:
SELECT * FROM tbl WHERE col IN (NULL, 1, 8, 9 ) does not return any result, however if used: SELECT * FROM tbl WHERE col IN (1, 8, 9, NULL ) or SELECT * FROM tbl WHERE col IN (1, 8, 9) it works correctly. It also works in case, that there is NULL and only one other condition, and then NULL can be at first place ( IN (NULL, 1) - this works. )
- is that fixed in newer release ? - is there any workaround for 7.6.00.16 ? Thanks, Tomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
