1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
# Test of the schemaregex variable
# Schemas matching "foo*" should be excluded
# Ignore startup/shutdown events
--disable_query_log
--source ../plugin/transaction_log/tests/t/truncate_log.inc
--enable_query_log
CREATE SCHEMA foo;
CREATE SCHEMA foobar;
CREATE SCHEMA bar;
USE foobar;
CREATE TABLE foo1 (a INT NOT NULL PRIMARY KEY);
INSERT INTO foo1 VALUES (1);
UPDATE foo1 SET a = 2;
DELETE FROM foo1;
DROP SCHEMA foo;
DROP SCHEMA foobar;
DROP SCHEMA bar;
--echo
--echo We should only see the 'bar' schema in the log
--echo
--replace_result $DRIZZLETEST_VARDIR VARDIR
--exec $DRIZZLE_TRX_READER $DRIZZLETEST_VARDIR/master-data/local/transaction.log
--source ../plugin/transaction_log/tests/t/truncate_log.inc
|