Hostgator black friday 26 nov

Tuesday, November 22, 2011

Mysql Select Random Bug

I found the bug at mysql about random

"SELECT * FROM orderdetail WHERE category='sale' ORDER BY RAND() LIMIT 5;"

the result is always same this is strange
and i googling and search some article
the mysql developer has already fix this you can download new version of mysql


[9 Jul 2003 9:13] Paul DuBois
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

No comments:

Post a Comment