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