Edit File: ix_using_order.result
DROP TABLE IF EXISTS t1; CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE INDEX i1 USING BTREE ON t1(c1 ASC); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, KEY `i1` (`c1`) USING BTREE ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP INDEX i1 ON t1; DROP TABLE t1; SHOW TABLES; Tables_in_test CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE INDEX i1 USING BTREE ON t1(c1 DESC); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, KEY `i1` (`c1`) USING BTREE ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t1; SHOW TABLES; Tables_in_test CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 ASC); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, UNIQUE KEY `i1` (`c1`) USING BTREE ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP INDEX i1 ON t1; DROP TABLE t1; SHOW TABLES; Tables_in_test CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 DESC); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, UNIQUE KEY `i1` (`c1`) USING BTREE ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP INDEX i1 ON t1; DROP TABLE t1; SHOW TABLES; Tables_in_test CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE INDEX i1 USING HASH ON t1(c1 ASC); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, KEY `i1` (`c1`) USING HASH ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP INDEX i1 ON t1; DROP TABLE t1; SHOW TABLES; Tables_in_test CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE INDEX i1 USING HASH ON t1(c1 DESC); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, KEY `i1` (`c1`) USING HASH ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP INDEX i1 ON t1; DROP TABLE t1; SHOW TABLES; Tables_in_test CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE UNIQUE INDEX i1 USING HASH ON t1(c1 ASC); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, UNIQUE KEY `i1` (`c1`) USING HASH ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP INDEX i1 ON t1; DROP TABLE t1; SHOW TABLES; Tables_in_test CREATE TABLE t1(c1 INTEGER NOT NULL); CREATE UNIQUE INDEX i1 USING HASH ON t1(c1 DESC); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, UNIQUE KEY `i1` (`c1`) USING HASH ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP INDEX i1 ON t1; DROP TABLE t1; SHOW TABLES; Tables_in_test
Back to File Manager