From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/main/create_drop_db.test | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 mysql-test/main/create_drop_db.test (limited to 'mysql-test/main/create_drop_db.test') diff --git a/mysql-test/main/create_drop_db.test b/mysql-test/main/create_drop_db.test new file mode 100644 index 00000000..13391c35 --- /dev/null +++ b/mysql-test/main/create_drop_db.test @@ -0,0 +1,32 @@ +# Enable diisplaying rows affected +--enable_info + +CREATE DATABASE IF NOT EXISTS db1; + +CREATE DATABASE IF NOT EXISTS db1; +CREATE TABLE db1.t1 (a INT); +SHOW TABLES IN db1; + +CREATE OR REPLACE DATABASE db1; +SHOW TABLES IN db1; + +--error ER_WRONG_USAGE +CREATE OR REPLACE DATABASE IF NOT EXISTS db2; + +DROP DATABASE db1; + +DROP DATABASE IF EXISTS db1; + +--error ER_DB_DROP_EXISTS +DROP DATABASE db1; + +CREATE OR REPLACE DATABASE db1; +SHOW TABLES IN db1; + +--error ER_DB_CREATE_EXISTS +CREATE DATABASE db1; + +DROP DATABASE IF EXISTS db1; +DROP DATABASE IF EXISTS db1; + +--disable_info -- cgit v1.2.3