| 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: | |
| 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 | ||
[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)
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)