summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/r/ta_set_drop_default.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_set_drop_default.result')
-rw-r--r--mysql-test/suite/engines/funcs/r/ta_set_drop_default.result132
1 files changed, 66 insertions, 66 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_set_drop_default.result b/mysql-test/suite/engines/funcs/r/ta_set_drop_default.result
index 442c6bc771d..1647669eb40 100644
--- a/mysql-test/suite/engines/funcs/r/ta_set_drop_default.result
+++ b/mysql-test/suite/engines/funcs/r/ta_set_drop_default.result
@@ -9,7 +9,7 @@ t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -21,7 +21,7 @@ t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` tinyint(4) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -36,7 +36,7 @@ t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` tinyint(4),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -50,7 +50,7 @@ t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` smallint(6) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -62,7 +62,7 @@ t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` smallint(6) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -77,7 +77,7 @@ t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` smallint(6),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -91,7 +91,7 @@ t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` mediumint(9) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -103,7 +103,7 @@ t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` mediumint(9) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -118,7 +118,7 @@ t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` mediumint(9),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -132,7 +132,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -144,7 +144,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -159,7 +159,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -173,7 +173,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -185,7 +185,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -200,7 +200,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -214,7 +214,7 @@ t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` bigint(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -226,7 +226,7 @@ t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` bigint(20) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -241,7 +241,7 @@ t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` bigint(20),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -255,7 +255,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -267,7 +267,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -282,7 +282,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -296,7 +296,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -308,7 +308,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -323,7 +323,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -337,7 +337,7 @@ t1 CREATE TABLE `t1` (
`c1` float NOT NULL,
`c2` float DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -349,7 +349,7 @@ t1 CREATE TABLE `t1` (
`c1` float NOT NULL,
`c2` float DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -364,7 +364,7 @@ t1 CREATE TABLE `t1` (
`c1` float NOT NULL,
`c2` float,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -378,7 +378,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -390,7 +390,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -405,7 +405,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -419,7 +419,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -431,7 +431,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -446,7 +446,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -460,7 +460,7 @@ t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -472,7 +472,7 @@ t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` tinyint(4) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -487,7 +487,7 @@ t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` tinyint(4),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -501,7 +501,7 @@ t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` smallint(6) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -513,7 +513,7 @@ t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` smallint(6) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -528,7 +528,7 @@ t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` smallint(6),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -542,7 +542,7 @@ t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` mediumint(9) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -554,7 +554,7 @@ t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` mediumint(9) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -569,7 +569,7 @@ t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` mediumint(9),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -583,7 +583,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -595,7 +595,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -610,7 +610,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -624,7 +624,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -636,7 +636,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -651,7 +651,7 @@ t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -665,7 +665,7 @@ t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` bigint(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -677,7 +677,7 @@ t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` bigint(20) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -692,7 +692,7 @@ t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` bigint(20),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -706,7 +706,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -718,7 +718,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -733,7 +733,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -747,7 +747,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -759,7 +759,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -774,7 +774,7 @@ t1 CREATE TABLE `t1` (
`c1` double NOT NULL,
`c2` double,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -788,7 +788,7 @@ t1 CREATE TABLE `t1` (
`c1` float NOT NULL,
`c2` float DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -800,7 +800,7 @@ t1 CREATE TABLE `t1` (
`c1` float NOT NULL,
`c2` float DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -815,7 +815,7 @@ t1 CREATE TABLE `t1` (
`c1` float NOT NULL,
`c2` float,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -829,7 +829,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -841,7 +841,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -856,7 +856,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
@@ -870,7 +870,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 SET DEFAULT 10;
INSERT INTO t1(c1) VALUES(1);
SELECT * FROM t1 ORDER BY c1;
@@ -882,7 +882,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0) DEFAULT 10,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
@@ -897,7 +897,7 @@ t1 CREATE TABLE `t1` (
`c1` decimal(10,0) NOT NULL,
`c2` decimal(10,0),
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
View Lorry Controller Status