summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/r/tc_temporary_column_length.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/tc_temporary_column_length.result')
-rw-r--r--mysql-test/suite/engines/funcs/r/tc_temporary_column_length.result44
1 files changed, 22 insertions, 22 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_temporary_column_length.result b/mysql-test/suite/engines/funcs/r/tc_temporary_column_length.result
index a78066c8b57..f1a9a775440 100644
--- a/mysql-test/suite/engines/funcs/r/tc_temporary_column_length.result
+++ b/mysql-test/suite/engines/funcs/r/tc_temporary_column_length.result
@@ -6,7 +6,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` bit(10) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -17,7 +17,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` tinyint(10) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -28,7 +28,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` smallint(10) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -39,7 +39,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` mediumint(10) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -50,7 +50,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` int(10) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -61,7 +61,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` int(10) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -72,7 +72,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` bigint(10) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -83,7 +83,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` char(10) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -94,7 +94,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` varchar(10) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -105,7 +105,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` binary(10) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -116,7 +116,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` varbinary(10) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -127,7 +127,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` bit(10) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -138,7 +138,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` tinyint(10) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -149,7 +149,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` smallint(10) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -160,7 +160,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` mediumint(10) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -171,7 +171,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` int(10) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -182,7 +182,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` int(10) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -193,7 +193,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` bigint(10) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -204,7 +204,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` char(10) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -215,7 +215,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` varchar(10) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -226,7 +226,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` binary(10) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -237,7 +237,7 @@ SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
`c1` varbinary(10) NOT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
View Lorry Controller Status