diff options
| author | Igor Babaev <igor@askmonty.org> | 2013-01-08 19:34:33 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2013-01-08 19:34:33 -0800 |
| commit | f853333e09b222f6d6d76d9343b6202b4769ffab (patch) | |
| tree | ccbd97f5dbba13aa19469b61108bdc6e10c3a255 /mysql-test/r/create.result | |
| parent | 88b59efef6ae869bac9d14cefe2982a1061d3c93 (diff) | |
| parent | 7d9df8075e4c9392f4352e6ccd86921994f264bc (diff) | |
| download | mariadb-git-f853333e09b222f6d6d76d9343b6202b4769ffab.tar.gz | |
Merge 5.5-mwl248 -> 10.0-base
Diffstat (limited to 'mysql-test/r/create.result')
| -rw-r--r-- | mysql-test/r/create.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index 7102968a8d7..86050a3c792 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -2403,3 +2403,30 @@ a b 1 1 drop table t1; # +# Checking that CREATE IF NOT EXISTS is not blocked by running SELECT +# +create table t1 (a int, b int) engine=myisam; +create table t2 (a int, b int) engine=myisam; +insert into t1 values (1,1); +lock tables t1 read; +set @@lock_wait_timeout=5; +create table if not exists t1 (a int, b int); +Warnings: +Note 1050 Table 't1' already exists +create table if not exists t1 (a int, b int) select 2,2; +Warnings: +Note 1050 Table 't1' already exists +create table if not exists t1 like t2; +Warnings: +Note 1050 Table 't1' already exists +create table t1 (a int, b int); +ERROR 42S01: Table 't1' already exists +create table t1 (a int, b int) select 2,2; +ERROR 42S01: Table 't1' already exists +create table t1 like t2; +ERROR 42S01: Table 't1' already exists +select * from t1; +a b +1 1 +unlock tables; +drop table t1,t2; |