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!!
3645
October 09, 2014 04:58AM
1808
October 09, 2014 07:32AM
2095
October 09, 2014 07:26PM
1879
October 10, 2014 04:25AM
1799
October 10, 2014 05:11AM
1711
October 10, 2014 05:15AM
1718
October 10, 2014 05:24AM
1741
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.