Bug #28057 Falcon OR fails if index exists (3)

• Submitted: 23 Apr 2007 23:30
• Reporter: Hakan Küçükyılmaz
• Status: Closed
• Category: MySQL Server: Falcon storage engine
• Severity: S3 (Non-critical)
• Version: 6.0.0-alpha
• OS: Any
• CPU Architecture: Any

[23 Apr 2007 23:30] Hakan Küçükyılmaz

Description:
If I have one index, and use OR, I see duplicates in the result set.

This is my third "OR fails if index exists" bug report, the others
are 154 (closed) and 186 (still open). The symptoms differ.

How to repeat:
 mysql> create table t7 (s1 int) engine=falcon;
Query OK, 0 rows affected (0.00 sec)

mysql> create index it7 on t7 (s1);
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> insert into t7 values (null),(0),(1);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select * from t7;
+------+
| s1   |
+------+
| NULL |
| 0    |
| 1    |
+------+
3 rows in set (0.00 sec)

mysql> select * from t7 where s1 is null or s1 = 0 or s1 = 1;
+------+
| s1   |
+------+
| NULL |
| 0    |
| NULL |
| 0    |
| 1    |
+------+
5 rows in set (0.01 sec)

[23 Apr 2007 23:30] Hakan Küçükyılmaz

Test case is falcon_bug_28057.test.