2 DROP TABLE IF EXISTS t1;
4 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT NOT NULL, c3 TINYINT NOT NULL);
5 INSERT INTO t1 VALUES(1,1,1),(1,1,2),(1,2,1),(1,2,2),(2,1,1);
6 ALTER TABLE t1 ORDER BY c1,c2,c3;
8 ALTER TABLE t1 ORDER BY c3,c2,c1;
10 ALTER TABLE t1 ORDER BY c3,c2,c1 DESC;
12 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
13 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
14 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
15 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT NOT NULL, c3 SMALLINT NOT NULL);
16 INSERT INTO t1 VALUES(1,1,1),(1,1,2),(1,2,1),(1,2,2),(2,1,1);
17 ALTER TABLE t1 ORDER BY c1,c2,c3;
19 ALTER TABLE t1 ORDER BY c3,c2,c1;
21 ALTER TABLE t1 ORDER BY c3,c2,c1 DESC;
23 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
24 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
25 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
26 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 MEDIUMINT NOT NULL);
27 INSERT INTO t1 VALUES(1,1,1),(1,1,2),(1,2,1),(1,2,2),(2,1,1);
28 ALTER TABLE t1 ORDER BY c1,c2,c3;
30 ALTER TABLE t1 ORDER BY c3,c2,c1;
32 ALTER TABLE t1 ORDER BY c3,c2,c1 DESC;
34 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
35 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
36 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
37 CREATE TABLE t1(c1 INT NOT NULL, c2 INT NOT NULL, c3 INT NOT NULL);
38 INSERT INTO t1 VALUES(1,1,1),(1,1,2),(1,2,1),(1,2,2),(2,1,1);
39 ALTER TABLE t1 ORDER BY c1,c2,c3;
41 ALTER TABLE t1 ORDER BY c3,c2,c1;
43 ALTER TABLE t1 ORDER BY c3,c2,c1 DESC;
45 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
46 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
47 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
48 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER NOT NULL, c3 INTEGER NOT NULL);
49 INSERT INTO t1 VALUES(1,1,1),(1,1,2),(1,2,1),(1,2,2),(2,1,1);
50 ALTER TABLE t1 ORDER BY c1,c2,c3;
52 ALTER TABLE t1 ORDER BY c3,c2,c1;
54 ALTER TABLE t1 ORDER BY c3,c2,c1 DESC;
56 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
57 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
58 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
59 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT NOT NULL, c3 BIGINT NOT NULL);
60 INSERT INTO t1 VALUES(1,1,1),(1,1,2),(1,2,1),(1,2,2),(2,1,1);
61 ALTER TABLE t1 ORDER BY c1,c2,c3;
63 ALTER TABLE t1 ORDER BY c3,c2,c1;
65 ALTER TABLE t1 ORDER BY c3,c2,c1 DESC;
67 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
68 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
69 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;