diff options
| author | gluh@eagle.intranet.mysql.r18.ru <> | 2005-09-12 17:09:19 +0500 |
|---|---|---|
| committer | gluh@eagle.intranet.mysql.r18.ru <> | 2005-09-12 17:09:19 +0500 |
| commit | d9bd3c11e4c06e31974998dc75fc348e10c8cae1 (patch) | |
| tree | a57b033bb2eff45734871677eb2e7d04cfea7c43 /mysql-test/t/create.test | |
| parent | 2a07350854b3d13562b4d8714fed82cf11a0a31c (diff) | |
| download | mariadb-git-d9bd3c11e4c06e31974998dc75fc348e10c8cae1.tar.gz | |
Fix for bug #6008: MySQL does not create warnings when creating database and using IF NOT EXISTS
produce warning for 'create database if not exists' if database exists
do not update database options in this case
produce warning for 'create table if not exists' if table exists
Diffstat (limited to 'mysql-test/t/create.test')
| -rw-r--r-- | mysql-test/t/create.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test index 9ea810aaf7d..73184853d1a 100644 --- a/mysql-test/t/create.test +++ b/mysql-test/t/create.test @@ -513,4 +513,17 @@ create table test.t1 like x; drop table if exists test.t1; --enable_warnings +# +# Bug #6008 MySQL does not create warnings when +# creating database and using IF NOT EXISTS +# +create database mysqltest; +create database if not exists mysqltest character set latin2; +show create database mysqltest; +drop database mysqltest; +use test; +create table t1 (a int); +create table if not exists t1 (a int); +drop table t1; + # End of 4.1 tests |