diff options
| author | Michael Widenius <monty@askmonty.org> | 2012-12-16 20:49:57 +0200 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2012-12-16 20:49:57 +0200 |
| commit | b31909ffbb967b147b9570af4ff7d03de6d5912c (patch) | |
| tree | 78d72d4c5fa2c003d5402fa30e3c183853c4f8d0 /mysql-test/t/create.test | |
| parent | 33f3a11e2db38fad3c43ce3c1a30dc8d72bd53bd (diff) | |
| download | mariadb-git-b31909ffbb967b147b9570af4ff7d03de6d5912c.tar.gz | |
Removed lock wait timeout warning when using CREATE TABLE IF EXISTS
mysql-test/r/create.result:
Added test case to show that CREATE TABLE also is not waiting if table exists.
mysql-test/t/create.test:
Added test case to show that CREATE TABLE also is not waiting if table exists.
sql/sql_base.cc:
Clear also warnings from acquire_locks if we retry.
Diffstat (limited to 'mysql-test/t/create.test')
| -rw-r--r-- | mysql-test/t/create.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test index c472c9f0a05..4c9592e9dab 100644 --- a/mysql-test/t/create.test +++ b/mysql-test/t/create.test @@ -2013,6 +2013,12 @@ create table if not exists t1 (a int, b int); create table if not exists t1 (a int, b int) select 2,2; --error ER_TABLE_EXISTS_ERROR create table if not exists t1 like t2; +--error ER_TABLE_EXISTS_ERROR +create table t1 (a int, b int); +--error ER_TABLE_EXISTS_ERROR +create table t1 (a int, b int) select 2,2; +--error ER_TABLE_EXISTS_ERROR +create table t1 like t2; disconnect user1; connection default; select * from t1; |