Debian Codegraph @

mysql-test/suite/sys_vars/t/internal_tmp_mem_storage_engine_basic.test

raw
1 -- source include/load_sysvars.inc
2
3 SELECT @@global.internal_tmp_mem_storage_engine;
4 SELECT @@session.internal_tmp_mem_storage_engine;
5
6 SET @@global.internal_tmp_mem_storage_engine = 'memory';
7 SELECT @@global.internal_tmp_mem_storage_engine;
8
9 SET @@global.internal_tmp_mem_storage_engine = 'temptable';
10 SELECT @@global.internal_tmp_mem_storage_engine;
11
12 SET @@session.internal_tmp_mem_storage_engine = 'memory';
13 SELECT @@session.internal_tmp_mem_storage_engine;
14
15 SET @@session.internal_tmp_mem_storage_engine = 'temptable';
16 SELECT @@session.internal_tmp_mem_storage_engine;
17
18 -- error ER_WRONG_VALUE_FOR_VAR
19 SET @@global.internal_tmp_mem_storage_engine = 123;
20 SELECT @@global.internal_tmp_mem_storage_engine;
21
22 -- error ER_WRONG_VALUE_FOR_VAR
23 SET @@global.internal_tmp_mem_storage_engine = NULL;
24 SELECT @@global.internal_tmp_mem_storage_engine;
25
26 -- error ER_WRONG_VALUE_FOR_VAR
27 SET @@global.internal_tmp_mem_storage_engine = 'foo';
28 SELECT @@global.internal_tmp_mem_storage_engine;
29
30 SET @@global.internal_tmp_mem_storage_engine = default;
31 SET @@session.internal_tmp_mem_storage_engine = default;
32
33
34 --echo #
35 --echo # WL#14728: internal_tmp_mem_storage_engine should
36 --echo # require SESSION_VARIABLES_ADMIN
37 --echo #
38
39 # Save the initial number of concurrent sessions
40 --source include/count_sessions.inc
41
42 CREATE USER foo@localhost, bar@localhost;
43 GRANT SESSION_VARIABLES_ADMIN ON *.* TO foo@localhost;
44
45 connect(foo_con,localhost,foo,,);
46 #success criteria: global should fail, session should pass
47 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
48 SET @@global.internal_tmp_mem_storage_engine = 123;
49 SET @@session.internal_tmp_mem_storage_engine = 'memory';
50 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
51 SET @@global.internal_tmp_mem_storage_engine = default;
52 SET @@session.internal_tmp_mem_storage_engine = default;
53
54 connect(bar_con,localhost,bar,,);
55 #success criteria: all of the 4 statements below should fail
56 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
57 SET @@global.internal_tmp_mem_storage_engine = 123;
58 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
59 SET @@session.internal_tmp_mem_storage_engine = 'memory';
60 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
61 SET @@global.internal_tmp_mem_storage_engine = default;
62 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
63 SET @@session.internal_tmp_mem_storage_engine = default;
64
65 connection default;
66 disconnect foo_con;
67 disconnect bar_con;
68 REVOKE SESSION_VARIABLES_ADMIN ON *.* FROM foo@localhost;
69 DROP USER foo@localhost, bar@localhost;
70 # Wait till we reached the initial number of concurrent sessions
71 --source include/wait_until_count_sessions.inc
72
73
74 --echo # End of 8.0 tests
75