summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/r/tc_structure_create_select.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/tc_structure_create_select.result')
-rw-r--r--mysql-test/suite/engines/funcs/r/tc_structure_create_select.result100
1 files changed, 50 insertions, 50 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_structure_create_select.result b/mysql-test/suite/engines/funcs/r/tc_structure_create_select.result
index c6deaaef786..4d41ffcc91d 100644
--- a/mysql-test/suite/engines/funcs/r/tc_structure_create_select.result
+++ b/mysql-test/suite/engines/funcs/r/tc_structure_create_select.result
@@ -11,7 +11,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` bit(1) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -27,7 +27,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` bit(1) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -45,7 +45,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -61,7 +61,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -79,7 +79,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` smallint(6) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -95,7 +95,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` smallint(6) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -113,7 +113,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` mediumint(9) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -129,7 +129,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` mediumint(9) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -147,7 +147,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` int(11) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -163,7 +163,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` int(11) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -181,7 +181,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` int(11) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -197,7 +197,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` int(11) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -215,7 +215,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` bigint(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -231,7 +231,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` bigint(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -249,7 +249,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` double DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -265,7 +265,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` double DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -283,7 +283,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` double DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -299,7 +299,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` double DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -317,7 +317,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` float DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -333,7 +333,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` float DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -351,7 +351,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` decimal(10,0) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -367,7 +367,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` decimal(10,0) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -385,7 +385,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` decimal(10,0) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -401,7 +401,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` decimal(10,0) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -419,7 +419,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` date DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -435,7 +435,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` date DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -453,7 +453,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` time DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -469,7 +469,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` time DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -487,7 +487,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` datetime DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -503,7 +503,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` datetime DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -521,7 +521,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -537,7 +537,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -555,7 +555,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` year(4) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -571,7 +571,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` year(4) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -589,7 +589,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` tinyblob DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -605,7 +605,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` tinyblob DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -623,7 +623,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` blob DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -639,7 +639,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` blob DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -657,7 +657,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` mediumblob DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -673,7 +673,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` mediumblob DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -691,7 +691,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` longblob DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -707,7 +707,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` longblob DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -725,7 +725,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` tinytext DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -741,7 +741,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` tinytext DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -759,7 +759,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` text DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -775,7 +775,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` text DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -793,7 +793,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` mediumtext DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -809,7 +809,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` mediumtext DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -827,7 +827,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` longtext DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -843,7 +843,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` longtext DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
View Lorry Controller Status