mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
36 lines
1.6 KiB
Text
36 lines
1.6 KiB
Text
--- innodb-spatial-index.result
|
|
+++ innodb-spatial-index.result
|
|
@@ -1,23 +1,27 @@
|
|
CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
|
|
c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB
|
|
ENCRYPTED=YES;
|
|
-Got one of the listed errors
|
|
+INSERT INTO t1(c, coordinate) values('mysql', ST_GeomFromText('POINT(903994614 180726515)'));
|
|
+# restart
|
|
+INSERT INTO t1(c, coordinate) values('mariadb', ST_GeomFromText('POINT(903994614 180726515)'));
|
|
+DROP TABLE t1;
|
|
CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
|
|
c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB;
|
|
ALTER TABLE t1 ENCRYPTED=YES;
|
|
-Got one of the listed errors
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
|
|
c VARCHAR(256), coordinate POINT NOT NULL)
|
|
PAGE_COMPRESSED=YES, ENCRYPTED=YES ENGINE=INNODB;
|
|
ALTER TABLE t1 ADD SPATIAL INDEX b1(coordinate), ALGORITHM=COPY;
|
|
-Got one of the listed errors
|
|
ALTER TABLE t1 ADD SPATIAL INDEX b2(coordinate), FORCE, ALGORITHM=INPLACE;
|
|
-Got one of the listed errors
|
|
+Warnings:
|
|
+Note 1831 Duplicate index `b2`. This is deprecated and will be disallowed in a future release
|
|
ALTER TABLE t1 ADD SPATIAL INDEX(coordinate);
|
|
-Got one of the listed errors
|
|
+Warnings:
|
|
+Note 1831 Duplicate index `coordinate`. This is deprecated and will be disallowed in a future release
|
|
CREATE SPATIAL INDEX b3 on t1(coordinate);
|
|
-Got one of the listed errors
|
|
+Warnings:
|
|
+Note 1831 Duplicate index `b3`. This is deprecated and will be disallowed in a future release
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
|
|
c VARCHAR(256), coordinate POINT NOT NULL) ENCRYPTED=DEFAULT ENGINE=INNODB;
|