Bug #28051 Falcon LIKE searches fail if partial indexes exist

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

Description:
If I have a partial index on a column, then
WHERE column_name LIKE '...' fails.

Not quite the same as bug#28032 , which is now closed.

How to repeat:
create table t1 (c1 char(50)) engine=falcon;
alter table t1 add index(c1(5));
insert into t1 values ('abcdefg'),('abcdefg'),('abcdefg');
select c1 from t1 where c1 like 'abcdef%';

Example:

/* inspired by ctype_euckr.test */

mysql> create table t1 (c1 char(50)) engine=falcon;
Query OK, 0 rows affected (0.01 sec)

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

mysql> insert into t1 values ('abcdefg'),('abcdefg'),('abcdefg');
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select c1 from t1 where c1 like 'abcdef%';
Empty set (0.00 sec)

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

Test case is falcon_bug_28051.test.