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.result22
1 files changed, 22 insertions, 0 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..b302233fa0d 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
@@ -2,6 +2,7 @@ DROP TABLE IF EXISTS t5;
CREATE TEMPORARY TABLE t5(c1 BIT(10) NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -13,6 +14,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 TINYINT(10) NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -24,6 +26,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 SMALLINT(10) NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -35,6 +38,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 MEDIUMINT(10) NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -46,6 +50,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 INT(10) NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -57,6 +62,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 INTEGER(10) NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -68,6 +74,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 BIGINT(10) NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -79,6 +86,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 CHAR(10) NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -90,6 +98,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 VARCHAR(10) NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -101,6 +110,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 BINARY(10) NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -112,6 +122,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 VARBINARY(10) NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -123,6 +134,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 BIT(10) NOT NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -134,6 +146,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 TINYINT(10) NOT NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -145,6 +158,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 SMALLINT(10) NOT NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -156,6 +170,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 MEDIUMINT(10) NOT NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -167,6 +182,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 INT(10) NOT NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -178,6 +194,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 INTEGER(10) NOT NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -189,6 +206,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 BIGINT(10) NOT NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -200,6 +218,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 CHAR(10) NOT NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -211,6 +230,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 VARCHAR(10) NOT NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -222,6 +242,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 BINARY(10) NOT NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (
@@ -233,6 +254,7 @@ Tables_in_test
CREATE TEMPORARY TABLE t5(c1 VARBINARY(10) NOT NULL);
SHOW TABLES;
Tables_in_test
+t5
SHOW CREATE TABLE t5;
Table Create Table
t5 CREATE TEMPORARY TABLE `t5` (