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