1SET @start_global_value = @@global.max_length_for_sort_data; 2SELECT @start_global_value; 3@start_global_value 41024 5SET @start_session_value = @@session.max_length_for_sort_data; 6SELECT @start_session_value; 7@start_session_value 81024 9'#--------------------FN_DYNVARS_080_01-------------------------#' 10SET @@global.max_length_for_sort_data = 1000; 11SET @@global.max_length_for_sort_data = DEFAULT; 12SELECT @@global.max_length_for_sort_data; 13@@global.max_length_for_sort_data 141024 15SET @@session.max_length_for_sort_data = 1000; 16SET @@session.max_length_for_sort_data = DEFAULT; 17SELECT @@session.max_length_for_sort_data; 18@@session.max_length_for_sort_data 191024 20'#--------------------FN_DYNVARS_080_02-------------------------#' 21SET @@global.max_length_for_sort_data = DEFAULT; 22SELECT @@global.max_length_for_sort_data = 1024; 23@@global.max_length_for_sort_data = 1024 241 25SET @@session.max_length_for_sort_data = DEFAULT; 26SELECT @@session.max_length_for_sort_data = 1024; 27@@session.max_length_for_sort_data = 1024 281 29'#--------------------FN_DYNVARS_080_03-------------------------#' 30SET @@global.max_length_for_sort_data = 4; 31SELECT @@global.max_length_for_sort_data; 32@@global.max_length_for_sort_data 334 34SET @@global.max_length_for_sort_data = 5; 35SELECT @@global.max_length_for_sort_data; 36@@global.max_length_for_sort_data 375 38SET @@global.max_length_for_sort_data = 8388608; 39SELECT @@global.max_length_for_sort_data; 40@@global.max_length_for_sort_data 418388608 42SET @@global.max_length_for_sort_data = 8388607; 43SELECT @@global.max_length_for_sort_data; 44@@global.max_length_for_sort_data 458388607 46SET @@global.max_length_for_sort_data = 65536; 47SELECT @@global.max_length_for_sort_data; 48@@global.max_length_for_sort_data 4965536 50'#--------------------FN_DYNVARS_080_04-------------------------#' 51SET @@session.max_length_for_sort_data = 4; 52SELECT @@session.max_length_for_sort_data; 53@@session.max_length_for_sort_data 544 55SET @@session.max_length_for_sort_data = 5; 56SELECT @@session.max_length_for_sort_data; 57@@session.max_length_for_sort_data 585 59SET @@session.max_length_for_sort_data = 8388608; 60SELECT @@session.max_length_for_sort_data; 61@@session.max_length_for_sort_data 628388608 63SET @@session.max_length_for_sort_data = 8388607; 64SELECT @@session.max_length_for_sort_data; 65@@session.max_length_for_sort_data 668388607 67SET @@session.max_length_for_sort_data = 65536; 68SELECT @@session.max_length_for_sort_data; 69@@session.max_length_for_sort_data 7065536 71'#------------------FN_DYNVARS_080_05-----------------------#' 72SET @@global.max_length_for_sort_data = -1024; 73Warnings: 74Warning 1292 Truncated incorrect max_length_for_sort_data value: '-1024' 75SELECT @@global.max_length_for_sort_data; 76@@global.max_length_for_sort_data 774 78SET @@global.max_length_for_sort_data = 3; 79Warnings: 80Warning 1292 Truncated incorrect max_length_for_sort_data value: '3' 81SELECT @@global.max_length_for_sort_data; 82@@global.max_length_for_sort_data 834 84SET @@global.max_length_for_sort_data = 8388609; 85Warnings: 86Warning 1292 Truncated incorrect max_length_for_sort_data value: '8388609' 87SELECT @@global.max_length_for_sort_data; 88@@global.max_length_for_sort_data 898388608 90SET @@global.max_length_for_sort_data = 0; 91Warnings: 92Warning 1292 Truncated incorrect max_length_for_sort_data value: '0' 93SELECT @@global.max_length_for_sort_data; 94@@global.max_length_for_sort_data 954 96SET @@global.max_length_for_sort_data = 65530.34; 97ERROR 42000: Incorrect argument type to variable 'max_length_for_sort_data' 98SELECT @@global.max_length_for_sort_data; 99@@global.max_length_for_sort_data 1004 101SET @@global.max_length_for_sort_data = test; 102ERROR 42000: Incorrect argument type to variable 'max_length_for_sort_data' 103SELECT @@global.max_length_for_sort_data; 104@@global.max_length_for_sort_data 1054 106SET @@session.max_length_for_sort_data = 8388610; 107Warnings: 108Warning 1292 Truncated incorrect max_length_for_sort_data value: '8388610' 109SELECT @@session.max_length_for_sort_data; 110@@session.max_length_for_sort_data 1118388608 112SET @@session.max_length_for_sort_data = -1; 113Warnings: 114Warning 1292 Truncated incorrect max_length_for_sort_data value: '-1' 115SELECT @@session.max_length_for_sort_data; 116@@session.max_length_for_sort_data 1174 118SET @@session.max_length_for_sort_data = 3; 119Warnings: 120Warning 1292 Truncated incorrect max_length_for_sort_data value: '3' 121SELECT @@session.max_length_for_sort_data; 122@@session.max_length_for_sort_data 1234 124SET @@session.max_length_for_sort_data = 0; 125Warnings: 126Warning 1292 Truncated incorrect max_length_for_sort_data value: '0' 127SELECT @@session.max_length_for_sort_data; 128@@session.max_length_for_sort_data 1294 130SET @@session.max_length_for_sort_data = 65530.34; 131ERROR 42000: Incorrect argument type to variable 'max_length_for_sort_data' 132SET @@session.max_length_for_sort_data = 10737418241; 133Warnings: 134Warning 1292 Truncated incorrect max_length_for_sort_data value: '10737418241' 135SELECT @@session.max_length_for_sort_data; 136@@session.max_length_for_sort_data 1378388608 138SET @@session.max_length_for_sort_data = test; 139ERROR 42000: Incorrect argument type to variable 'max_length_for_sort_data' 140SELECT @@session.max_length_for_sort_data; 141@@session.max_length_for_sort_data 1428388608 143'#------------------FN_DYNVARS_080_06-----------------------#' 144SELECT @@global.max_length_for_sort_data = VARIABLE_VALUE 145FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 146WHERE VARIABLE_NAME='max_length_for_sort_data'; 147@@global.max_length_for_sort_data = VARIABLE_VALUE 1481 149'#------------------FN_DYNVARS_080_07-----------------------#' 150SELECT @@session.max_length_for_sort_data = VARIABLE_VALUE 151FROM INFORMATION_SCHEMA.SESSION_VARIABLES 152WHERE VARIABLE_NAME='max_length_for_sort_data'; 153@@session.max_length_for_sort_data = VARIABLE_VALUE 1541 155'#------------------FN_DYNVARS_080_08-----------------------#' 156SET @@global.max_length_for_sort_data = TRUE; 157Warnings: 158Warning 1292 Truncated incorrect max_length_for_sort_data value: '1' 159SELECT @@global.max_length_for_sort_data; 160@@global.max_length_for_sort_data 1614 162SET @@global.max_length_for_sort_data = FALSE; 163Warnings: 164Warning 1292 Truncated incorrect max_length_for_sort_data value: '0' 165SELECT @@global.max_length_for_sort_data; 166@@global.max_length_for_sort_data 1674 168'#---------------------FN_DYNVARS_080_09----------------------#' 169SET @@global.max_length_for_sort_data = 2048; 170SELECT @@max_length_for_sort_data = @@global.max_length_for_sort_data; 171@@max_length_for_sort_data = @@global.max_length_for_sort_data 1720 173'#---------------------FN_DYNVARS_080_10----------------------#' 174SET @@max_length_for_sort_data = 100000; 175SELECT @@max_length_for_sort_data = @@local.max_length_for_sort_data; 176@@max_length_for_sort_data = @@local.max_length_for_sort_data 1771 178SELECT @@local.max_length_for_sort_data = @@session.max_length_for_sort_data; 179@@local.max_length_for_sort_data = @@session.max_length_for_sort_data 1801 181'#---------------------FN_DYNVARS_080_11----------------------#' 182SET max_length_for_sort_data = 1024; 183SELECT @@max_length_for_sort_data; 184@@max_length_for_sort_data 1851024 186SELECT local.max_length_for_sort_data; 187ERROR 42S02: Unknown table 'local' in field list 188SELECT session.max_length_for_sort_data; 189ERROR 42S02: Unknown table 'session' in field list 190SELECT max_length_for_sort_data = @@session.max_length_for_sort_data; 191ERROR 42S22: Unknown column 'max_length_for_sort_data' in 'field list' 192SET @@global.max_length_for_sort_data = @start_global_value; 193SELECT @@global.max_length_for_sort_data; 194@@global.max_length_for_sort_data 1951024 196SET @@session.max_length_for_sort_data = @start_session_value; 197SELECT @@session.max_length_for_sort_data; 198@@session.max_length_for_sort_data 1991024 200