summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl_drop_db.test
diff options
context:
space:
mode:
authorunknown <sasha@asksasha.com>2005-08-18 21:40:14 -0600
committerunknown <sasha@asksasha.com>2005-08-18 21:40:14 -0600
commit4652c6b0539032fe2f3654f8ec95153ac6eb9305 (patch)
treec8008bd34ce2f1e36a8ea21a5caa972aca9fcdb3 /mysql-test/t/rpl_drop_db.test
parent6345af6d4716ebfcdcb3ff1a14dc04339424b7cd (diff)
downloadmariadb-git-4652c6b0539032fe2f3654f8ec95153ac6eb9305.tar.gz
updated patch for BUG#4680 (incomplete DROP DATABASE breaking replication).
We binlog the DROP TABLE for each table that was actually dropped. Per Sergei's suggestion a fixed buffer for the DROP TABLE query is pre-allocated from THD pool, and logging now is done in batches - new batch is started if the buffer becomes full. Reduced memory usage by reusing the table list instead of accumulating a list of dropped table names. Also fixed the problem if the table was not actually dropped, eg due to permissions. Extended the test case to make sure batched query logging does work. mysql-test/r/rpl_drop_db.result: test for query buffer overrun mysql-test/t/rpl_drop_db.test: test for query buffer overrun sql/mysql_priv.h: updated patch for BUG#4680 (incomplete DROP DATABASE breaking replication) BitKeeper/etc/ignore: Added support-files/MacOSX/postflight support-files/MacOSX/preflight to the ignore list sql/sql_db.cc: updated patch for BUG#4680 (incomplete DROP DATABASE breaking replication) sql/sql_table.cc: updated patch for BUG#4680 (incomplete DROP DATABASE breaking replication) sql/table.h: updated patch for BUG#4680 (incomplete DROP DATABASE breaking replication)
Diffstat (limited to 'mysql-test/t/rpl_drop_db.test')
-rw-r--r--mysql-test/t/rpl_drop_db.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_drop_db.test b/mysql-test/t/rpl_drop_db.test
index ef0ab4be6fd..71dc22f705f 100644
--- a/mysql-test/t/rpl_drop_db.test
+++ b/mysql-test/t/rpl_drop_db.test
@@ -17,6 +17,19 @@ create table d1.t3 (n int);
drop database d1;
use d1;
show tables;
+
+# test the branch of the code that deals with the query buffer overflow
+
+let $1=1000;
+while ($1)
+{
+ eval create table d1.t$1(n int);
+ dec $1;
+}
+--error 1010
+drop database d1;
+use d1;
+show tables;
use test;
create table t1 (n int);
insert into t1 values (1234);