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