Debian Codegraph @

mysql-test/suite/x/r/gis_spatial_functions.result

raw
1 create user insertsqluser@localhost identified by 'insertsqluser';
2 grant all on *.* to insertsqluser@localhost;
3 RUN DROP SCHEMA if EXISTS mysqlxplugin
4
5 0 rows affected
6 RUN CREATE SCHEMA mysqlxplugin
7
8 1 rows affected
9 RUN USE mysqlxplugin
10
11 0 rows affected
12 RUN CREATE TABLE tab(c1 int NOT NULL PRIMARY KEY,c2 POINT NOT NULL SRID 0,
13 c3 LINESTRING NOT NULL,c4 POLYGON NOT NULL SRID 0,c5 GEOMETRY NOT NULL)
14 ENGINE=InnoDB ROW_FORMAT=COMPRESSED
15
16 0 rows affected
17 RUN CREATE SPATIAL INDEX idx1 on tab(c2)
18
19 0 rows affected
20 Records: 0 Duplicates: 0 Warnings: 0
21 RUN CREATE SPATIAL INDEX idx3 on tab(c4) KEY_BLOCK_SIZE=8
22
23 0 rows affected
24 Records: 0 Duplicates: 0 Warnings: 0
25 RUN INSERT INTO tab(c1,c2,c3,c4,c5)
26 VALUES(1,ST_GeomFromText('POINT(10 10)'),ST_GeomFromText('LINESTRING(5 5,20 20,30 30)'),
27 ST_GeomFromText('POLYGON((30 30,40 40,50 50,30 50,30 40,30 30))'),
28 ST_GeomFromText('POLYGON((30 30,40 40,50 50,30 50,30 40,30 30))'))
29
30 1 rows affected
31 RUN INSERT INTO tab(c1,c2,c3,c4,c5)
32 VALUES(2,ST_GeomFromText('POINT(20 20)'),ST_GeomFromText('LINESTRING(20 20,30 30,40 40)'),
33 ST_GeomFromText('POLYGON((40 50,40 70,50 100,70 100,80 80,70 50,40 50))'),
34 ST_GeomFromText('POLYGON((40 50,40 70,50 100,70 100,80 80,70 50,40 50))'))
35
36 1 rows affected
37 RUN INSERT INTO tab(c1,c2,c3,c4,c5)
38 VALUES(3,ST_GeomFromText('POINT(4 4)'),ST_GeomFromText('LINESTRING(130 130,140 140,150 150)'),
39 ST_GeomFromText('POLYGON((7 1,6 2,6 3,10 3,10 1,7 1))'),
40 ST_GeomFromText('POLYGON((4 -2,5 -4,6 -5,7 -4,7 2,4 -2))'))
41
42 1 rows affected
43 RUN INSERT INTO tab(c1,c2,c3,c4,c5)
44 VALUES(4,ST_GeomFromText('POINT(50 50)'),ST_GeomFromText('LINESTRING(200 200,300 300,400 400)'),
45 ST_GeomFromText('POLYGON((300 300,400 400,500 500,300 500,300 400,300 300))'),
46 ST_GeomFromText('POLYGON((300 300,400 400,500 500,300 500,300 400,300 300))'))
47
48 1 rows affected
49 RUN INSERT INTO tab(c1,c2,c3,c4,c5)
50 VALUES(5,ST_GeomFromText('POINT(3 3)'),ST_GeomFromText('LINESTRING(400 400,500 500,600 700)'),
51 ST_GeomFromText('POLYGON((1010 1010,1020 1020,1030 1030,1040 1030,1020 1010,1010 1010))'),
52 ST_GeomFromText('POLYGON((1010 1010,1020 1020,1030 1030,1040 1030,1020 1010,1010 1010))'))
53
54 1 rows affected
55 RUN INSERT INTO tab(c1,c2,c3,c4,c5)
56 VALUES(6,ST_GeomFromText('POINT(3 3)'),ST_GeomFromText('LINESTRING(40 40,50 50,60 70)'),
57 ST_GeomFromText('POLYGON((2010 2010,2020 2020,2030 2030,2040 2030,2020 2010,2010 2010))'),
58 ST_GeomFromText('POLYGON((2010 2010,2020 2020,2030 2030,2040 2030,2020 2010,2010 2010))'))
59
60 1 rows affected
61 RUN INSERT INTO tab(c1,c2,c3,c4,c5)
62 VALUES(7,ST_GeomFromText('POINT(60 70)'),ST_GeomFromText('LINESTRING(40 40,50 50,60 70)'),
63 ST_GeomFromText('POLYGON((3010 3010,3020 3020,3030 3030,3040 3030,3020 3010,3010 3010))'),
64 ST_GeomFromText('POLYGON((3010 3010,3020 3020,3030 3030,3040 3030,3020 3010,3010 3010))'))
65
66 1 rows affected
67 RUN INSERT INTO tab(c1,c2,c3,c4,c5)
68 VALUES(8,ST_GeomFromText('POINT(0 0)'),ST_GeomFromText('LINESTRING(40 40,50 50,60 70)'),
69 ST_GeomFromText('POLYGON((3010 3010,3020 3020,3030 3030,3040 3030,3020 3010,3010 3010))'),
70 ST_GeomFromText('POLYGON((3010 3010,3020 3020,3030 3030,3040 3030,3020 3010,3010 3010))'))
71
72 1 rows affected
73 RUN INSERT INTO tab(c1,c2,c3,c4,c5)
74 VALUES(9,ST_GeomFromText('POINT(120 120)'),ST_GeomFromText('LINESTRING(100 100,110 110,120 120)'),
75 ST_GeomFromText('POLYGON((4010 4010,4020 4020,4030 4030,4040 4030,4020 4010,4010 4010))'),
76 ST_GeomFromText('POLYGON((4010 4010,4020 4020,4030 4030,4040 4030,4020 4010,4010 4010))'))
77
78 1 rows affected
79 RUN INSERT INTO tab(c1,c2,c3,c4,c5)
80 VALUES(10,ST_GeomFromText('POINT(160 160)'),ST_GeomFromText('LINESTRING(140 140,150 150,160 160)'),
81 ST_GeomFromText('POLYGON((5010 5010,5020 5020,5030 5030,5040 5030,5020 5010,5010 5010))'),
82 ST_GeomFromText('POLYGON((5010 5010,5020 5020,5030 5030,5040 5030,5020 5010,5010 5010))'))
83
84 1 rows affected
85 RUN SET @g1 = ST_GeomFromText( 'POLYGON((7 1,6 2,6 3,10 3,10 1,7 1))')
86
87 0 rows affected
88 RUN SELECT c1,ST_Astext(c4) FROM tab WHERE MBRContains(tab.c4, @g1) ORDER BY c1
89 c1 ST_Astext(c4)
90 3 POLYGON((7 1,6 2,6 3,10 3,10 1,7 1))
91 0 rows affected
92 RUN SET @g1 = ST_GeomFromText( 'POLYGON((30 30,40 40,50 50,30 50,30 40,30 30)) ')
93
94 0 rows affected
95 RUN SELECT c1,ST_Astext(c4) FROM tab WHERE MBRWithin(tab.c4, @g1) ORDER BY c1
96 c1 ST_Astext(c4)
97 1 POLYGON((30 30,40 40,50 50,30 50,30 40,30 30))
98 0 rows affected
99 RUN SET @g1 = ST_GeomFromText('POLYGON((100 200,200 300,400 500,500 300,300 200,100 300,100 200))')
100
101 0 rows affected
102 RUN SELECT c1,ST_Astext(c4) FROM tab WHERE ST_Crosses(tab.c4, @g1) ORDER BY c1
103 c1 ST_Astext(c4)
104 0 rows affected
105 RUN SET @g1 = ST_GeomFromText('POLYGON((4 -2,5 -4,6 -5,7 -4,7 2,4 -2))')
106
107 0 rows affected
108 RUN SELECT c1,ST_Astext(c4) FROM tab WHERE MBRDisjoint(tab.c4, @g1) ORDER BY c1
109 c1 ST_Astext(c4)
110 1 POLYGON((30 30,40 40,50 50,30 50,30 40,30 30))
111 2 POLYGON((40 50,40 70,50 100,70 100,80 80,70 50,40 50))
112 4 POLYGON((300 300,400 400,500 500,300 500,300 400,300 300))
113 5 POLYGON((1010 1010,1020 1020,1030 1030,1040 1030,1020 1010,1010 1010))
114 6 POLYGON((2010 2010,2020 2020,2030 2030,2040 2030,2020 2010,2010 2010))
115 7 POLYGON((3010 3010,3020 3020,3030 3030,3040 3030,3020 3010,3010 3010))
116 8 POLYGON((3010 3010,3020 3020,3030 3030,3040 3030,3020 3010,3010 3010))
117 9 POLYGON((4010 4010,4020 4020,4030 4030,4040 4030,4020 4010,4010 4010))
118 10 POLYGON((5010 5010,5020 5020,5030 5030,5040 5030,5020 5010,5010 5010))
119 0 rows affected
120 RUN SET @g1 = ST_GeomFromText('POLYGON((5010 5010,5020 5020,5030 5030,5040 5030,5020 5010,5010 5010))')
121
122 0 rows affected
123 RUN SELECT c1,ST_Astext(c4) FROM tab WHERE MBREquals(tab.c4, @g1) ORDER BY c1
124 c1 ST_Astext(c4)
125 10 POLYGON((5010 5010,5020 5020,5030 5030,5040 5030,5020 5010,5010 5010))
126 0 rows affected
127 RUN SET @g1 = ST_GeomFromText( 'POLYGON((0 0,0 30,30 40,40 50,50 30,0 0))')
128
129 0 rows affected
130 RUN SELECT c1,ST_Astext(c4) FROM tab WHERE MBRIntersects(tab.c4, @g1) ORDER BY c1
131 c1 ST_Astext(c4)
132 1 POLYGON((30 30,40 40,50 50,30 50,30 40,30 30))
133 2 POLYGON((40 50,40 70,50 100,70 100,80 80,70 50,40 50))
134 3 POLYGON((7 1,6 2,6 3,10 3,10 1,7 1))
135 0 rows affected
136 RUN SET @g1 = ST_GeomFromText( 'POLYGON((0 0,0 2,4 5,5 5,7 1,0 0 ))')
137
138 0 rows affected
139 RUN SELECT c1,ST_Astext(c4) FROM tab WHERE MBROverlaps(tab.c4, @g1) ORDER BY c1
140 c1 ST_Astext(c4)
141 3 POLYGON((7 1,6 2,6 3,10 3,10 1,7 1))
142 0 rows affected
143 RUN SET @g1 = ST_GeomFromText( 'POLYGON((0 0,0 30,30 40,40 50,50 30,0 0))')
144
145 0 rows affected
146 RUN SELECT c1,ST_Astext(c4) FROM tab WHERE ST_Touches(tab.c4, @g1) ORDER BY c1
147 c1 ST_Astext(c4)
148 2 POLYGON((40 50,40 70,50 100,70 100,80 80,70 50,40 50))
149 0 rows affected
150 Mysqlx.Ok {
151 msg: "bye!"
152 }
153 ok
154 RUN USE mysqlxplugin
155
156 0 rows affected
157 RUN DROP TABLE tab
158
159 0 rows affected
160 RUN DROP SCHEMA if EXISTS mysqlxplugin
161
162 0 rows affected
163 RUN DROP USER insertsqluser@localhost
164
165 0 rows affected
166 Mysqlx.Ok {
167 msg: "bye!"
168 }
169 ok