# # Bug mdev-463: assertion failure when running ANALYZE with RBR on # SET GLOBAL use_stat_tables = PREFERABLY; CREATE TABLE t1 (i INT) ENGINE=InnoDB; ANALYZE TABLE t1; 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 246 Server ver: #, Binlog ver: # master-bin.000001 246 Binlog_checkpoint 1 286 master-bin.000001 master-bin.000001 286 Query 1 386 use `test`; CREATE TABLE t1 (i INT) ENGINE=InnoDB master-bin.000001 386 Query 1 465 use `test`; ANALYZE TABLE t1 master-bin.000001 465 Query 1 569 use `test`; DROP TABLE `t1` /* generated by server */ master-bin.000001 569 Query 1 705 use `test`; CREATE TABLE t1 ( a INT ) ENGINE=MyISAM PARTITION BY HASH(a) PARTITIONS 2 master-bin.000001 705 Query 1 803 use `test`; ALTER TABLE t1 ANALYZE PARTITION p1 SET use_stat_tables = DEFAULT; DROP TABLE t1;