Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 # Column with SRID property on a MyISAM table should only be
7 # supported if the SRID represents a cartesian coordinate system.
8 [Connection Master]
9 CREATE TABLE t1 (col1 POINT, col2 POINT SRID 4326) ENGINE = MyISAM;
10 ERROR 42000: The storage engine for the table doesn't support geographic spatial reference systems
11 CREATE TABLE t1 (col1 POINT, col2 POINT SRID 2000) ENGINE = MyISAM;
12 INSERT INTO t1(col1, col2)
13 VALUES (ST_GeomFromText('POINT(0 0)'),
14 ST_GeomFromText('POINT(0 0)', 2000));
15 INSERT INTO t1(col1, col2)
16 VALUES (ST_GeomFromText('POINT(1 1)', 2000),
17 ST_GeomFromText('POINT(1 1)', 2000));
18 include/sync_slave_sql_with_master.inc
19 [Connection Slave]
20 include/diff_tables.inc [master:t1, slave:t1]
21 SELECT * FROM INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS;
22 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME SRS_NAME SRS_ID GEOMETRY_TYPE_NAME
23 def test t1 col1 NULL NULL point
24 def test t1 col2 Anguilla 1957 / British West Indies Grid 2000 point
25 SELECT ST_SRID(col1) AS no_srid, ST_SRID(col2) AS srid_2000 FROM t1;
26 no_srid srid_2000
27 0 2000
28 2000 2000
29 [Connection Master]
30 DELETE FROM t1;
31 ALTER TABLE t1 CHANGE COLUMN col1 col1 POINT SRID 2000;
32 ALTER TABLE t1 CHANGE COLUMN col2 col2 POINT SRID 0;
33 INSERT INTO t1(col1, col2)
34 VALUES (ST_GeomFromText('POINT(0 0)', 2000),
35 ST_GeomFromText('POINT(0 0)', 0));
36 INSERT INTO t1(col1, col2)
37 VALUES (ST_GeomFromText('POINT(1 1)', 2000),
38 ST_GeomFromText('POINT(1 1)', 0));
39 SELECT * FROM INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS;
40 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME SRS_NAME SRS_ID GEOMETRY_TYPE_NAME
41 def test t1 col1 Anguilla 1957 / British West Indies Grid 2000 point
42 def test t1 col2 0 point
43 include/sync_slave_sql_with_master.inc
44 [Connection Slave]
45 include/diff_tables.inc [master:t1, slave:t1]
46 SELECT * FROM INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS;
47 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME SRS_NAME SRS_ID GEOMETRY_TYPE_NAME
48 def test t1 col1 Anguilla 1957 / British West Indies Grid 2000 point
49 def test t1 col2 0 point
50 SELECT ST_SRID(col1) AS srid_2000, ST_SRID(col2) AS srid_0 FROM t1;
51 srid_2000 srid_0
52 2000 0
53 2000 0
54 [Connection Master]
55 # Cleanup
56 DROP TABLE t1;
57 include/sync_slave_sql_with_master.inc
58 include/rpl_end.inc