MySQL Forums
Forum List  »  Quality Assurance

Unicode collation order by bug!!
Posted by: shinwell lee
Date: October 09, 2014 04:58AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Unicode collation order by bug!!
2860
October 09, 2014 04:58AM
1473
October 09, 2014 07:32AM
1633
October 09, 2014 07:26PM
1494
October 10, 2014 04:25AM
1460
October 10, 2014 05:11AM
1403
October 10, 2014 05:15AM
1402
October 10, 2014 05:24AM
1420
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.