Debian Codegraph @

mysql-test/suite/encryption/r/innodb-spatial-index,full_crc32.rdiff

raw
1 --- innodb-spatial-index.result
2 +++ innodb-spatial-index.result
3 @@ -1,23 +1,27 @@
4 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
5 c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB
6 ENCRYPTED=YES;
7 -Got one of the listed errors
8 +INSERT INTO t1(c, coordinate) values('mysql', ST_GeomFromText('POINT(903994614 180726515)'));
9 +# restart
10 +INSERT INTO t1(c, coordinate) values('mariadb', ST_GeomFromText('POINT(903994614 180726515)'));
11 +DROP TABLE t1;
12 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
13 c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB;
14 ALTER TABLE t1 ENCRYPTED=YES;
15 -Got one of the listed errors
16 DROP TABLE t1;
17 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
18 c VARCHAR(256), coordinate POINT NOT NULL)
19 PAGE_COMPRESSED=YES, ENCRYPTED=YES ENGINE=INNODB;
20 ALTER TABLE t1 ADD SPATIAL INDEX b1(coordinate), ALGORITHM=COPY;
21 -Got one of the listed errors
22 ALTER TABLE t1 ADD SPATIAL INDEX b2(coordinate), FORCE, ALGORITHM=INPLACE;
23 -Got one of the listed errors
24 +Warnings:
25 +Note 1831 Duplicate index `b2`. This is deprecated and will be disallowed in a future release
26 ALTER TABLE t1 ADD SPATIAL INDEX(coordinate);
27 -Got one of the listed errors
28 +Warnings:
29 +Note 1831 Duplicate index `coordinate`. This is deprecated and will be disallowed in a future release
30 CREATE SPATIAL INDEX b3 on t1(coordinate);
31 -Got one of the listed errors
32 +Warnings:
33 +Note 1831 Duplicate index `b3`. This is deprecated and will be disallowed in a future release
34 DROP TABLE t1;
35 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
36 c VARCHAR(256), coordinate POINT NOT NULL) ENCRYPTED=DEFAULT ENGINE=INNODB;