Debian Codegraph @

mysql-test/suite/sys_vars/inc/parser_max_mem_size_basic.inc

raw
1 #
2 # Basic test for parser_max_mem_size
3 #
4 # There are separate tests for 32bit and 64bit systems.
5 #
6 # There are separate tests for command line options
7 # --parser-max-mem-size
8 # --maximum-parser-max-mem-size
9 #
10
11 --source include/load_sysvars.inc
12
13 --echo # Display the DEFAULT value of parser_max_mem_size
14 --echo # The DEFAULT is determined by --maximum-parser-max-mem-size
15
16 SELECT @@session.parser_max_mem_size;
17 SELECT @@global.parser_max_mem_size;
18
19 SET @@session.parser_max_mem_size = DEFAULT;
20 SELECT @@session.parser_max_mem_size;
21
22 --echo # Change the value of parser_max_mem_size to a valid
23 --echo # value for SESSION Scope
24
25 SET @@session.parser_max_mem_size = 500 * 1000 * 100;
26 SELECT @@session.parser_max_mem_size;
27
28 --echo # Change the value of the session parser_max_mem_size to a
29 --echo # value greater than --maximum-parser-max-mem-size
30 SET session parser_max_mem_size = 1000 * 1000 * 100;
31 SELECT @@session.parser_max_mem_size;
32
33 --echo # Change the value of the global parser_max_mem_size to a
34 --echo # value greater than --maximum-parser-max-mem-size
35 SET @@global.parser_max_mem_size = 1000 * 1000 * 100;
36 SELECT @@global.parser_max_mem_size;
37
38 --echo # Change the value of parser_max_mem_size to an invalid value
39
40 --Error ER_WRONG_TYPE_FOR_VAR
41 SET @@session.parser_max_mem_size= 'NOT_CHAR_TYPE';
42
43 SET @@session.parser_max_mem_size = -10;
44
45 --Error ER_WRONG_TYPE_FOR_VAR
46 SET @@session.parser_max_mem_size = 0.5;
47
48 --echo # Check if TRUE and FALSE values can be used on variable
49
50 SET @@session.parser_max_mem_size = TRUE;
51 SELECT @@session.parser_max_mem_size;
52
53 SET @@session.parser_max_mem_size = FALSE;
54 SELECT @@session.parser_max_mem_size;
55
56 --echo # Restore initial value
57
58 SET @@session.parser_max_mem_size = DEFAULT;
59 SELECT @@session.parser_max_mem_size;
60
61 --echo # Creating a new user
62 CREATE USER example;
63 connect(conn_example, localhost, example,,);
64
65 --echo # example user sets 45000000
66 SET @@session.parser_max_mem_size = 45000000;
67
68 --connection default
69
70 --echo # default sets global 40000000
71 SET @@global.parser_max_mem_size = 40000000;
72
73 -- connection conn_example
74
75 --echo # example user sets 45000000
76 SET @@session.parser_max_mem_size = 45000000;
77 SELECT @@session.parser_max_mem_size;
78
79 --echo # example user sets DEFAULT, which is now 40000000
80 SET @@session.parser_max_mem_size = DEFAULT;
81 SELECT @@session.parser_max_mem_size;
82
83 --echo # disconnect
84 disconnect conn_example;
85 --source include/wait_until_disconnected.inc
86 -- connection default
87
88 --echo # default sets sesion 45000000
89 SET @@session.parser_max_mem_size = 45000000;
90 SELECT @@session.parser_max_mem_size;
91
92 DROP USER example;
93
94 SET @@global.parser_max_mem_size = DEFAULT;
95
96 --echo # END OF parser_max_mem_size TESTS