Bug #27697 Non-western-collation searches fail if index exists
| Submitted: | 7 Apr 2007 13:00 | Modified: | 20 May 2007 5:37 |
|---|---|---|---|
| Reporter: | Hakan Küçükyılmaz | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Falcon storage engine | Severity: | S2 (Serious) |
| Version: | OS: | Linux | |
| Assigned to: | Kevin Lewis | CPU Architecture: | Any |
[7 Apr 2007 13:00]
Hakan Küçükyılmaz
I confirm that the search for 'i' works correctly now. But a search for 'I' fails.
I'm opening the bug again (if there's a different standard procedure, correct me).
How to repeat:
set names utf8;
create table i (i char(1) character set utf8 collate utf8_turkish_ci) engine=jstar;
insert into i values ('i'),('ı');
select * from i where i = 'i';
create index i on i (i);
select * from i where i = 'i';
select * from i where i = 'I';
[7 Apr 2007 13:28]
Hakan Küçükyılmaz
[15:27] root@test>SELECT * FROM i where i = 'I'; +------+ | i | +------+ | ı | +------+ 1 row in set (0.00 sec) [15:27] root@test>CREATE INDEX i ON i (i); Query OK, 2 rows affected (0.03 sec) Records: 2 Duplicates: 0 Warnings: 0 [15:27] root@test>SELECT * FROM i where i = 'I'; Empty set (0.02 sec)
[17 Apr 2007 6:01]
Hakan Küçükyılmaz
Test case is falcon_bug_27697.test which is failing.
[9 May 2007 19:09]
Kevin Lewis
Fixed with recent code changes for handling MySQL character sets.
[14 May 2007 17:26]
Hakan Küçükyılmaz
test case falcon_bug_27697 passes now: TEST RESULT TIME (ms) ------------------------------------------------------- falcon_bug_27697 [ pass ] 88 ------------------------------------------------------- Stopping All Servers All 1 tests were successful. The servers were restarted 1 times Spent 0.088 seconds actually executing testcases
[20 May 2007 5:37]
MC Brown
A note has been added to the 6.0.1 changelog.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.058 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: JStar can't handle some character sets and collations. This is just a sample. Inspired by ctype*.test. How to repeat: mysql> create table i (i char(1) character set utf8 collate utf8_turkish_ci) engine=jstar; Query OK, 0 rows affected (0.01 sec) mysql> insert into i values ('i'),('ı'); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> select * from i where i = 'i'; +------+ | i | +------+ | i | | ı | +------+ 2 rows in set (0.00 sec) mysql> create index i on i (i); Query OK, 2 rows affected (0.03 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> select * from i where i = 'i'; +------+ | i | +------+ | i | +------+ 1 row in set (0.00 sec)