Debian Codegraph @

mysql-test/suite/encryption/r/innodb-spatial-index.result

raw
1 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
2 c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB
3 ENCRYPTED=YES;
4 Got one of the listed errors
5 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
6 c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB;
7 ALTER TABLE t1 ENCRYPTED=YES;
8 Got one of the listed errors
9 DROP TABLE t1;
10 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
11 c VARCHAR(256), coordinate POINT NOT NULL)
12 PAGE_COMPRESSED=YES, ENCRYPTED=YES ENGINE=INNODB;
13 ALTER TABLE t1 ADD SPATIAL INDEX b1(coordinate), ALGORITHM=COPY;
14 Got one of the listed errors
15 ALTER TABLE t1 ADD SPATIAL INDEX b2(coordinate), FORCE, ALGORITHM=INPLACE;
16 Got one of the listed errors
17 ALTER TABLE t1 ADD SPATIAL INDEX(coordinate);
18 Got one of the listed errors
19 CREATE SPATIAL INDEX b3 on t1(coordinate);
20 Got one of the listed errors
21 DROP TABLE t1;
22 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
23 c VARCHAR(256), coordinate POINT NOT NULL) ENCRYPTED=DEFAULT ENGINE=INNODB;
24 CREATE SPATIAL INDEX b on t1(coordinate);
25 INSERT INTO t1 values(1, 'secret', ST_GeomFromText('POINT(903994614 180726515)'));
26 ALTER TABLE t1 DROP INDEX b;
27 INSERT INTO t1 values(2, 'secret', ST_GeomFromText('POINT(903994614 180726515)'));
28 ALTER TABLE t1 ADD SPATIAL INDEX b(coordinate);
29 INSERT INTO t1 values(3, 'secret', ST_GeomFromText('POINT(903994614 180726515)'));
30 DROP TABLE t1;
31 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
32 c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB;
33 CREATE TABLE t2 (pk INT PRIMARY KEY AUTO_INCREMENT,
34 c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB PAGE_COMPRESSED=YES;
35 INSERT INTO t1 values(1, 'secret', ST_GeomFromText('POINT(903994614 180726515)'));
36 INSERT INTO t2 values(1, 'secret', ST_GeomFromText('POINT(903994614 180726515)'));
37 # Success!
38 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION > 0;
39 NAME
40 innodb_system
41 innodb_undo001
42 innodb_undo002
43 innodb_undo003
44 mysql/innodb_index_stats
45 mysql/innodb_table_stats
46 mysql/transaction_registry
47 test/t1
48 test/t2
49 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
50 NAME
51 DROP TABLE t1, t2;