Debian Codegraph @

mysql-test/suite/sys_vars/t/default_tmp_storage_engine_rocksdb.test

raw
1 --echo #
2 --echo # MDEV-12914: Engine for temporary tables which are implicitly
3 --echo # created as RocksDB is substitued siliently with MyIsam
4
5 --source include/have_rocksdb.inc
6 --source include/not_embedded.inc
7 --source include/have_innodb.inc
8
9 --error ER_UNKNOWN_STORAGE_ENGINE
10 SET default_tmp_storage_engine = engine_doesnt_exist;
11 --error ER_ILLEGAL_HA_CREATE_OPTION
12 SET default_tmp_storage_engine = rocksdb;
13 --error ER_ILLEGAL_HA_CREATE_OPTION
14 SET default_tmp_storage_engine = CONCAT('rocks','db');
15
16 CREATE TABLE t1 (i int) ENGINE = RocksDB;
17 SHOW CREATE TABLE t1;
18
19 --error ER_ILLEGAL_HA_CREATE_OPTION
20 CREATE TEMPORARY TABLE t2 LIKE t1;
21
22 DROP TABLE t1;
23
24 SET default_storage_engine = DEFAULT;
25 SET default_tmp_storage_engine = DEFAULT;
26
27 CREATE TABLE t1 (t int);
28 SHOW CREATE TABLE t1;
29 CREATE TEMPORARY TABLE t2 LIKE t1;
30 SHOW CREATE TABLE t2;
31
32 DROP TABLE t1, t2;
33
34 SET default_storage_engine = rocksdb;
35 # setting default or null for tmp SE should use default SE
36 SET default_tmp_storage_engine = default;
37
38 CREATE TABLE t1 (t int);
39 SHOW CREATE TABLE t1;
40
41 --error ER_ILLEGAL_HA_CREATE_OPTION
42 CREATE TEMPORARY TABLE t2 LIKE t1;
43
44 --error ER_ILLEGAL_HA_CREATE_OPTION
45 CREATE TEMPORARY TABLE t2 (t int);
46
47 SET default_tmp_storage_engine = aria;
48 CREATE TEMPORARY TABLE t2 (t int);
49 DROP TABLE t2;
50
51 --error ER_ILLEGAL_HA_CREATE_OPTION
52 CREATE TEMPORARY TABLE t2 LIKE t1;
53
54 DROP TABLE t1;
55
56 --echo #
57 --echo # MDEV-26242: Assertion `i >= 0' failed on setting
58 --echo # default_tmp_storage_engine to 'DEFAULT' in 10.7
59 --echo #
60
61
62 SHOW VARIABLES like '%storage_engine';
63 SELECT @@GLOBAL.default_tmp_storage_engine, @@GLOBAL.default_storage_engine, @@GLOBAL.storage_engine, @@SESSION.default_tmp_storage_engine, @@SESSION.default_storage_engine, @@SESSION.storage_engine;
64 --error ER_UNKNOWN_SYSTEM_VARIABLE
65 SELECT @@GLOBAL.table_type;
66
67 SET default_storage_engine=DEFAULT;
68 SET default_tmp_storage_engine=innodb;
69 SELECT @@GLOBAL.default_tmp_storage_engine, @@GLOBAL.default_storage_engine, @@GLOBAL.storage_engine, @@SESSION.default_tmp_storage_engine, @@SESSION.default_storage_engine, @@SESSION.storage_engine;
70
71 CREATE TABLE t (t int);
72 CREATE TEMPORARY TABLE t1 (t int);
73 SHOW CREATE TABLE t;
74 SHOW CREATE TABLE t1;
75 DROP TABLE t1, t;
76
77 SET GLOBAL default_tmp_storage_engine='default';
78 SELECT @@GLOBAL.default_tmp_storage_engine, @@GLOBAL.default_storage_engine, @@GLOBAL.storage_engine, @@SESSION.default_tmp_storage_engine, @@SESSION.default_storage_engine, @@SESSION.storage_engine;
79
80 CREATE TABLE t (t int);
81 CREATE TEMPORARY TABLE t1 (t int);
82 SHOW CREATE TABLE t;
83 SHOW CREATE TABLE t1;
84 DROP TABLE t1, t;
85
86 SET GLOBAL default_tmp_storage_engine=NULL;