diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb-alter-timestamp.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb-alter-timestamp.result | 17 |
1 files changed, 10 insertions, 7 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-alter-timestamp.result b/mysql-test/suite/innodb/r/innodb-alter-timestamp.result index 355872dc78f..6934484a488 100644 --- a/mysql-test/suite/innodb/r/innodb-alter-timestamp.result +++ b/mysql-test/suite/innodb/r/innodb-alter-timestamp.result @@ -125,14 +125,17 @@ SELECT DISTINCT (CURRENT_TIMESTAMP()-d4) <= 60 FROM t1; 1 DROP TABLE t1; CREATE TABLE t1(f1 int) ENGINE=InnoDB; -INSERT INTO t1 VALUES (1); +INSERT INTO t1 SELECT * FROM seq_1_to_4096; +connect purge_control,localhost,root,,; +START TRANSACTION WITH CONSISTENT SNAPSHOT; +connection default; +DELETE FROM t1; SET sql_mode='STRICT_ALL_TABLES,STRICT_TRANS_TABLES,NO_ZERO_DATE'; ALTER TABLE t1 ADD f2 DATE NOT NULL, ALGORITHM=INPLACE; +INSERT INTO t1 VALUES (1, now()); +Warnings: +Note 1265 Data truncated for column 'f2' at row 1 +ALTER TABLE t1 ADD f3 DATE NOT NULL, ALGORITHM=INPLACE; ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY DROP TABLE t1; -CREATE TABLE t1(f1 int) ENGINE=InnoDB; -INSERT INTO t1 SELECT * FROM seq_1_to_16000; -DELETE FROM t1; -SET sql_mode='STRICT_ALL_TABLES,STRICT_TRANS_TABLES,NO_ZERO_DATE'; -ALTER TABLE t1 ADD b DATE NOT NULL, ALGORITHM=INPLACE; -DROP TABLE t1; +disconnect purge_control; |