Bug #28035 Falcon Partial indexing failure

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

Description:
If I use "create index ... (col_name(length))"
so that only a prefix is indexed, I can't find
values which are longer than (length).

How to repeat:
 How to repeat:

mysql> create table t2 (s1 varchar(5)) engine = jstar;
Query OK, 0 rows affected (0.01 sec)

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

mysql> insert into t2 values ('b'),('ba');
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql> select * from t2 where s1 = 'b';
+------+
| s1 |
+------+
| b |
+------+
1 row in set (0.00 sec)

mysql> select * from t2 where s1 = 'ba';
Empty set (0.00 sec)

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

Test case is falcon_bug_28035.test.