summaryrefslogtreecommitdiff
path: root/mysql-test/main/drop.result
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2019-12-30 13:56:19 +0200
committerMonty <monty@mariadb.org>2020-03-24 21:00:02 +0200
commit6a9e24d0465fb0e67ba7bbc333263437e7227d8c (patch)
tree02bdd98c5cd807e55c185a6827558ddd6c9993b4 /mysql-test/main/drop.result
parente5de1e26e723525aaab1cebc5c958c748eb36d9e (diff)
downloadmariadb-git-6a9e24d0465fb0e67ba7bbc333263437e7227d8c.tar.gz
Added support for replication for S3
MDEV-19964 S3 replication support Added new configure options: s3_slave_ignore_updates "If the slave has shares same S3 storage as the master" s3_replicate_alter_as_create_select "When converting S3 table to local table, log all rows in binary log" This allows on to configure slaves to have the S3 storage shared or independent from the master. Other thing: Added new session variable '@@sql_if_exists' to force IF_EXIST to DDL's.
Diffstat (limited to 'mysql-test/main/drop.result')
-rw-r--r--mysql-test/main/drop.result17
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/main/drop.result b/mysql-test/main/drop.result
index 88e070af88c..6bbaba950bf 100644
--- a/mysql-test/main/drop.result
+++ b/mysql-test/main/drop.result
@@ -230,3 +230,20 @@ DROP TABLE table1,table2;
CREATE DATABASE mysqltest;
CREATE TABLE mysqltest.db(id INT);
DROP DATABASE mysqltest;
+#
+# Verify sql_if_exists
+#
+DROP DATABASE mysqltest;
+ERROR HY000: Can't drop database 'mysqltest'; database doesn't exist
+CREATE DATABASE mysqltest;
+drop table mysqltest.does_not_exists;
+ERROR 42S02: Unknown table 'mysqltest.does_not_exists'
+set @@session.sql_if_exists=1;
+drop table mysqltest.does_not_exists;
+Warnings:
+Note 1051 Unknown table 'mysqltest.does_not_exists'
+drop database mysqltest;
+drop database mysqltest;
+Warnings:
+Note 1008 Can't drop database 'mysqltest'; database doesn't exist
+set @@session.sql_if_exists=0;