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.result44
1 files changed, 22 insertions, 22 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 ffd3c000c7d..442c6bc771d 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
@@ -23,7 +23,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -64,7 +64,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -105,7 +105,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -146,7 +146,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -187,7 +187,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -228,7 +228,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -269,7 +269,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -310,7 +310,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -351,7 +351,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -392,7 +392,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -433,7 +433,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -474,7 +474,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -515,7 +515,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -556,7 +556,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -597,7 +597,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -638,7 +638,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -679,7 +679,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -720,7 +720,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -761,7 +761,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -802,7 +802,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -843,7 +843,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
@@ -884,7 +884,7 @@ t1 CREATE TABLE `t1` (
PRIMARY KEY (`c1`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
ALTER TABLE t1 ALTER COLUMN c2 DROP DEFAULT;
-INSERT INTO t1(c1) VALUES(2);
+INSERT IGNORE INTO t1(c1) VALUES(2);
Warnings:
Warning 1364 Field 'c2' doesn't have a default value
SELECT * FROM t1 ORDER BY c1;
View Lorry Controller Status