diff options
| author | Igor Babaev <igor@askmonty.org> | 2012-09-10 22:22:57 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2012-09-10 22:22:57 -0700 |
| commit | ff36e9fc518a4f8b463a09aeb9499c4552a27534 (patch) | |
| tree | 2cd741c8d2bd0776e66386ca4935d23d83de933f /mysql-test/r/stat_tables_rbr.result | |
| parent | 8c131f1262099d4088f3c83642bd09cd83aab148 (diff) | |
| download | mariadb-git-ff36e9fc518a4f8b463a09aeb9499c4552a27534.tar.gz | |
Fixed bug mdev-485.
RBR should be turned off when statistical tables are modified
in the result of the execution of a DDL statement.
Revised the fix for bug mdev-463. Ensured suppression of RBR
for the modifications of the statistical tables triggered
by the execution of any analyze operation.
Diffstat (limited to 'mysql-test/r/stat_tables_rbr.result')
| -rw-r--r-- | mysql-test/r/stat_tables_rbr.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/stat_tables_rbr.result b/mysql-test/r/stat_tables_rbr.result index 7a0d23193e7..0bcf5e9cb93 100644 --- a/mysql-test/r/stat_tables_rbr.result +++ b/mysql-test/r/stat_tables_rbr.result @@ -8,3 +8,18 @@ Table Op Msg_type Msg_text test.t1 analyze status OK DROP TABLE t1; SET GLOBAL use_stat_tables = DEFAULT; +SET use_stat_tables = PREFERABLY; +CREATE TABLE t1 ( a INT ) ENGINE=MyISAM PARTITION BY HASH(a) PARTITIONS 2; +ALTER TABLE t1 ANALYZE PARTITION p1; +Table Op Msg_type Msg_text +test.t1 analyze status OK +SHOW BINLOG EVENTS; +Log_name Pos Event_type Server_id End_log_pos Info +master-bin.000001 4 Format_desc 1 245 Server ver: 5.5.27-MariaDB-debug-log, Binlog ver: 4 +master-bin.000001 245 Query 1 345 use `test`; CREATE TABLE t1 (i INT) ENGINE=InnoDB +master-bin.000001 345 Query 1 424 use `test`; ANALYZE TABLE t1 +master-bin.000001 424 Query 1 528 use `test`; DROP TABLE `t1` /* generated by server */ +master-bin.000001 528 Query 1 664 use `test`; CREATE TABLE t1 ( a INT ) ENGINE=MyISAM PARTITION BY HASH(a) PARTITIONS 2 +master-bin.000001 664 Query 1 762 use `test`; ALTER TABLE t1 ANALYZE PARTITION p1 +SET use_stat_tables = DEFAULT; +DROP TABLE t1; |