Bug #27540 serious bug in select statement,showing empty set on Windows,but not in Linux
Submitted: 30 Mar 2007 6:49 Modified: 30 Mar 2007 8:38
Reporter: sandie bug Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.1-alpha-nt OS:Windows (Windows)
Assigned to: CPU Architecture:Any
Tags: empty sets, SELECT

[30 Mar 2007 6:49] sandie bug
Description:
i have a table like which has 4 rows,like
[table_name]
field_1   field_2   field_3
  1         1          1
  2         1          2
  3         1          3
  4         1          4
  5         2          1

*all fields are int(10)
i used select statement as follows:
1) after inserting 1st four rows:
   select * from table_name where field_2=1 and field_3=1;
   [it gives the 1st row ]
2) after inserting 5th row:
   select * from table_name where field_2=1 and field_3=1;
   [it give 'Empty Set']

*it shud give 1st row in both cases...strange !!!!

How to repeat:
make a table above and try again,engine is innodb

Suggested fix:
no fix yet
[30 Mar 2007 6:55] sandie bug
use this (select * from t_course_sem where course_id=1 and sem_id=1)

Attachment: ddl2.sql (application/octet-stream, text), 1.54 KiB.

[30 Mar 2007 8:38] Sveta Smirnova
Thank you for the report.

I can not repeat with one of latest 5.0.34 version.