Bug #28059 Falcon Binary use fails if index exists

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

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

Description:
If I have an indexed binary column in a Falcon table,
When I select with a WHERE clause, rows are missing.

How to repeat:
How to repeat:

mysql> create table t315 (s1 binary(5)) engine=falcon;
Query OK, 0 rows affected (0.01 sec)

mysql> create index it315 on t315 (s1);
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> insert into t315 values (0x0001020300),(0x0001020300),(0x0001020300);
Query OK, 3 rows affected (0.02 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select hex(s1) from t315 where s1=0x0001020300;
Empty set (0.00 sec)

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

Test case is falcon_bug_28059.test.