22 lines
614 B
Plaintext
22 lines
614 B
Plaintext
drop table if exists gis;
|
|
CREATE TABLE gis (
|
|
g POLYGON SRID 4326 NOT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4;
|
|
CREATE SPATIAL INDEX g_idx ON gis(g);
|
|
begin;
|
|
INSERT INTO gis VALUES (
|
|
ST_GeomFromText(
|
|
'POLYGON((-165 -46,161 -70,-108 72,-165 -46))',
|
|
4326,
|
|
'axis-order=long-lat'
|
|
)
|
|
);
|
|
select OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COLUMN_NAME,
|
|
LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
|
|
from performance_schema.metadata_locks
|
|
where OBJECT_TYPE = 'SRID';
|
|
OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME COLUMN_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
|
|
SRID NULL 4326 NULL SHARED_READ TRANSACTION GRANTED
|
|
commit;
|
|
drop table gis;
|