1SET @start_global_value = @@global.myisam_data_pointer_size; 2SELECT @start_global_value; 3@start_global_value 46 5'#--------------------FN_DYNVARS_093_01-------------------------#' 6SET @@global.myisam_data_pointer_size = 5; 7SET @@global.myisam_data_pointer_size = DEFAULT; 8SELECT @@global.myisam_data_pointer_size; 9@@global.myisam_data_pointer_size 106 11'#--------------------FN_DYNVARS_093_02-------------------------#' 12SET @@global.myisam_data_pointer_size = DEFAULT; 13SELECT @@global.myisam_data_pointer_size = 6; 14@@global.myisam_data_pointer_size = 6 151 16'#--------------------FN_DYNVARS_093_03-------------------------#' 17SET @@global.myisam_data_pointer_size = 2; 18SELECT @@global.myisam_data_pointer_size; 19@@global.myisam_data_pointer_size 202 21SET @@global.myisam_data_pointer_size = 3; 22SELECT @@global.myisam_data_pointer_size; 23@@global.myisam_data_pointer_size 243 25SET @@global.myisam_data_pointer_size = 4; 26SELECT @@global.myisam_data_pointer_size; 27@@global.myisam_data_pointer_size 284 29SET @@global.myisam_data_pointer_size = 5; 30SELECT @@global.myisam_data_pointer_size; 31@@global.myisam_data_pointer_size 325 33SET @@global.myisam_data_pointer_size = 6; 34SELECT @@global.myisam_data_pointer_size; 35@@global.myisam_data_pointer_size 366 37SET @@global.myisam_data_pointer_size = 7; 38SELECT @@global.myisam_data_pointer_size; 39@@global.myisam_data_pointer_size 407 41'#--------------------FN_DYNVARS_093_04-------------------------#' 42SET @@myisam_data_pointer_size = 2; 43ERROR HY000: Variable 'myisam_data_pointer_size' is a GLOBAL variable and should be set with SET GLOBAL 44SET @@session.myisam_data_pointer_size = 3; 45ERROR HY000: Variable 'myisam_data_pointer_size' is a GLOBAL variable and should be set with SET GLOBAL 46SET @@local.myisam_data_pointer_size = 4; 47ERROR HY000: Variable 'myisam_data_pointer_size' is a GLOBAL variable and should be set with SET GLOBAL 48'#------------------FN_DYNVARS_093_05-----------------------#' 49SET @@global.myisam_data_pointer_size = -1; 50Warnings: 51Warning 1292 Truncated incorrect myisam_data_pointer_size value: '-1' 52SELECT @@global.myisam_data_pointer_size; 53@@global.myisam_data_pointer_size 542 55SET @@global.myisam_data_pointer_size = 8; 56Warnings: 57Warning 1292 Truncated incorrect myisam_data_pointer_size value: '8' 58SELECT @@global.myisam_data_pointer_size; 59@@global.myisam_data_pointer_size 607 61SET @@global.myisam_data_pointer_size = 1; 62Warnings: 63Warning 1292 Truncated incorrect myisam_data_pointer_size value: '1' 64SELECT @@global.myisam_data_pointer_size; 65@@global.myisam_data_pointer_size 662 67SET @@global.myisam_data_pointer_size = 4294967296; 68Warnings: 69Warning 1292 Truncated incorrect myisam_data_pointer_size value: '4294967296' 70SELECT @@global.myisam_data_pointer_size; 71@@global.myisam_data_pointer_size 727 73SET @@global.myisam_data_pointer_size = 65530.34; 74ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size' 75SELECT @@global.myisam_data_pointer_size; 76@@global.myisam_data_pointer_size 777 78SET @@global.myisam_data_pointer_size = two; 79ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size' 80SELECT @@global.myisam_data_pointer_size; 81@@global.myisam_data_pointer_size 827 83'#------------------FN_DYNVARS_093_06-----------------------#' 84SET @@global.myisam_data_pointer_size = 3; 85SELECT @@global.myisam_data_pointer_size = VARIABLE_VALUE 86FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 87WHERE VARIABLE_NAME='myisam_data_pointer_size'; 88@@global.myisam_data_pointer_size = VARIABLE_VALUE 891 90'#------------------FN_DYNVARS_093_07-----------------------#' 91SELECT count(VARIABLE_VALUE) 92FROM INFORMATION_SCHEMA.SESSION_VARIABLES 93WHERE VARIABLE_NAME='myisam_data_pointer_size'; 94count(VARIABLE_VALUE) 951 96'#------------------FN_DYNVARS_093_08-----------------------#' 97SET @@global.myisam_data_pointer_size = TRUE; 98Warnings: 99Warning 1292 Truncated incorrect myisam_data_pointer_size value: '1' 100SELECT @@global.myisam_data_pointer_size; 101@@global.myisam_data_pointer_size 1022 103SET @@global.myisam_data_pointer_size = FALSE; 104Warnings: 105Warning 1292 Truncated incorrect myisam_data_pointer_size value: '0' 106SELECT @@global.myisam_data_pointer_size; 107@@global.myisam_data_pointer_size 1082 109'#---------------------FN_DYNVARS_001_09----------------------#' 110SET @@global.myisam_data_pointer_size = 5; 111SELECT @@myisam_data_pointer_size = @@global.myisam_data_pointer_size; 112@@myisam_data_pointer_size = @@global.myisam_data_pointer_size 1131 114'#---------------------FN_DYNVARS_001_10----------------------#' 115SET myisam_data_pointer_size = 7; 116ERROR HY000: Variable 'myisam_data_pointer_size' is a GLOBAL variable and should be set with SET GLOBAL 117SELECT myisam_data_pointer_size; 118ERROR 42S22: Unknown column 'myisam_data_pointer_size' in 'field list' 119SELECT @@myisam_data_pointer_size; 120@@myisam_data_pointer_size 1215 122SET global myisam_data_pointer_size = 2; 123SET @@global.myisam_data_pointer_size = @start_global_value; 124SELECT @@global.myisam_data_pointer_size; 125@@global.myisam_data_pointer_size 1266 127