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!!
3506
October 09, 2014 04:58AM
1740
October 09, 2014 07:32AM
1978
October 09, 2014 07:26PM
1804
October 10, 2014 04:25AM
1719
October 10, 2014 05:11AM
1644
October 10, 2014 05:15AM
1648
October 10, 2014 05:24AM
1661
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.