diff options
author | unknown <sasha@asksasha.com> | 2005-08-18 21:40:14 -0600 |
---|---|---|
committer | unknown <sasha@asksasha.com> | 2005-08-18 21:40:14 -0600 |
commit | 4652c6b0539032fe2f3654f8ec95153ac6eb9305 (patch) | |
tree | c8008bd34ce2f1e36a8ea21a5caa972aca9fcdb3 /mysql-test/t/rpl_drop_db.test | |
parent | 6345af6d4716ebfcdcb3ff1a14dc04339424b7cd (diff) | |
download | mariadb-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.test | 13 |
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); |