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