Debian Codegraph @

mysql-test/suite/rpl/r/rpl_gis_srs.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 SET @number_of_srss =
7 (SELECT COUNT(*) FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS);
8 CREATE SPATIAL REFERENCE SYSTEM 1000000000
9 NAME 'foo_1000000000'
10 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
11 CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 1000000001
12 NAME 'foo_1000000001'
13 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
14 CREATE SPATIAL REFERENCE SYSTEM IF NOT EXISTS 1000000002
15 NAME 'foo_1000000002'
16 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
17 SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
18 SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
19 foo_1000000000 1000000000 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
20 foo_1000000001 1000000001 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
21 foo_1000000002 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
22 include/sync_slave_sql_with_master.inc
23 [Connection Slave]
24 SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
25 SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
26 foo_1000000000 1000000000 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
27 foo_1000000001 1000000001 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
28 foo_1000000002 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
29 SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000));
30 ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000))
31 1000000000
32 SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000001));
33 ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000001))
34 1000000001
35 SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002));
36 ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002))
37 1000000002
38 [Connection Master]
39 DROP SPATIAL REFERENCE SYSTEM 1000000000;
40 DROP SPATIAL REFERENCE SYSTEM 1000000001;
41 CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 1000000002
42 NAME 'foo_1000000000'
43 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
44 SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID = 1000000002;
45 SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
46 foo_1000000000 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
47 include/sync_slave_sql_with_master.inc
48 [Connection Slave]
49 SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID = 1000000002;
50 SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
51 foo_1000000000 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
52 SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002));
53 ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002))
54 1000000002
55 [Connection Master]
56 DROP SPATIAL REFERENCE SYSTEM IF EXISTS 1000000002;
57 SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
58 SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
59 include/sync_slave_sql_with_master.inc
60 [Connection Slave]
61 SELECT * FROM INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS WHERE SRS_ID = 1000000000;
62 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME SRS_NAME SRS_ID GEOMETRY_TYPE_NAME
63 SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000));
64 ERROR SR001: There's no spatial reference system with SRID 1000000000.
65 [Connection Master]
66 BEGIN;
67 CREATE SPATIAL REFERENCE SYSTEM 1000000000
68 NAME 'foo_1000000000'
69 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
70 CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 1000000001
71 NAME 'foo_1000000001'
72 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
73 CREATE SPATIAL REFERENCE SYSTEM IF NOT EXISTS 1000000002
74 NAME 'foo_1000000002'
75 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
76 SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
77 SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
78 foo_1000000000 1000000000 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
79 foo_1000000001 1000000001 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
80 foo_1000000002 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
81 include/sync_slave_sql_with_master.inc
82 [Connection Slave]
83 SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
84 SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
85 foo_1000000000 1000000000 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
86 foo_1000000001 1000000001 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
87 foo_1000000002 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
88 SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000));
89 ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000))
90 1000000000
91 SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000001));
92 ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000001))
93 1000000001
94 SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002));
95 ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002))
96 1000000002
97 [Connection Master]
98 COMMIT;
99 BEGIN;
100 DROP SPATIAL REFERENCE SYSTEM 1000000000;
101 DROP SPATIAL REFERENCE SYSTEM 1000000001;
102 DROP SPATIAL REFERENCE SYSTEM IF EXISTS 1000000002;
103 include/sync_slave_sql_with_master.inc
104 [Connection Slave]
105 SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
106 SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
107 SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
108 SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
109 SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000));
110 ERROR SR001: There's no spatial reference system with SRID 1000000000.
111 SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000001));
112 ERROR SR001: There's no spatial reference system with SRID 1000000001.
113 SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002));
114 ERROR SR001: There's no spatial reference system with SRID 1000000002.
115 [Connection Master]
116 COMMIT;
117 SELECT @number_of_srss = COUNT(*) AS should_be_true
118 FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS;
119 should_be_true
120 1
121 include/sync_slave_sql_with_master.inc
122 include/rpl_end.inc