SELECT @@global.connection_memory_limit; @@global.connection_memory_limit 18446744073709551615 SELECT @@session.connection_memory_limit; @@session.connection_memory_limit 18446744073709551615 SET @@global.connection_memory_limit = 25666777; SELECT @@global.connection_memory_limit; @@global.connection_memory_limit 25666777 SET @@session.connection_memory_limit = 25666777; SELECT @@session.connection_memory_limit; @@session.connection_memory_limit 25666777 SET @@global.connection_memory_limit = -5666777; Warnings: Warning 1292 Truncated incorrect connection_memory_limit value: '-5666777' SELECT @@global.connection_memory_limit; @@global.connection_memory_limit 2097152 SET @@session.connection_memory_limit = -5666777; Warnings: Warning 1292 Truncated incorrect connection_memory_limit value: '-5666777' SELECT @@session.connection_memory_limit; @@session.connection_memory_limit 2097152 SET @@global.connection_memory_limit = -1; Warnings: Warning 1292 Truncated incorrect connection_memory_limit value: '-1' SELECT @@global.connection_memory_limit; @@global.connection_memory_limit 2097152 SET @@session.connection_memory_limit = -1; Warnings: Warning 1292 Truncated incorrect connection_memory_limit value: '-1' SELECT @@session.connection_memory_limit; @@session.connection_memory_limit 2097152 SET @@global.connection_memory_limit = 0; Warnings: Warning 1292 Truncated incorrect connection_memory_limit value: '0' SELECT @@global.connection_memory_limit; @@global.connection_memory_limit 2097152 SET @@session.connection_memory_limit = 0; Warnings: Warning 1292 Truncated incorrect connection_memory_limit value: '0' SELECT @@session.connection_memory_limit; @@session.connection_memory_limit 2097152 SET @@global.connection_memory_limit = default; SET @@session.connection_memory_limit = default; SET @@global.connection_memory_limit = NULL; ERROR 42000: Incorrect argument type to variable 'connection_memory_limit' SELECT @@global.connection_memory_limit; @@global.connection_memory_limit 18446744073709551615 SET @@session.connection_memory_limit = NULL; ERROR 42000: Incorrect argument type to variable 'connection_memory_limit' SELECT @@session.connection_memory_limit; @@session.connection_memory_limit 18446744073709551615 SET @@global.connection_memory_limit = 'foo'; ERROR 42000: Incorrect argument type to variable 'connection_memory_limit' SELECT @@global.connection_memory_limit; @@global.connection_memory_limit 18446744073709551615 SET @@session.connection_memory_limit = 'foo'; ERROR 42000: Incorrect argument type to variable 'connection_memory_limit' SELECT @@session.connection_memory_limit; @@session.connection_memory_limit 18446744073709551615