Hi, I have the following problem, I'm converting from version 3.23.53 to 4.1.9
The following query was used SELECT * FROM news WHERE languages_id = 'english' AND expiry_ts >= CURDATE() AND FCode = '999' AND DCode = 'Z999' ORDER by id DESC LIMIT 0, 3 it work perfectly on the version 3.23.53 (the tables are perfect copys on version 3 and 4) returning 3 results. when I run the query in version 4.1.9 nothing comes back. When I remove the LIMIT 0,3 version 4.1.9 returns all 5 rows. what I also observed was that if I change the query to SELECT * FROM news WHERE languages_id = 'english' AND expiry_ts >= CURDATE() AND FCode = '999' AND DCode = 'Z999' ORDER by id DESC LIMIT 3 still nothing geet returned but if I change it to SELECT * FROM news WHERE languages_id = 'english' ORDER by id DESC LIMIT 0, 3 or SELECT * FROM news WHERE expiry_ts >= CURDATE() ORDER BY id DESC limit 3 or any query with just one where clause it works. Can someone help/explain what is happening here?? It seems that with multiple where clauses and a limit that nothing get return. Thx for the help. Cecil Mnr Cecil J.C. Brand Internet Office RekenaarDienste University of the Free State/ Universiteit van die Vrystaat PO Box 339 Bloemfontein 9300 South Africa Tel :401 2645 Email :[EMAIL PROTECTED] _____________________________________________________________________ University of the Free State: This message and its contents are subject to a disclaimer. Please refer to http://www.uovs.ac.za/disclaimer for full details. Universiteit van die Vrystaat: Hierdie boodskap en sy inhoud is aan 'n vrywaringsklousule onderhewig. Volledige besonderhede is by http://www.uovs.ac.za/vrywaring beskikbaar. _____________________________________________________________________
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
