Debian Codegraph @

mysql-test/suite/sys_vars/r/default_tmp_storage_engine_rocksdb.result

raw
1 #
2 # MDEV-12914: Engine for temporary tables which are implicitly
3 # created as RocksDB is substitued siliently with MyIsam
4 SET default_tmp_storage_engine = engine_doesnt_exist;
5 ERROR 42000: Unknown storage engine 'engine_doesnt_exist'
6 SET default_tmp_storage_engine = rocksdb;
7 ERROR HY000: Table storage engine 'ROCKSDB' does not support the create option 'TEMPORARY'
8 SET default_tmp_storage_engine = CONCAT('rocks','db');
9 ERROR HY000: Table storage engine 'ROCKSDB' does not support the create option 'TEMPORARY'
10 CREATE TABLE t1 (i int) ENGINE = RocksDB;
11 SHOW CREATE TABLE t1;
12 Table Create Table
13 t1 CREATE TABLE `t1` (
14 `i` int(11) DEFAULT NULL
15 ) ENGINE=ROCKSDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
16 CREATE TEMPORARY TABLE t2 LIKE t1;
17 ERROR HY000: Table storage engine 'ROCKSDB' does not support the create option 'TEMPORARY'
18 DROP TABLE t1;
19 SET default_storage_engine = DEFAULT;
20 SET default_tmp_storage_engine = DEFAULT;
21 CREATE TABLE t1 (t int);
22 SHOW CREATE TABLE t1;
23 Table Create Table
24 t1 CREATE TABLE `t1` (
25 `t` int(11) DEFAULT NULL
26 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
27 CREATE TEMPORARY TABLE t2 LIKE t1;
28 SHOW CREATE TABLE t2;
29 Table Create Table
30 t2 CREATE TEMPORARY TABLE `t2` (
31 `t` int(11) DEFAULT NULL
32 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
33 DROP TABLE t1, t2;
34 SET default_storage_engine = rocksdb;
35 SET default_tmp_storage_engine = default;
36 CREATE TABLE t1 (t int);
37 SHOW CREATE TABLE t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `t` int(11) DEFAULT NULL
41 ) ENGINE=ROCKSDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
42 CREATE TEMPORARY TABLE t2 LIKE t1;
43 ERROR HY000: Table storage engine 'ROCKSDB' does not support the create option 'TEMPORARY'
44 CREATE TEMPORARY TABLE t2 (t int);
45 ERROR HY000: Table storage engine 'ROCKSDB' does not support the create option 'TEMPORARY'
46 SET default_tmp_storage_engine = aria;
47 CREATE TEMPORARY TABLE t2 (t int);
48 DROP TABLE t2;
49 CREATE TEMPORARY TABLE t2 LIKE t1;
50 ERROR HY000: Table storage engine 'ROCKSDB' does not support the create option 'TEMPORARY'
51 DROP TABLE t1;
52 #
53 # MDEV-26242: Assertion `i >= 0' failed on setting
54 # default_tmp_storage_engine to 'DEFAULT' in 10.7
55 #
56 SHOW VARIABLES like '%storage_engine';
57 Variable_name Value
58 default_storage_engine ROCKSDB
59 default_tmp_storage_engine Aria
60 enforce_storage_engine
61 storage_engine ROCKSDB
62 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;
63 @@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 NULL MyISAM MyISAM Aria ROCKSDB ROCKSDB
65 SELECT @@GLOBAL.table_type;
66 ERROR HY000: Unknown system variable 'table_type'
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 @@GLOBAL.default_tmp_storage_engine @@GLOBAL.default_storage_engine @@GLOBAL.storage_engine @@SESSION.default_tmp_storage_engine @@SESSION.default_storage_engine @@SESSION.storage_engine
71 NULL MyISAM MyISAM InnoDB MyISAM MyISAM
72 CREATE TABLE t (t int);
73 CREATE TEMPORARY TABLE t1 (t int);
74 SHOW CREATE TABLE t;
75 Table Create Table
76 t CREATE TABLE `t` (
77 `t` int(11) DEFAULT NULL
78 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
79 SHOW CREATE TABLE t1;
80 Table Create Table
81 t1 CREATE TEMPORARY TABLE `t1` (
82 `t` int(11) DEFAULT NULL
83 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
84 DROP TABLE t1, t;
85 SET GLOBAL default_tmp_storage_engine='default';
86 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;
87 @@GLOBAL.default_tmp_storage_engine @@GLOBAL.default_storage_engine @@GLOBAL.storage_engine @@SESSION.default_tmp_storage_engine @@SESSION.default_storage_engine @@SESSION.storage_engine
88 MyISAM MyISAM MyISAM InnoDB MyISAM MyISAM
89 CREATE TABLE t (t int);
90 CREATE TEMPORARY TABLE t1 (t int);
91 SHOW CREATE TABLE t;
92 Table Create Table
93 t CREATE TABLE `t` (
94 `t` int(11) DEFAULT NULL
95 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
96 SHOW CREATE TABLE t1;
97 Table Create Table
98 t1 CREATE TEMPORARY TABLE `t1` (
99 `t` int(11) DEFAULT NULL
100 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
101 DROP TABLE t1, t;
102 SET GLOBAL default_tmp_storage_engine=NULL;