Bug #28032 Falcon LIKE searches fail if indexes exist

• Submitted: 23 Apr 2007 18:06
• 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 18:06] Hakan Küçükyılmaz

Description:
If there's an index, LIKE searches fail.

Inspiration: euckr.test's include files.

How to repeat:
mysql> create table t1 engine=jstar select repeat('a',50) as c1;
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0

mysql> insert into t1 values ('aaa');
Query OK, 1 row affected (0.00 sec)

mysql> select * from t1 where c1 like 'aaa%';
+----------------------------------------------------+
| c1 |
+----------------------------------------------------+
| aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa |
| aaa |
+----------------------------------------------------+
2 rows in set (0.00 sec)

mysql> alter table t1 add index(c1(5));
Query OK, 2 rows affected (0.03 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql> select * from t1 where c1 like 'aaa%';
+----------------------------------------------------+
| c1 |
+----------------------------------------------------+
| aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa |
+----------------------------------------------------+
1 row in set (0.00 sec)

/*
   Effect is the same if the index is created with
   create index i1 on t1 (c1).
*/