1SET @start_global_value = @@global.default_tmp_storage_engine; 2SELECT @start_global_value; 3@start_global_value 4InnoDB 5SET @start_session_value = @@session.default_tmp_storage_engine; 6SELECT @start_session_value; 7@start_session_value 8InnoDB 9'#--------------------FN_DYNVARS_005_01-------------------------#' 10SET @@global.default_tmp_storage_engine = INNODB; 11SET @@global.default_tmp_storage_engine = DEFAULT; 12SELECT @@global.default_tmp_storage_engine; 13@@global.default_tmp_storage_engine 14InnoDB 15SET @@session.default_tmp_storage_engine = INNODB; 16SET @@session.default_tmp_storage_engine = DEFAULT; 17SELECT @@session.default_tmp_storage_engine; 18@@session.default_tmp_storage_engine 19InnoDB 20'#--------------------FN_DYNVARS_005_02-------------------------#' 21SET @@global.default_tmp_storage_engine = MYISAM; 22SELECT @@global.default_tmp_storage_engine; 23@@global.default_tmp_storage_engine 24MyISAM 25SET @@global.default_tmp_storage_engine = MERGE; 26SELECT @@global.default_tmp_storage_engine; 27@@global.default_tmp_storage_engine 28MRG_MYISAM 29SET @@global.default_tmp_storage_engine = MEMORY; 30SELECT @@global.default_tmp_storage_engine; 31@@global.default_tmp_storage_engine 32MEMORY 33SET @@global.default_tmp_storage_engine = INNODB; 34SELECT @@global.default_tmp_storage_engine; 35@@global.default_tmp_storage_engine 36InnoDB 37'#--------------------FN_DYNVARS_005_03-------------------------#' 38SET @@session.default_tmp_storage_engine = MYISAM; 39SELECT @@session.default_tmp_storage_engine; 40@@session.default_tmp_storage_engine 41MyISAM 42SET @@session.default_tmp_storage_engine = MERGE; 43SELECT @@session.default_tmp_storage_engine; 44@@session.default_tmp_storage_engine 45MRG_MYISAM 46SET @@session.default_tmp_storage_engine = MEMORY; 47SELECT @@session.default_tmp_storage_engine; 48@@session.default_tmp_storage_engine 49MEMORY 50SET @@session.default_tmp_storage_engine = INNODB; 51SELECT @@session.default_tmp_storage_engine; 52@@session.default_tmp_storage_engine 53InnoDB 54'#------------------FN_DYNVARS_005_04-----------------------#' 55SET @@global.default_tmp_storage_engine = 8199; 56ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine' 57SET @@global.default_tmp_storage_engine = NULL; 58ERROR 42000: Variable 'default_tmp_storage_engine' can't be set to the value of 'NULL' 59SET @@global.default_tmp_storage_engine = -1024; 60ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine' 61SET @@global.default_tmp_storage_engine = 65530.34; 62ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine' 63SET @@global.default_tmp_storage_engine = FILE; 64ERROR 42000: Unknown storage engine 'FILE' 65SET @@session.default_tmp_storage_engine = 8199; 66ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine' 67SET @@session.default_tmp_storage_engine = 65530.34; 68ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine' 69SET @@session.default_tmp_storage_engine = RECORD; 70ERROR 42000: Unknown storage engine 'RECORD' 71'#------------------FN_DYNVARS_005_05-----------------------#' 72SELECT @@global.default_tmp_storage_engine = 73VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 74WHERE VARIABLE_NAME='default_tmp_storage_engine'; 75@@global.default_tmp_storage_engine = 76VARIABLE_VALUE 771 78'#------------------FN_DYNVARS_005_06-----------------------#' 79SELECT @@session.default_tmp_storage_engine = 80VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 81WHERE VARIABLE_NAME='default_tmp_storage_engine'; 82@@session.default_tmp_storage_engine = 83VARIABLE_VALUE 841 85'#------------------FN_DYNVARS_005_07-----------------------#' 86SET @@global.default_tmp_storage_engine = TRUE; 87ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine' 88SET @@global.default_tmp_storage_engine = FALSE; 89ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine' 90'#---------------------FN_DYNVARS_001_8----------------------#' 91SET @@default_tmp_storage_engine = MYISAM; 92SELECT @@default_tmp_storage_engine = @@local.default_tmp_storage_engine; 93@@default_tmp_storage_engine = @@local.default_tmp_storage_engine 941 95SELECT @@local.default_tmp_storage_engine = @@session.default_tmp_storage_engine; 96@@local.default_tmp_storage_engine = @@session.default_tmp_storage_engine 971 98'#---------------------FN_DYNVARS_001_9----------------------#' 99SET default_tmp_storage_engine = MEMORY; 100SELECT @@default_tmp_storage_engine; 101@@default_tmp_storage_engine 102MEMORY 103SELECT local.default_tmp_storage_engine; 104ERROR 42S02: Unknown table 'local' in field list 105SELECT session.default_tmp_storage_engine; 106ERROR 42S02: Unknown table 'session' in field list 107SELECT default_tmp_storage_engine = @@session.default_tmp_storage_engine; 108ERROR 42S22: Unknown column 'default_tmp_storage_engine' in 'field list' 109SET @@default_tmp_storage_engine = @start_global_value; 110SET default_tmp_storage_engine = MyISAM; 111SET default_storage_engine = MyISAM; 112CREATE TABLE t1 (a INT); 113CREATE TEMPORARY TABLE t2 (b INT); 114SHOW CREATE TABLE t1; 115Table Create Table 116t1 CREATE TABLE `t1` ( 117 `a` int(11) DEFAULT NULL 118) ENGINE=MyISAM DEFAULT CHARSET=latin1 119SHOW CREATE TABLE t2; 120Table Create Table 121t2 CREATE TEMPORARY TABLE `t2` ( 122 `b` int(11) DEFAULT NULL 123) ENGINE=MyISAM DEFAULT CHARSET=latin1 124DROP TABLE t1, t2; 125SET default_tmp_storage_engine = InnoDB; 126CREATE TABLE t1 (a INT); 127CREATE TEMPORARY TABLE t2 (b INT); 128SHOW CREATE TABLE t1; 129Table Create Table 130t1 CREATE TABLE `t1` ( 131 `a` int(11) DEFAULT NULL 132) ENGINE=MyISAM DEFAULT CHARSET=latin1 133SHOW CREATE TABLE t2; 134Table Create Table 135t2 CREATE TEMPORARY TABLE `t2` ( 136 `b` int(11) DEFAULT NULL 137) ENGINE=InnoDB DEFAULT CHARSET=latin1 138DROP TABLE t1, t2; 139SET default_storage_engine = MEMORY; 140CREATE TABLE t1 (a INT); 141CREATE TEMPORARY TABLE t2 (b INT); 142SHOW CREATE TABLE t1; 143Table Create Table 144t1 CREATE TABLE `t1` ( 145 `a` int(11) DEFAULT NULL 146) ENGINE=MEMORY DEFAULT CHARSET=latin1 147SHOW CREATE TABLE t2; 148Table Create Table 149t2 CREATE TEMPORARY TABLE `t2` ( 150 `b` int(11) DEFAULT NULL 151) ENGINE=InnoDB DEFAULT CHARSET=latin1 152DROP TABLE t1, t2; 153SET default_tmp_storage_engine = DEFAULT; 154SET default_storage_engine = DEFAULT; 155CREATE TABLE t1 (a INT); 156CREATE TEMPORARY TABLE t2 (b INT); 157SHOW CREATE TABLE t1; 158Table Create Table 159t1 CREATE TABLE `t1` ( 160 `a` int(11) DEFAULT NULL 161) ENGINE=InnoDB DEFAULT CHARSET=latin1 162SHOW CREATE TABLE t2; 163Table Create Table 164t2 CREATE TEMPORARY TABLE `t2` ( 165 `b` int(11) DEFAULT NULL 166) ENGINE=InnoDB DEFAULT CHARSET=latin1 167DROP TABLE t1, t2; 168SET @@global.default_tmp_storage_engine = @start_global_value; 169SELECT @@global.default_tmp_storage_engine; 170@@global.default_tmp_storage_engine 171InnoDB 172SET @@session.default_tmp_storage_engine = @start_session_value; 173SELECT @@session.default_tmp_storage_engine; 174@@session.default_tmp_storage_engine 175InnoDB 176