mirror of
https://github.com/MariaDB/server.git
synced 2025-10-27 08:58:13 +01:00
32 lines
988 B
Text
32 lines
988 B
Text
-- source include/have_binlog_format_statement.inc
|
|
-- source include/have_log_bin.inc
|
|
-- source include/have_innodb.inc
|
|
#
|
|
# MBug#702303: Spurious `use` statements in output from mysqlbinlog --rewrite-db="a->b"
|
|
#
|
|
let $MYSQLD_DATADIR= `select @@datadir`;
|
|
SET TIMESTAMP=1000000000;
|
|
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb;
|
|
CREATE DATABASE test2;
|
|
|
|
RESET MASTER;
|
|
USE test2;
|
|
BEGIN;
|
|
USE test;
|
|
INSERT INTO t1 VALUES (1);
|
|
USE test2;
|
|
COMMIT;
|
|
BEGIN;
|
|
USE test;
|
|
INSERT INTO t1 VALUES (2);
|
|
USE test2;
|
|
COMMIT;
|
|
USE test;
|
|
SELECT * FROM t1 ORDER BY a;
|
|
FLUSH LOGS;
|
|
--replace_regex /@@session.sql_mode=\d+/@@session.sql_mode=#/ /collation_server=\d+/collation_server=#/
|
|
--exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 --short-form
|
|
--replace_regex /@@session.sql_mode=\d+/@@session.sql_mode=#/ /collation_server=\d+/collation_server=#/
|
|
--exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 --short-form --rewrite-db="test->foo" --rewrite-db="test2->bar"
|
|
DROP DATABASE test2;
|
|
DROP TABLE t1;
|