Debian Codegraph @

mysql-test/suite/rpl/t/rpl_geometry.test

raw
1 source include/have_binlog_format_row.inc;
2 source include/master-slave.inc;
3
4 #
5 # Bug#48776, Bug#43784
6 #
7 create table t1(a varchar(100),
8 b multipoint not null,
9 c varchar(256));
10
11 insert into t1 set
12 a='hello',
13 b=geomfromtext('multipoint(1 1)'),
14 c='geometry';
15
16 create table t2 (a int(11) not null auto_increment primary key,
17 b geometrycollection default null,
18 c decimal(10,0));
19
20 insert into t2(c) values (null);
21
22 sync_slave_with_master;
23
24 connection master;
25 drop table t1, t2;
26
27 --echo #
28 --echo # MDEV-30985 Replica stops with error on ALTER ONLINE with Geometry Types
29 --echo #
30 create table t(geo geometrycollection default st_geomfromtext('point(1 1)'),
31 vc point as (geo));
32 insert into t () values (),(),();
33 delete from t;
34
35 sync_slave_with_master;
36 connection master;
37 drop table t;
38
39 --source include/rpl_end.inc