| 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; |