Debian Codegraph @

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

raw
1 SELECT @@global.internal_tmp_mem_storage_engine;
2 @@global.internal_tmp_mem_storage_engine
3 TempTable
4 SELECT @@session.internal_tmp_mem_storage_engine;
5 @@session.internal_tmp_mem_storage_engine
6 TempTable
7 SET @@global.internal_tmp_mem_storage_engine = 'memory';
8 SELECT @@global.internal_tmp_mem_storage_engine;
9 @@global.internal_tmp_mem_storage_engine
10 MEMORY
11 SET @@global.internal_tmp_mem_storage_engine = 'temptable';
12 SELECT @@global.internal_tmp_mem_storage_engine;
13 @@global.internal_tmp_mem_storage_engine
14 TempTable
15 SET @@session.internal_tmp_mem_storage_engine = 'memory';
16 SELECT @@session.internal_tmp_mem_storage_engine;
17 @@session.internal_tmp_mem_storage_engine
18 MEMORY
19 SET @@session.internal_tmp_mem_storage_engine = 'temptable';
20 SELECT @@session.internal_tmp_mem_storage_engine;
21 @@session.internal_tmp_mem_storage_engine
22 TempTable
23 SET @@global.internal_tmp_mem_storage_engine = 123;
24 ERROR 42000: Variable 'internal_tmp_mem_storage_engine' can't be set to the value of '123'
25 SELECT @@global.internal_tmp_mem_storage_engine;
26 @@global.internal_tmp_mem_storage_engine
27 TempTable
28 SET @@global.internal_tmp_mem_storage_engine = NULL;
29 ERROR 42000: Variable 'internal_tmp_mem_storage_engine' can't be set to the value of 'NULL'
30 SELECT @@global.internal_tmp_mem_storage_engine;
31 @@global.internal_tmp_mem_storage_engine
32 TempTable
33 SET @@global.internal_tmp_mem_storage_engine = 'foo';
34 ERROR 42000: Variable 'internal_tmp_mem_storage_engine' can't be set to the value of 'foo'
35 SELECT @@global.internal_tmp_mem_storage_engine;
36 @@global.internal_tmp_mem_storage_engine
37 TempTable
38 SET @@global.internal_tmp_mem_storage_engine = default;
39 SET @@session.internal_tmp_mem_storage_engine = default;
40 #
41 # WL#14728: internal_tmp_mem_storage_engine should
42 # require SESSION_VARIABLES_ADMIN
43 #
44 CREATE USER foo@localhost, bar@localhost;
45 GRANT SESSION_VARIABLES_ADMIN ON *.* TO foo@localhost;
46 SET @@global.internal_tmp_mem_storage_engine = 123;
47 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
48 SET @@session.internal_tmp_mem_storage_engine = 'memory';
49 SET @@global.internal_tmp_mem_storage_engine = default;
50 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
51 SET @@session.internal_tmp_mem_storage_engine = default;
52 SET @@global.internal_tmp_mem_storage_engine = 123;
53 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
54 SET @@session.internal_tmp_mem_storage_engine = 'memory';
55 ERROR 42000: Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
56 SET @@global.internal_tmp_mem_storage_engine = default;
57 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
58 SET @@session.internal_tmp_mem_storage_engine = default;
59 ERROR 42000: Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
60 REVOKE SESSION_VARIABLES_ADMIN ON *.* FROM foo@localhost;
61 DROP USER foo@localhost, bar@localhost;
62 # End of 8.0 tests