diff options
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 8 |
1 files changed, 2 insertions, 6 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 62f01388f30..408d70b0540 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -1793,9 +1793,7 @@ 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 TABLE t1 (col1 INT NOT NULL, col2 INT NOT NULL); CREATE VIEW v1 (vcol1) AS SELECT col1 FROM t1; CREATE VIEW v2 (vcol1) AS SELECT col1 FROM t1 WHERE col2 > 2; -- error 1364 @@ -1851,9 +1849,7 @@ 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 +CREATE TABLE t1 (f1 char); INSERT INTO t1 VALUES ('A'); CREATE VIEW v1 AS SELECT * FROM t1; |