Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.default_tmp_storage_engine;
2 SELECT @start_global_value;
3 @start_global_value
4 InnoDB
5 SET @start_session_value = @@session.default_tmp_storage_engine;
6 SELECT @start_session_value;
7 @start_session_value
8 InnoDB
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 InnoDB
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 InnoDB
20 '#--------------------FN_DYNVARS_005_02-------------------------#'
21 SET @@global.default_tmp_storage_engine = MERGE;
22 SELECT @@global.default_tmp_storage_engine;
23 @@global.default_tmp_storage_engine
24 MRG_MYISAM
25 SET @@global.default_tmp_storage_engine = MEMORY;
26 SELECT @@global.default_tmp_storage_engine;
27 @@global.default_tmp_storage_engine
28 MEMORY
29 SET @@global.default_tmp_storage_engine = INNODB;
30 SELECT @@global.default_tmp_storage_engine;
31 @@global.default_tmp_storage_engine
32 InnoDB
33 '#--------------------FN_DYNVARS_005_03-------------------------#'
34 SET @@session.default_tmp_storage_engine = MERGE;
35 SELECT @@session.default_tmp_storage_engine;
36 @@session.default_tmp_storage_engine
37 MRG_MYISAM
38 SET @@session.default_tmp_storage_engine = MEMORY;
39 SELECT @@session.default_tmp_storage_engine;
40 @@session.default_tmp_storage_engine
41 MEMORY
42 SET @@session.default_tmp_storage_engine = INNODB;
43 SELECT @@session.default_tmp_storage_engine;
44 @@session.default_tmp_storage_engine
45 InnoDB
46 '#------------------FN_DYNVARS_005_04-----------------------#'
47 SET @@global.default_tmp_storage_engine = 8199;
48 ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine'
49 SET @@global.default_tmp_storage_engine = NULL;
50 ERROR 42000: Variable 'default_tmp_storage_engine' can't be set to the value of 'NULL'
51 SET @@global.default_tmp_storage_engine = -1024;
52 ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine'
53 SET @@global.default_tmp_storage_engine = 65530.34;
54 ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine'
55 SET @@global.default_tmp_storage_engine = FILE;
56 ERROR 42000: Unknown storage engine 'FILE'
57 SET @@session.default_tmp_storage_engine = 8199;
58 ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine'
59 SET @@session.default_tmp_storage_engine = 65530.34;
60 ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine'
61 SET @@session.default_tmp_storage_engine = RECORD;
62 ERROR 42000: Unknown storage engine 'RECORD'
63 '#------------------FN_DYNVARS_005_05-----------------------#'
64 SELECT @@global.default_tmp_storage_engine =
65 VARIABLE_VALUE FROM performance_schema.global_variables
66 WHERE VARIABLE_NAME='default_tmp_storage_engine';
67 @@global.default_tmp_storage_engine =
68 VARIABLE_VALUE
69 1
70 '#------------------FN_DYNVARS_005_06-----------------------#'
71 SELECT @@session.default_tmp_storage_engine =
72 VARIABLE_VALUE FROM performance_schema.session_variables
73 WHERE VARIABLE_NAME='default_tmp_storage_engine';
74 @@session.default_tmp_storage_engine =
75 VARIABLE_VALUE
76 1
77 '#------------------FN_DYNVARS_005_07-----------------------#'
78 SET @@global.default_tmp_storage_engine = TRUE;
79 ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine'
80 SET @@global.default_tmp_storage_engine = FALSE;
81 ERROR 42000: Incorrect argument type to variable 'default_tmp_storage_engine'
82 '#---------------------FN_DYNVARS_001_9----------------------#'
83 SET default_tmp_storage_engine = MEMORY;
84 SELECT @@default_tmp_storage_engine;
85 @@default_tmp_storage_engine
86 MEMORY
87 SELECT local.default_tmp_storage_engine;
88 ERROR 42S02: Unknown table 'local' in field list
89 SELECT session.default_tmp_storage_engine;
90 ERROR 42S02: Unknown table 'session' in field list
91 SELECT default_tmp_storage_engine = @@session.default_tmp_storage_engine;
92 ERROR 42S22: Unknown column 'default_tmp_storage_engine' in 'field list'
93 SET @@default_tmp_storage_engine = @start_global_value;
94 SET default_tmp_storage_engine = InnoDB;
95 CREATE TABLE t1 (a INT);
96 CREATE TEMPORARY TABLE t2 (b INT);
97 SHOW CREATE TABLE t1;
98 Table Create Table
99 t1 CREATE TABLE `t1` (
100 `a` int DEFAULT NULL
101 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
102 SHOW CREATE TABLE t2;
103 Table Create Table
104 t2 CREATE TEMPORARY TABLE `t2` (
105 `b` int DEFAULT NULL
106 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
107 DROP TABLE t1, t2;
108 SET default_storage_engine = MEMORY;
109 CREATE TABLE t1 (a INT);
110 CREATE TEMPORARY TABLE t2 (b INT);
111 SHOW CREATE TABLE t1;
112 Table Create Table
113 t1 CREATE TABLE `t1` (
114 `a` int DEFAULT NULL
115 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
116 SHOW CREATE TABLE t2;
117 Table Create Table
118 t2 CREATE TEMPORARY TABLE `t2` (
119 `b` int DEFAULT NULL
120 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
121 DROP TABLE t1, t2;
122 SET default_tmp_storage_engine = DEFAULT;
123 SET default_storage_engine = DEFAULT;
124 CREATE TABLE t1 (a INT);
125 CREATE TEMPORARY TABLE t2 (b INT);
126 SHOW CREATE TABLE t1;
127 Table Create Table
128 t1 CREATE TABLE `t1` (
129 `a` int DEFAULT NULL
130 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
131 SHOW CREATE TABLE t2;
132 Table Create Table
133 t2 CREATE TEMPORARY TABLE `t2` (
134 `b` int DEFAULT NULL
135 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
136 DROP TABLE t1, t2;
137 SET @@global.default_tmp_storage_engine = @start_global_value;
138 SELECT @@global.default_tmp_storage_engine;
139 @@global.default_tmp_storage_engine
140 InnoDB
141 SET @@session.default_tmp_storage_engine = @start_session_value;
142 SELECT @@session.default_tmp_storage_engine;
143 @@session.default_tmp_storage_engine
144 InnoDB