diff options
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.result | 44 |
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; |