update bug with "limit" syntax - MySQL Ver 4.011

2003-03-07 Thread miniwar
>Description: It is unbelievable that the MySQL ver 4.0 have so many bug, I have been reported 2 bugs just a few days ago. Now, I have found a bug again. The bug is : When I execute "select * from old_topic where FID=4 and (page=0 or page=167) order by replytime asc limit 40;" returns 40

update bug again on Ver4.011.

2003-03-06 Thread miniwar
>Description: The update command seems does not using the index to find the rows to update. Here are the command I have execute on MySQL client. You will be found the different in execute time used. I don't know it is normal or just a bug of the MySQL server.

update/delete bug, please fix, thank you!

2003-03-01 Thread miniwar
>Description: Dear sir, When I execute the command "select * from user_info where regdate < now()- interval 9 day and phone_confirmed is null and email is null and last_onlineHow-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | l