diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_drop_string_index.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/ta_drop_string_index.result | 96 |
1 files changed, 48 insertions, 48 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_drop_string_index.result b/mysql-test/suite/engines/funcs/r/ta_drop_string_index.result index b85e6c28160..4bd7e3ffa58 100644 --- a/mysql-test/suite/engines/funcs/r/ta_drop_string_index.result +++ b/mysql-test/suite/engines/funcs/r/ta_drop_string_index.result @@ -8,7 +8,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -17,7 +17,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -30,7 +30,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -39,7 +39,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -52,7 +52,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -61,7 +61,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -74,7 +74,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -83,7 +83,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -96,7 +96,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -105,7 +105,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -118,7 +118,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -127,7 +127,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -140,7 +140,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -149,7 +149,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -162,7 +162,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -171,7 +171,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -184,7 +184,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -193,7 +193,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -206,7 +206,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -215,7 +215,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -228,7 +228,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -237,7 +237,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -250,7 +250,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP KEY i1; SHOW TABLES; Tables_in_test @@ -259,7 +259,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -272,7 +272,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -281,7 +281,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -294,7 +294,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -303,7 +303,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -316,7 +316,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -325,7 +325,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -338,7 +338,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -347,7 +347,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -360,7 +360,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -369,7 +369,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -382,7 +382,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -391,7 +391,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -404,7 +404,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -413,7 +413,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -426,7 +426,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -435,7 +435,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -448,7 +448,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -457,7 +457,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -470,7 +470,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -479,7 +479,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -492,7 +492,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -501,7 +501,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -514,7 +514,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL, KEY `i1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 DROP INDEX i1; SHOW TABLES; Tables_in_test @@ -523,7 +523,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(30) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test |