Debian Codegraph @

mysql-test/suite/rpl/r/rpl_gis_user_var.result

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 #
5 #
6 connection master;
7 SET @p=POINT(1,1);
8 CREATE TABLE t1 AS SELECT @p AS p;
9 connection slave;
10 SHOW CREATE TABLE t1;
11 Table Create Table
12 t1 CREATE TABLE `t1` (
13 `p` point DEFAULT NULL
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
15 SELECT ST_AsWKT(p) FROM t1;
16 ST_AsWKT(p)
17 POINT(1 1)
18 connection master;
19 DROP TABLE t1;
20 connection slave;
21 include/rpl_end.inc