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