diff options
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 0bd0e572193..4338d0f8f9a 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -1804,7 +1804,9 @@ drop table t1; # underlying tables (BUG#6443) # set sql_mode='strict_all_tables'; +--disable_warnings CREATE TABLE t1 (col1 INT NOT NULL, col2 INT NOT NULL) ENGINE = INNODB; +--enable_warnings CREATE VIEW v1 (vcol1) AS SELECT col1 FROM t1; CREATE VIEW v2 (vcol1) AS SELECT col1 FROM t1 WHERE col2 > 2; -- error 1364 @@ -1860,7 +1862,9 @@ drop table t1; # # Test for bug #11771: wrong query_id in SELECT * FROM <view> # +--disable_warnings CREATE TABLE t1 (f1 char) ENGINE = innodb; +--enable_warnings INSERT INTO t1 VALUES ('A'); CREATE VIEW v1 AS SELECT * FROM t1; |