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;
22SELECT @@session.parser_max_mem_size;
23@@session.parser_max_mem_size
24100000000
25# Change the value of the global parser_max_mem_size to a
26# value greater than --maximum-parser-max-mem-size
27SET @@global.parser_max_mem_size = 1000 * 1000 * 100;
28SELECT @@global.parser_max_mem_size;
29@@global.parser_max_mem_size
30100000000
31# Change the value of parser_max_mem_size to an invalid value
32SET @@session.parser_max_mem_size= 'NOT_CHAR_TYPE';
33ERROR 42000: Incorrect argument type to variable 'parser_max_mem_size'
34SET @@session.parser_max_mem_size = -10;
35Warnings:
36Warning	1292	Truncated incorrect parser_max_mem_size value: '-10'
37SET @@session.parser_max_mem_size = 0.5;
38ERROR 42000: Incorrect argument type to variable 'parser_max_mem_size'
39# Check if TRUE and FALSE values can be used on variable
40SET @@session.parser_max_mem_size = TRUE;
41Warnings:
42Warning	1292	Truncated incorrect parser_max_mem_size value: '1'
43SELECT @@session.parser_max_mem_size;
44@@session.parser_max_mem_size
4510000000
46SET @@session.parser_max_mem_size = FALSE;
47Warnings:
48Warning	1292	Truncated incorrect parser_max_mem_size value: '0'
49SELECT @@session.parser_max_mem_size;
50@@session.parser_max_mem_size
5110000000
52# Restore initial value
53SET @@session.parser_max_mem_size = DEFAULT;
54SELECT @@session.parser_max_mem_size;
55@@session.parser_max_mem_size
56100000000
57# Creating a new user
58CREATE USER example;
59# example user sets 45000000
60SET @@session.parser_max_mem_size = 45000000;
61# default sets global 40000000
62SET @@global.parser_max_mem_size = 40000000;
63# example user sets 45000000
64SET @@session.parser_max_mem_size = 45000000;
65Warnings:
66Warning	1292	Truncated incorrect parser_max_mem_size value: '45000000'
67SELECT @@session.parser_max_mem_size;
68@@session.parser_max_mem_size
6940000000
70# example user sets DEFAULT, which is now 40000000
71SET @@session.parser_max_mem_size = DEFAULT;
72SELECT @@session.parser_max_mem_size;
73@@session.parser_max_mem_size
7440000000
75# disconnect
76# default sets sesion 45000000
77SET @@session.parser_max_mem_size = 45000000;
78SELECT @@session.parser_max_mem_size;
79@@session.parser_max_mem_size
8045000000
81DROP USER example;
82SET @@global.parser_max_mem_size = DEFAULT;
83# END OF parser_max_mem_size TESTS
84SELECT @@global.parser_max_mem_size;
85@@global.parser_max_mem_size
8618446744073709551615
87# global default is now "infite", must reset it to silence mtr.
88SET @@global.parser_max_mem_size = 50000000;
89SELECT @@global.parser_max_mem_size;
90@@global.parser_max_mem_size
9150000000
92