summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/r/ta_column_to_index.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_column_to_index.result')
-rw-r--r--mysql-test/suite/engines/funcs/r/ta_column_to_index.result48
1 files changed, 24 insertions, 24 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_column_to_index.result b/mysql-test/suite/engines/funcs/r/ta_column_to_index.result
index 42906329967..b5e0a265674 100644
--- a/mysql-test/suite/engines/funcs/r/ta_column_to_index.result
+++ b/mysql-test/suite/engines/funcs/r/ta_column_to_index.result
@@ -314,7 +314,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD KEY (c1);
SHOW TABLES;
@@ -323,7 +323,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `c1` (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
@@ -666,7 +666,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD KEY USING BTREE (c1);
SHOW TABLES;
@@ -675,7 +675,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `c1` (`c1`) USING BTREE
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
@@ -1018,7 +1018,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD KEY USING HASH (c1);
SHOW TABLES;
@@ -1027,7 +1027,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `c1` (`c1`) USING HASH
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
@@ -1370,7 +1370,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD INDEX (c1);
SHOW TABLES;
@@ -1379,7 +1379,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `c1` (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
@@ -1722,7 +1722,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD INDEX USING BTREE (c1);
SHOW TABLES;
@@ -1731,7 +1731,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `c1` (`c1`) USING BTREE
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
@@ -2074,7 +2074,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD INDEX USING HASH (c1);
SHOW TABLES;
@@ -2083,7 +2083,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `c1` (`c1`) USING HASH
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
@@ -2426,7 +2426,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD KEY i1 (c1);
SHOW TABLES;
@@ -2435,7 +2435,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `i1` (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
@@ -2778,7 +2778,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
SHOW TABLES;
@@ -2787,7 +2787,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `i1` (`c1`) USING BTREE
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
@@ -3130,7 +3130,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
SHOW TABLES;
@@ -3139,7 +3139,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `i1` (`c1`) USING HASH
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
@@ -3482,7 +3482,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD INDEX i1 (c1);
SHOW TABLES;
@@ -3491,7 +3491,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `i1` (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
@@ -3834,7 +3834,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
SHOW TABLES;
@@ -3843,7 +3843,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `i1` (`c1`) USING BTREE
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
@@ -4186,7 +4186,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ `c1` timestamp NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
SHOW TABLES;
@@ -4195,7 +4195,7 @@ t1
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `c1` timestamp NOT NULL,
KEY `i1` (`c1`) USING HASH
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
View Lorry Controller Status