Debian Codegraph @

mysql-test/suite/vcol/t/binlog.test

raw
1 --source include/have_innodb.inc
2 --source include/have_binlog_format_row.inc
3 --source include/master-slave.inc
4
5 #
6 # MDEV-15243
7 # Server crashes in in Field_blob::pack upon REPLACE into view with virtual
8 # columns with binlog enabled
9 #
10
11 CREATE TABLE t1 (
12 pk SERIAL,
13 vcol_date DATE AS (col_date) PERSISTENT,
14 vcol_int INT AS (col_int) VIRTUAL,
15 vcol_year YEAR AS (col_year) PERSISTENT,
16 vcol_blob BLOB AS (col_blob) VIRTUAL,
17 col_date DATE,
18 col_int INT NULL,
19 col_blob BLOB NULL,
20 col_year YEAR,
21 PRIMARY KEY(pk)
22 ) ENGINE=InnoDB;
23
24 INSERT INTO t1 (col_date,col_int,col_blob,col_year) VALUES ('2010-04-24',5,'foo',1981);
25 SET SQL_MODE='';
26
27 set binlog_row_image="FULL";
28 CREATE VIEW v1 AS SELECT * FROM t1;
29 REPLACE INTO v1 SELECT pk, vcol_date, vcol_int, vcol_year, vcol_blob, col_date, col_int, col_blob, 1982 FROM t1;
30 select col_date,col_int,col_blob,col_year from v1;
31 sync_slave_with_master;
32 select col_date,col_int,col_blob,col_year from v1;
33 connection master;
34 DROP VIEW v1;
35 set binlog_row_image="MINIMAL";
36 CREATE VIEW v1 AS SELECT * FROM t1;
37 REPLACE INTO v1 SELECT pk, vcol_date, vcol_int, vcol_year, vcol_blob, col_date, col_int, col_blob, 1983 FROM t1;
38 select col_date,col_int,col_blob,col_year from v1;
39 sync_slave_with_master;
40 select col_date,col_int,col_blob,col_year from v1;
41 connection master;
42 DROP VIEW v1;
43 set @@binlog_row_image="NOBLOB";
44 CREATE VIEW v1 AS SELECT * FROM t1;
45 REPLACE INTO v1 SELECT pk, vcol_date, vcol_int, vcol_year, vcol_blob, col_date, col_int, col_blob, 1984 FROM t1;
46 select col_date,col_int,col_blob,col_year from v1;
47 sync_slave_with_master;
48 select col_date,col_int,col_blob,col_year from v1;
49 connection master;
50 DROP VIEW v1;
51 set @@binlog_row_image=default;
52
53 DROP TABLE t1;
54 SET SQL_MODE=default;
55
56 # MDEV-24782
57 # ASAN use-after-poison in Field::pack_int / THD::binlog_update_row
58
59 CREATE TABLE t1 (pk INT, a VARCHAR(3), b VARCHAR(1) AS (a) VIRTUAL, PRIMARY KEY (pk));
60 INSERT IGNORE INTO t1 (pk, a) VALUES (1,'foo'),(2,'bar');
61 --error ER_DATA_TOO_LONG
62 REPLACE INTO t1 (pk) VALUES (2);
63 UPDATE IGNORE t1 SET a = NULL;
64
65 # Cleanup
66 DROP TABLE t1;
67
68
69 --echo #
70 --echo # MDEV-18166 ASSERT_COLUMN_MARKED_FOR_READ failed on tables with vcols
71 --echo #
72
73 SET SESSION binlog_row_image= noblob;
74 CREATE TEMPORARY TABLE t1 SELECT UUID();
75 show create table t1;
76 CREATE TABLE t2 (a INT PRIMARY KEY, b TEXT, c INT GENERATED ALWAYS AS(b));
77 INSERT INTO t2 (a,b) VALUES (1,1);
78
79 SET SESSION binlog_row_image= default;
80 DROP TABLE t2;
81
82
83 --source include/rpl_end.inc