Debian Codegraph @

mysql-test/suite/encryption/t/innodb-spatial-index.test

raw
1 --source include/have_innodb.inc
2 --source include/have_file_key_management_plugin.inc
3 --source include/innodb_checksum_algorithm.inc
4
5 #
6 # MDEV-11974: MariaDB 10.2 encryption does not support spatial indexes
7 #
8
9 #
10 #
11 #
12 let $checksum_algorithm = `SELECT @@innodb_checksum_algorithm`;
13 let $error_code = ER_CANT_CREATE_TABLE, ER_ILLEGAL_HA_CREATE_OPTION;
14 if ($checksum_algorithm == "full_crc32")
15 {
16 let $error_code = 0;
17 }
18 if ($checksum_algorithm == "strict_full_crc32")
19 {
20 let $error_code = 0;
21 }
22
23 --error $error_code
24 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
25 c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB
26 ENCRYPTED=YES;
27
28 if (!$error_code) {
29 INSERT INTO t1(c, coordinate) values('mysql', ST_GeomFromText('POINT(903994614 180726515)'));
30 --source include/restart_mysqld.inc
31 INSERT INTO t1(c, coordinate) values('mariadb', ST_GeomFromText('POINT(903994614 180726515)'));
32 DROP TABLE t1;
33 }
34
35 #
36 # (2) Alter table
37 #
38 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
39 c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB;
40 --error $error_code
41 ALTER TABLE t1 ENCRYPTED=YES;
42 DROP TABLE t1;
43
44 #
45 # Index creation
46 #
47 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
48 c VARCHAR(256), coordinate POINT NOT NULL)
49 PAGE_COMPRESSED=YES, ENCRYPTED=YES ENGINE=INNODB;
50 # FIXME: MDEV-13851 Encrypted table refuses some form of ALGORITHM=COPY,
51 # but allows rebuild by FORCE
52 --error $error_code
53 ALTER TABLE t1 ADD SPATIAL INDEX b1(coordinate), ALGORITHM=COPY;
54 --error $error_code
55 ALTER TABLE t1 ADD SPATIAL INDEX b2(coordinate), FORCE, ALGORITHM=INPLACE;
56 --error $error_code
57 ALTER TABLE t1 ADD SPATIAL INDEX(coordinate);
58 --error $error_code
59 CREATE SPATIAL INDEX b3 on t1(coordinate);
60 DROP TABLE t1;
61
62 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
63 c VARCHAR(256), coordinate POINT NOT NULL) ENCRYPTED=DEFAULT ENGINE=INNODB;
64 CREATE SPATIAL INDEX b on t1(coordinate);
65 INSERT INTO t1 values(1, 'secret', ST_GeomFromText('POINT(903994614 180726515)'));
66 ALTER TABLE t1 DROP INDEX b;
67 INSERT INTO t1 values(2, 'secret', ST_GeomFromText('POINT(903994614 180726515)'));
68 ALTER TABLE t1 ADD SPATIAL INDEX b(coordinate);
69 INSERT INTO t1 values(3, 'secret', ST_GeomFromText('POINT(903994614 180726515)'));
70 DROP TABLE t1;
71 #
72 # (3) Default encryption should still work
73 #
74
75 CREATE TABLE t1 (pk INT PRIMARY KEY AUTO_INCREMENT,
76 c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB;
77 CREATE TABLE t2 (pk INT PRIMARY KEY AUTO_INCREMENT,
78 c VARCHAR(256), coordinate POINT NOT NULL, SPATIAL index(coordinate)) ENGINE=INNODB PAGE_COMPRESSED=YES;
79
80 INSERT INTO t1 values(1, 'secret', ST_GeomFromText('POINT(903994614 180726515)'));
81 INSERT INTO t2 values(1, 'secret', ST_GeomFromText('POINT(903994614 180726515)'));
82
83 --let $wait_timeout=600
84 --let $wait_condition=SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
85 --source include/wait_condition.inc
86
87 --echo # Success!
88
89 --sorted_result
90 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION > 0;
91 --sorted_result
92 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
93
94 DROP TABLE t1, t2;