Debian Codegraph @

mysql-test/suite/perfschema/t/gis_metadata_locks.test

raw
1
2 --disable_warnings
3 drop table if exists gis;
4 --enable_warnings
5
6 CREATE TABLE gis (
7 g POLYGON SRID 4326 NOT NULL
8 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
9
10 CREATE SPATIAL INDEX g_idx ON gis(g);
11
12 begin;
13
14 INSERT INTO gis VALUES (
15 ST_GeomFromText(
16 'POLYGON((-165 -46,161 -70,-108 72,-165 -46))',
17 4326,
18 'axis-order=long-lat'
19 )
20 );
21
22 select OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COLUMN_NAME,
23 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
24 from performance_schema.metadata_locks
25 where OBJECT_TYPE = 'SRID';
26
27 commit;
28
29 drop table gis;
30