Debian Codegraph @

mysql-test/suite/perfschema/r/gis_metadata_locks.result

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