| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
# |
| 4 |
# MDEV-35160 RBR does not work with vector type, ER_SLAVE_CONVERSION_FAILED |
| 5 |
# |
| 6 |
create table t (pk int primary key, a vector(1) not null); |
| 7 |
insert into t values (1, 0x00000000); |
| 8 |
connection slave; |
| 9 |
select pk, vec_totext(a) from t; |
| 10 |
pk vec_totext(a) |
| 11 |
1 [0] |
| 12 |
connection master; |
| 13 |
drop table t; |
| 14 |
# |
| 15 |
# MDEV-35204 mysqlbinlog --verbose fails on row events with vector type |
| 16 |
# |
| 17 |
flush binary logs; |
| 18 |
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; |
| 19 |
/*!40019 SET @@session.max_delayed_threads=0*/; |
| 20 |
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; |
| 21 |
DELIMITER /*!*/; |
| 22 |
ROLLBACK/*!*/; |
| 23 |
/*M!100101 SET @@session.skip_parallel_replication=0*//*!*/; |
| 24 |
/*M!100001 SET @@session.gtid_domain_id=0*//*!*/; |
| 25 |
/*M!100001 SET @@session.server_id=1*//*!*/; |
| 26 |
/*M!100001 SET @@session.gtid_seq_no=1*//*!*/; |
| 27 |
use `test`/*!*/; |
| 28 |
SET @@session.pseudo_thread_id=123/*!*/; |
| 29 |
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/*!*/; |
| 30 |
SET @@session.sql_mode=1411383296/*!*/; |
| 31 |
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; |
| 32 |
/*!\C latin1 *//*!*/; |
| 33 |
SET @@session.character_set_client=latin1,@@session.collation_connection=8,@@session.collation_server=2304/*!*/; |
| 34 |
SET @@session.lc_time_names=0/*!*/; |
| 35 |
SET @@session.collation_database=DEFAULT/*!*/; |
| 36 |
create table t (pk int primary key, a vector(1) not null) |
| 37 |
/*!*/; |
| 38 |
/*M!100001 SET @@session.gtid_seq_no=2*//*!*/; |
| 39 |
START TRANSACTION |
| 40 |
/*!*/; |
| 41 |
#Q> insert into t values (1, 0x00000000) |
| 42 |
### INSERT INTO `test`.`t` |
| 43 |
### SET |
| 44 |
### @1=1 |
| 45 |
### @2='\x00\x00\x00\x00' |
| 46 |
# Number of rows: 1 |
| 47 |
COMMIT |
| 48 |
/*!*/; |
| 49 |
/*M!100001 SET @@session.gtid_seq_no=3*//*!*/; |
| 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 |
include/rpl_end.inc |