Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.default_tmp_storage_engine;
2 SELECT @start_global_value;
3 @start_global_value
4 MyISAM
5 SET @start_session_value = @@session.default_tmp_storage_engine;
6 SELECT @start_session_value;
7 @start_session_value
8 MyISAM
9 '#--------------------FN_DYNVARS_005_01-------------------------#'
10 SET @@global.default_tmp_storage_engine = INNODB;
11 SET @@global.default_tmp_storage_engine = DEFAULT;
12 SELECT @@global.default_tmp_storage_engine;
13 @@global.default_tmp_storage_engine
14 MyISAM
15 SET @@session.default_tmp_storage_engine = INNODB;
16 SET @@session.default_tmp_storage_engine = DEFAULT;
17 SELECT @@session.default_tmp_storage_engine;
18 @@session.default_tmp_storage_engine
19 MyISAM
20 '#--------------------FN_DYNVARS_005_02-------------------------#'
21 SET @@global.default_tmp_storage_engine = MYISAM;
22 SELECT @@global.default_tmp_storage_engine;
23 @@global.default_tmp_storage_engine
24 MyISAM
25 '#--------------------FN_DYNVARS_005_03-------------------------#'
26 SET @@session.default_tmp_storage_engine = MYISAM;
27 SELECT @@session.default_tmp_storage_engine;
28 @@session.default_tmp_storage_engine
29 MyISAM
30 '#---------------------FN_DYNVARS_001_8----------------------#'
31 SET @@default_tmp_storage_engine = MYISAM;
32 SELECT @@default_tmp_storage_engine = @@local.default_tmp_storage_engine;
33 @@default_tmp_storage_engine = @@local.default_tmp_storage_engine
34 1
35 SELECT @@local.default_tmp_storage_engine = @@session.default_tmp_storage_engine;
36 @@local.default_tmp_storage_engine = @@session.default_tmp_storage_engine
37 1
38 SET @@default_tmp_storage_engine = @start_global_value;
39 SET default_tmp_storage_engine = MyISAM;
40 SET default_storage_engine = MyISAM;
41 CREATE TABLE t1 (a INT);
42 CREATE TEMPORARY TABLE t2 (b INT);
43 SHOW CREATE TABLE t1;
44 Table Create Table
45 t1 CREATE TABLE `t1` (
46 `a` int DEFAULT NULL
47 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
48 SHOW CREATE TABLE t2;
49 Table Create Table
50 t2 CREATE TEMPORARY TABLE `t2` (
51 `b` int DEFAULT NULL
52 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
53 DROP TABLE t1, t2;
54 SET default_tmp_storage_engine = DEFAULT;
55 SET default_storage_engine = DEFAULT;
56 CREATE TABLE t1 (a INT);
57 CREATE TEMPORARY TABLE t2 (b INT);
58 SHOW CREATE TABLE t1;
59 Table Create Table
60 t1 CREATE TABLE `t1` (
61 `a` int DEFAULT NULL
62 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
63 SHOW CREATE TABLE t2;
64 Table Create Table
65 t2 CREATE TEMPORARY TABLE `t2` (
66 `b` int DEFAULT NULL
67 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
68 DROP TABLE t1, t2;
69 SET @@global.default_tmp_storage_engine = @start_global_value;
70 SELECT @@global.default_tmp_storage_engine;
71 @@global.default_tmp_storage_engine
72 MyISAM
73 SET @@session.default_tmp_storage_engine = @start_session_value;
74 SELECT @@session.default_tmp_storage_engine;
75 @@session.default_tmp_storage_engine
76 MyISAM