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
• Status: Can't repeat
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.1-alpha-nt
• OS: Windows (Windows)
• 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.