1SET @start_global_value = @@global.group_concat_max_len; 2SELECT @start_global_value; 3@start_global_value 41048576 5SET @start_session_value = @@session.group_concat_max_len; 6SELECT @start_session_value; 7@start_session_value 81048576 9'#--------------------FN_DYNVARS_034_01-------------------------#' 10SET @@global.group_concat_max_len = 100; 11SET @@global.group_concat_max_len = DEFAULT; 12SELECT @@global.group_concat_max_len; 13@@global.group_concat_max_len 141048576 15SET @@session.group_concat_max_len = 200; 16SET @@session.group_concat_max_len = DEFAULT; 17SELECT @@session.group_concat_max_len; 18@@session.group_concat_max_len 191048576 20'#--------------------FN_DYNVARS_034_02-------------------------#' 21SET @@global.group_concat_max_len = DEFAULT; 22SELECT @@global.group_concat_max_len = 1; 23@@global.group_concat_max_len = 1 240 25SET @@session.group_concat_max_len = DEFAULT; 26SELECT @@session.group_concat_max_len = 1; 27@@session.group_concat_max_len = 1 280 29'#--------------------FN_DYNVARS_034_03-------------------------#' 30SET @@global.group_concat_max_len = 1; 31Warnings: 32Warning 1292 Truncated incorrect group_concat_max_len value: '1' 33SELECT @@global.group_concat_max_len; 34@@global.group_concat_max_len 354 36SET @@global.group_concat_max_len = 60020; 37SELECT @@global.group_concat_max_len; 38@@global.group_concat_max_len 3960020 40SET @@global.group_concat_max_len = 65535; 41SELECT @@global.group_concat_max_len; 42@@global.group_concat_max_len 4365535 44'#--------------------FN_DYNVARS_034_04-------------------------#' 45SET @@session.group_concat_max_len = 1; 46Warnings: 47Warning 1292 Truncated incorrect group_concat_max_len value: '1' 48SELECT @@session.group_concat_max_len; 49@@session.group_concat_max_len 504 51SET @@session.group_concat_max_len = 50050; 52SELECT @@session.group_concat_max_len; 53@@session.group_concat_max_len 5450050 55SET @@session.group_concat_max_len = 65535; 56SELECT @@session.group_concat_max_len; 57@@session.group_concat_max_len 5865535 59'#------------------FN_DYNVARS_034_05-----------------------#' 60SET @@global.group_concat_max_len = 0; 61Warnings: 62Warning 1292 Truncated incorrect group_concat_max_len value: '0' 63SELECT @@global.group_concat_max_len; 64@@global.group_concat_max_len 654 66SET @@global.group_concat_max_len = -1024; 67Warnings: 68Warning 1292 Truncated incorrect group_concat_max_len value: '-1024' 69SELECT @@global.group_concat_max_len; 70@@global.group_concat_max_len 714 72SET @@global.group_concat_max_len = 65536; 73SELECT @@global.group_concat_max_len; 74@@global.group_concat_max_len 7565536 76SET @@global.group_concat_max_len = 65530.34; 77ERROR 42000: Incorrect argument type to variable 'group_concat_max_len' 78SELECT @@global.group_concat_max_len; 79@@global.group_concat_max_len 8065536 81SET @@global.group_concat_max_len = test; 82ERROR 42000: Incorrect argument type to variable 'group_concat_max_len' 83SELECT @@global.group_concat_max_len; 84@@global.group_concat_max_len 8565536 86SET @@session.group_concat_max_len = 0; 87Warnings: 88Warning 1292 Truncated incorrect group_concat_max_len value: '0' 89SELECT @@session.group_concat_max_len; 90@@session.group_concat_max_len 914 92SET @@session.group_concat_max_len = -2; 93Warnings: 94Warning 1292 Truncated incorrect group_concat_max_len value: '-2' 95SELECT @@session.group_concat_max_len; 96@@session.group_concat_max_len 974 98SET @@session.group_concat_max_len = 65530.34; 99ERROR 42000: Incorrect argument type to variable 'group_concat_max_len' 100SET @@session.group_concat_max_len = 65550; 101SELECT @@session.group_concat_max_len; 102@@session.group_concat_max_len 10365550 104SET @@session.group_concat_max_len = test; 105ERROR 42000: Incorrect argument type to variable 'group_concat_max_len' 106SELECT @@session.group_concat_max_len; 107@@session.group_concat_max_len 10865550 109'#------------------FN_DYNVARS_034_06-----------------------#' 110SELECT @@global.group_concat_max_len = VARIABLE_VALUE 111FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 112WHERE VARIABLE_NAME='group_concat_max_len'; 113@@global.group_concat_max_len = VARIABLE_VALUE 1141 115'#------------------FN_DYNVARS_034_07-----------------------#' 116SELECT @@session.group_concat_max_len = VARIABLE_VALUE 117FROM INFORMATION_SCHEMA.SESSION_VARIABLES 118WHERE VARIABLE_NAME='group_concat_max_len'; 119@@session.group_concat_max_len = VARIABLE_VALUE 1201 121'#------------------FN_DYNVARS_034_08-----------------------#' 122SET @@global.group_concat_max_len = TRUE; 123Warnings: 124Warning 1292 Truncated incorrect group_concat_max_len value: '1' 125SELECT @@global.group_concat_max_len; 126@@global.group_concat_max_len 1274 128SET @@global.group_concat_max_len = FALSE; 129Warnings: 130Warning 1292 Truncated incorrect group_concat_max_len value: '0' 131SELECT @@global.group_concat_max_len; 132@@global.group_concat_max_len 1334 134'#---------------------FN_DYNVARS_001_09----------------------#' 135SET @@global.group_concat_max_len = 10; 136SELECT @@group_concat_max_len = @@global.group_concat_max_len; 137@@group_concat_max_len = @@global.group_concat_max_len 1380 139'#---------------------FN_DYNVARS_001_10----------------------#' 140SET @@group_concat_max_len = 100; 141SELECT @@group_concat_max_len = @@local.group_concat_max_len; 142@@group_concat_max_len = @@local.group_concat_max_len 1431 144SELECT @@local.group_concat_max_len = @@session.group_concat_max_len; 145@@local.group_concat_max_len = @@session.group_concat_max_len 1461 147'#---------------------FN_DYNVARS_001_11----------------------#' 148SET group_concat_max_len = 1; 149Warnings: 150Warning 1292 Truncated incorrect group_concat_max_len value: '1' 151SELECT @@group_concat_max_len; 152@@group_concat_max_len 1534 154SELECT local.group_concat_max_len; 155ERROR 42S02: Unknown table 'local' in field list 156SELECT session.group_concat_max_len; 157ERROR 42S02: Unknown table 'session' in field list 158SELECT group_concat_max_len = @@session.group_concat_max_len; 159ERROR 42S22: Unknown column 'group_concat_max_len' in 'field list' 160SET @@global.group_concat_max_len = @start_global_value; 161SELECT @@global.group_concat_max_len; 162@@global.group_concat_max_len 1631048576 164SET @@session.group_concat_max_len = @start_session_value; 165SELECT @@session.group_concat_max_len; 166@@session.group_concat_max_len 1671048576 168