DROP TABLE IF EXISTS test;

CREATE TABLE test (

  coordinate point NOT NULL,

  SPATIAL KEY coordinate (coordinate)

) ENGINE=Aria DEFAULT CHARSET=ascii PAGE_CHECKSUM=1;

SHOW COLUMNS FROM test;

INSERT INTO test (coordinate) VALUES(ST_PointFromText("POINT(0 0)"));

INSERT INTO test (coordinate) VALUES(ST_PointFromText("POINT(10 0)"));

INSERT INTO test (coordinate) VALUES(ST_PointFromText("POINT(10 10)"));

INSERT INTO test (coordinate) VALUES(ST_PointFromText("POINT(0 10)"));

INSERT INTO test (coordinate) VALUES(ST_PointFromText("POINT(5 5)"));

SELECT * FROM test WHERE ST_Intersects(ST_LineFromText("LINESTRING(0 0, 10 0, 10 10, 0 10)"), coordinate);

SHOW COLUMNS FROM test;

DROP TABLE test;