1# 2# Testing filesort for full Unicode character sets 3# with supplementary characters. 4# 5 6--echo # 7--echo # Bug#55980 Character sets: supplementary character _bin ordering is wrong 8--echo # 9CREATE TABLE t1 AS SELECT REPEAT('a',1) AS a LIMIT 0; 10SHOW CREATE TABLE t1; 11INSERT INTO t1 VALUES (_utf8mb4 0xEFBE9D),(_utf8mb4 0xF0908E84); 12INSERT INTO t1 VALUES (_utf8mb4 0xCE85),(_utf8mb4 0xF4808080); 13SELECT HEX(a), HEX(CONVERT(a USING utf8mb4)) FROM t1 ORDER BY a; 14ALTER TABLE t1 ADD KEY(a); 15SELECT HEX(a), HEX(CONVERT(a USING utf8mb4)) FROM t1 ORDER BY a; 16DROP TABLE IF EXISTS t1; 17--echo # 18--echo # BUG#16691598 - ORDER BY LOWER(COLUMN) PRODUCES 19--echo # OUT-OF-ORDER RESULTS 20--echo # 21CREATE TABLE t1 SELECT ('a a') as n; 22INSERT INTO t1 VALUES('a b'); 23SELECT * FROM t1 ORDER BY LOWER(n) ASC; 24SELECT * FROM t1 ORDER BY LOWER(n) DESC; 25DROP TABLE t1; 26