Bug #36186 Falcon: searches fail if value < 'a', length>1, index, utf32
Submitted: 17 Apr 2008 19:38 Modified: 14 Jan 2009 5:37
Reporter: Peter Gulutzan Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.5-alpha-debug OS:Linux (SUSE 10 | 32-bit)
Assigned to: Lars-Erik Bjørk CPU Architecture:Any
Tags: F_INDEX

[17 Apr 2008 19:38] Peter Gulutzan
Description:
I create a Falcon table with an indexed utf32 column.
I insert some two-character strings which are less than 'a'.
I search for the strings using "< 'a'".
I get nothing.

The problem occurs only if engine=falcon.
The problem occurs only if length(column-value) > 1.
The problem occurs only if column is indexed.
The problem occurs only if column character set is utf32.

How to repeat:
mysql> create table t4 (s1 varchar(2) character set utf32) engine=falcon;
Query OK, 0 rows affected (0.13 sec)

mysql> create index i on t4 (s1);
Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

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

mysql> select * from t4 where s1 < 'a';
Empty set (0.00 sec)
[13 Jan 2009 19:15] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/63164

2957 lars-erik.bjork@sun.com	2009-01-13
      This is a test for bug#36186 Falcon: searches fail if value < 'a',
      length>1, index, utf32
      
      The bug is no longer reproducible.
      
      
      Added file 'mysql-test/suite/falcon/t/falcon_bug_36186.test'
      ------------------------------------------------------------
      A test testing that the bug is no longer reproducible
      
      Added file 'mysql-test/suite/falcon/r/falcon_bug_36186.result'
      --------------------------------------------------------------
      The expected output of the test
[13 Jan 2009 19:43] Kevin Lewis
The test case looks good.  Do you have any idea which of the recent changes may have fixed this?  Vlad was quite prophetic when he said that this would be fixed 'automagically'.
[14 Jan 2009 5:37] Lars-Erik Bjørk
I have tried to reproduce this on several different platforms without any luck. I have added a test to be on the safe side.
[13 Feb 2009 7:23] Bugs System
Pushed into 6.0.10-alpha (revid:alik@sun.com-20090211182317-uagkyj01fk30p1f8) (version source revid:lars-erik.bjork@sun.com-20090113191409-jb1ynpfy9osxj2mf) (merge vers: 6.0.10-alpha) (pib:6)