Edit File: ix_unique_string_length.result
DROP TABLE IF EXISTS t3; CREATE TABLE t3(c1 CHAR(50) NULL); CREATE UNIQUE INDEX i1 ON t3(c1(10)); SHOW TABLES; Tables_in_test t3 SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` char(50) DEFAULT NULL, UNIQUE KEY `i1` (`c1`(10)) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t3; SHOW TABLES; Tables_in_test CREATE TABLE t3(c1 VARCHAR(50) NULL); CREATE UNIQUE INDEX i1 ON t3(c1(10)); SHOW TABLES; Tables_in_test t3 SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` varchar(50) DEFAULT NULL, UNIQUE KEY `i1` (`c1`(10)) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t3; SHOW TABLES; Tables_in_test CREATE TABLE t3(c1 BINARY(50) NULL); CREATE UNIQUE INDEX i1 ON t3(c1(10)); SHOW TABLES; Tables_in_test t3 SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` binary(50) DEFAULT NULL, UNIQUE KEY `i1` (`c1`(10)) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t3; SHOW TABLES; Tables_in_test CREATE TABLE t3(c1 VARBINARY(50) NULL); CREATE UNIQUE INDEX i1 ON t3(c1(10)); SHOW TABLES; Tables_in_test t3 SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` varbinary(50) DEFAULT NULL, UNIQUE KEY `i1` (`c1`(10)) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t3; SHOW TABLES; Tables_in_test CREATE TABLE t3(c1 CHAR(50) NOT NULL); CREATE UNIQUE INDEX i1 ON t3(c1(10)); SHOW TABLES; Tables_in_test t3 SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` char(50) NOT NULL, UNIQUE KEY `i1` (`c1`(10)) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t3; SHOW TABLES; Tables_in_test CREATE TABLE t3(c1 VARCHAR(50) NOT NULL); CREATE UNIQUE INDEX i1 ON t3(c1(10)); SHOW TABLES; Tables_in_test t3 SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` varchar(50) NOT NULL, UNIQUE KEY `i1` (`c1`(10)) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t3; SHOW TABLES; Tables_in_test CREATE TABLE t3(c1 BINARY(50) NOT NULL); CREATE UNIQUE INDEX i1 ON t3(c1(10)); SHOW TABLES; Tables_in_test t3 SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` binary(50) NOT NULL, UNIQUE KEY `i1` (`c1`(10)) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t3; SHOW TABLES; Tables_in_test CREATE TABLE t3(c1 VARBINARY(50) NOT NULL); CREATE UNIQUE INDEX i1 ON t3(c1(10)); SHOW TABLES; Tables_in_test t3 SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` varbinary(50) NOT NULL, UNIQUE KEY `i1` (`c1`(10)) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t3; SHOW TABLES; Tables_in_test
Back to File Manager