The following queries worked with the 3.22.32 version and not with the
3.23.47 and 3.23.49a versions.
select field1,field2,locate(ifnull(field3,'N'),'N') from mytable where
field3 not in ('N') order by 3, field1
select field1,field2,locate(ifnull(field3,'N'),'N') from mytable where
field3 not in ('Y',' ') order by 3, field1
(before launching the 2nd query I changed all NULL values by the space
character ' ')
the type of field3 is char(1).
field3 values are 'Y','N',NULL
the same problem occurs when values are 'Y','N',' '
the "in (Value1,Value2,...,Valuen)" syntax seems not work correctly.
I used the binary distribution for intel-libc6-linux systems.
Maybe a bug or a compilation problem specific to the intel libraries.
If any more information is needed please mail me at [EMAIL PROTECTED]
Yan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
