| 1 |
# |
| 2 |
# MDEV-29741 SHOW BINLOG EVENTS shows garbage with system_versioning_insert_history=on |
| 3 |
# MDEV-29732 mysqlbinlog produces syntactically incorrect output with system_versioning_insert_history |
| 4 |
# |
| 5 |
reset master; |
| 6 |
set timestamp=1000000000; |
| 7 |
create table t (a int) with system versioning; |
| 8 |
set system_versioning_insert_history= on; |
| 9 |
insert into t (a) values (1); |
| 10 |
set system_versioning_insert_history= off; |
| 11 |
drop table t; |
| 12 |
include/show_binlog_events.inc |
| 13 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 14 |
master-bin.000001 # Gtid # # GTID #-#-# |
| 15 |
master-bin.000001 # Query # # use `test`; create table t (a int) with system versioning |
| 16 |
master-bin.000001 # Gtid # # BEGIN GTID #-#-# |
| 17 |
master-bin.000001 # Query # # use `test`; set @@system_versioning_insert_history=1; insert into t (a) values (1) |
| 18 |
master-bin.000001 # Query # # set @@system_versioning_insert_history=1; COMMIT |
| 19 |
master-bin.000001 # Gtid # # GTID #-#-# |
| 20 |
master-bin.000001 # Query # # use `test`; DROP TABLE `t` /* generated by server */ |
| 21 |
flush binary logs; |
| 22 |
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; |
| 23 |
/*!40019 SET @@session.max_delayed_threads=0*/; |
| 24 |
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; |
| 25 |
DELIMITER /*!*/; |
| 26 |
ROLLBACK/*!*/; |
| 27 |
use `test`/*!*/; |
| 28 |
SET TIMESTAMP=1000000000/*!*/; |
| 29 |
SET @@session.pseudo_thread_id=999999999/*!*/; |
| 30 |
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=1, @@session.system_versioning_insert_history=0/*!*/; |
| 31 |
SET @@session.sql_mode=1411383296/*!*/; |
| 32 |
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; |
| 33 |
/*!\C latin1 *//*!*/; |
| 34 |
SET @@session.character_set_client=latin1,@@session.collation_connection=8,@@session.collation_server=2304/*!*/; |
| 35 |
SET @@session.lc_time_names=0/*!*/; |
| 36 |
SET @@session.collation_database=DEFAULT/*!*/; |
| 37 |
create table t (a int) with system versioning |
| 38 |
/*!*/; |
| 39 |
START TRANSACTION |
| 40 |
/*!*/; |
| 41 |
SET TIMESTAMP=1000000000/*!*/; |
| 42 |
SET @@session.system_versioning_insert_history=1/*!*/; |
| 43 |
insert into t (a) values (1) |
| 44 |
/*!*/; |
| 45 |
SET TIMESTAMP=1000000000/*!*/; |
| 46 |
COMMIT |
| 47 |
/*!*/; |
| 48 |
SET TIMESTAMP=1000000000/*!*/; |
| 49 |
SET @@session.system_versioning_insert_history=0/*!*/; |
| 50 |
DROP TABLE `t` /* generated by server */ |
| 51 |
/*!*/; |
| 52 |
DELIMITER ; |
| 53 |
# End of log file |
| 54 |
ROLLBACK /* added by mysqlbinlog */; |
| 55 |
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; |
| 56 |
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; |
| 57 |
set timestamp=default; |