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