Unicode collation order by bug!!
I copy the "utf8_5624_1" collation from the latest 5.6.21 version(mysql-test\std_data\Index.xml) to my index.xml file(share\charsets\Index.xml).
Then, i create a test table, the scripts is:
-----------------------------------------
CREATE TABLE `ta` (
`autoid` INT(11) NOT NULL AUTO_INCREMENT,
`tf01` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_5624_1',
PRIMARY KEY (`autoid`)
)
COLLATE='utf8_5624_1'
ENGINE=InnoDB;
I insert some test data into the ta table:
-----------------------------------------
INSERT INTO `ta` (`tf01`) VALUES ('00002');
INSERT INTO `ta` (`tf01`) VALUES ('00003');
INSERT INTO `ta` (`tf01`) VALUES ('00006');
INSERT INTO `ta` (`tf01`) VALUES ('02');
INSERT INTO `ta` (`tf01`) VALUES ('03');
INSERT INTO `ta` (`tf01`) VALUES ('06');
INSERT INTO `ta` (`tf01`) VALUES ('00001');
INSERT INTO `ta` (`tf01`) VALUES ('01');
Finally, i run the query script:
-----------------------------------------
select tf01 from ta order by tf01
The result of query is:
-----------------------------------------
00002
00003
00006
02
03
06
00001
01
I expect the result of query is:
-----------------------------------------
00001
00002
00003
00006
01
02
03
06
Subject
Views
Written By
Posted
Unicode collation order by bug!!
3612
October 09, 2014 04:58AM
1783
October 09, 2014 07:32AM
2058
October 09, 2014 07:26PM
1852
October 10, 2014 04:25AM
1764
October 10, 2014 05:11AM
1686
October 10, 2014 05:15AM
1693
October 10, 2014 05:24AM
1715
October 10, 2014 08:32AM
Sorry, you can't reply to this topic. It has been closed.
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.