A test SQL script which duplicates this problem is available via anonymous FTP at the following location:
Hostname: ftp.visi.com Directory: /users/chris Filename: test.sql Run the script like this to see the error: mysql -t temp < test.sql The second select statement returns only 2 of the 6 rows that it should have found. This problem was reported by me and fixed in 3.23.23. It appears from the changelog that MySQL developers also had problems in this area with release 3.23.14. --------------------------------------------------------------------- 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