Debian Codegraph @

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

raw
1 # Display the DEFAULT value of parser_max_mem_size
2 # The DEFAULT is determined by --maximum-parser-max-mem-size
3 SELECT @@session.parser_max_mem_size;
4 @@session.parser_max_mem_size
5 50000000
6 SELECT @@global.parser_max_mem_size;
7 @@global.parser_max_mem_size
8 50000000
9 SET @@session.parser_max_mem_size = DEFAULT;
10 SELECT @@session.parser_max_mem_size;
11 @@session.parser_max_mem_size
12 50000000
13 # Change the value of parser_max_mem_size to a valid
14 # value for SESSION Scope
15 SET @@session.parser_max_mem_size = 500 * 1000 * 100;
16 SELECT @@session.parser_max_mem_size;
17 @@session.parser_max_mem_size
18 50000000
19 # Change the value of the session parser_max_mem_size to a
20 # value greater than --maximum-parser-max-mem-size
21 SET session parser_max_mem_size = 1000 * 1000 * 100;
22 SELECT @@session.parser_max_mem_size;
23 @@session.parser_max_mem_size
24 100000000
25 # Change the value of the global parser_max_mem_size to a
26 # value greater than --maximum-parser-max-mem-size
27 SET @@global.parser_max_mem_size = 1000 * 1000 * 100;
28 SELECT @@global.parser_max_mem_size;
29 @@global.parser_max_mem_size
30 100000000
31 # Change the value of parser_max_mem_size to an invalid value
32 SET @@session.parser_max_mem_size= 'NOT_CHAR_TYPE';
33 ERROR 42000: Incorrect argument type to variable 'parser_max_mem_size'
34 SET @@session.parser_max_mem_size = -10;
35 Warnings:
36 Warning 1292 Truncated incorrect parser_max_mem_size value: '-10'
37 SET @@session.parser_max_mem_size = 0.5;
38 ERROR 42000: Incorrect argument type to variable 'parser_max_mem_size'
39 # Check if TRUE and FALSE values can be used on variable
40 SET @@session.parser_max_mem_size = TRUE;
41 Warnings:
42 Warning 1292 Truncated incorrect parser_max_mem_size value: '1'
43 SELECT @@session.parser_max_mem_size;
44 @@session.parser_max_mem_size
45 10000000
46 SET @@session.parser_max_mem_size = FALSE;
47 Warnings:
48 Warning 1292 Truncated incorrect parser_max_mem_size value: '0'
49 SELECT @@session.parser_max_mem_size;
50 @@session.parser_max_mem_size
51 10000000
52 # Restore initial value
53 SET @@session.parser_max_mem_size = DEFAULT;
54 SELECT @@session.parser_max_mem_size;
55 @@session.parser_max_mem_size
56 100000000
57 # Creating a new user
58 CREATE USER example;
59 # example user sets 45000000
60 SET @@session.parser_max_mem_size = 45000000;
61 # default sets global 40000000
62 SET @@global.parser_max_mem_size = 40000000;
63 # example user sets 45000000
64 SET @@session.parser_max_mem_size = 45000000;
65 Warnings:
66 Warning 1292 Truncated incorrect parser_max_mem_size value: '45000000'
67 SELECT @@session.parser_max_mem_size;
68 @@session.parser_max_mem_size
69 40000000
70 # example user sets DEFAULT, which is now 40000000
71 SET @@session.parser_max_mem_size = DEFAULT;
72 SELECT @@session.parser_max_mem_size;
73 @@session.parser_max_mem_size
74 40000000
75 # disconnect
76 # default sets sesion 45000000
77 SET @@session.parser_max_mem_size = 45000000;
78 SELECT @@session.parser_max_mem_size;
79 @@session.parser_max_mem_size
80 45000000
81 DROP USER example;
82 SET @@global.parser_max_mem_size = DEFAULT;
83 # END OF parser_max_mem_size TESTS
84 SELECT @@global.parser_max_mem_size;
85 @@global.parser_max_mem_size
86 18446744073709551615
87 # global default is now "infite", must reset it to silence mtr.
88 SET @@global.parser_max_mem_size = 50000000;
89 SELECT @@global.parser_max_mem_size;
90 @@global.parser_max_mem_size
91 50000000