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