1SET @start_global_value = @@global.updatable_views_with_limit; 2SELECT @start_global_value; 3@start_global_value 4YES 5SET @start_session_value = @@session.updatable_views_with_limit; 6SELECT @start_session_value; 7@start_session_value 8YES 9'#--------------------FN_DYNVARS_005_01-------------------------#' 10SET @@global.updatable_views_with_limit = 'NO'; 11SET @@global.updatable_views_with_limit = DEFAULT; 12SELECT @@global.updatable_views_with_limit; 13@@global.updatable_views_with_limit 14YES 15SET @@session.updatable_views_with_limit = 'NO'; 16SET @@session.updatable_views_with_limit = DEFAULT; 17SELECT @@session.updatable_views_with_limit; 18@@session.updatable_views_with_limit 19YES 20'#--------------------FN_DYNVARS_005_02-------------------------#' 21SET @@global.updatable_views_with_limit = DEFAULT; 22SELECT @@global.updatable_views_with_limit = 'Yes'; 23@@global.updatable_views_with_limit = 'Yes' 241 25SET @@session.updatable_views_with_limit = DEFAULT; 26SELECT @@session.updatable_views_with_limit ='Yes'; 27@@session.updatable_views_with_limit ='Yes' 281 29'#--------------------FN_DYNVARS_005_03-------------------------#' 30SET @@global.updatable_views_with_limit = NO; 31SELECT @@global.updatable_views_with_limit; 32@@global.updatable_views_with_limit 33NO 34SET @@global.updatable_views_with_limit = 'NO'; 35SELECT @@global.updatable_views_with_limit; 36@@global.updatable_views_with_limit 37NO 38SET @@global.updatable_views_with_limit = YES; 39SELECT @@global.updatable_views_with_limit; 40@@global.updatable_views_with_limit 41YES 42SET @@global.updatable_views_with_limit = 'YES'; 43SELECT @@global.updatable_views_with_limit; 44@@global.updatable_views_with_limit 45YES 46SET @@global.updatable_views_with_limit = "NO"; 47SELECT @@global.updatable_views_with_limit; 48@@global.updatable_views_with_limit 49NO 50SET @@global.updatable_views_with_limit = "YES"; 51SELECT @@global.updatable_views_with_limit; 52@@global.updatable_views_with_limit 53YES 54SET @@global.updatable_views_with_limit = 1; 55SELECT @@global.updatable_views_with_limit; 56@@global.updatable_views_with_limit 57YES 58SET @@global.updatable_views_with_limit = 0; 59SELECT @@global.updatable_views_with_limit; 60@@global.updatable_views_with_limit 61NO 62SET @@global.updatable_views_with_limit = TRUE; 63SELECT @@global.updatable_views_with_limit; 64@@global.updatable_views_with_limit 65YES 66SET @@global.updatable_views_with_limit = False; 67SELECT @@global.updatable_views_with_limit; 68@@global.updatable_views_with_limit 69NO 70'#--------------------FN_DYNVARS_005_04-------------------------#' 71SET @@session.updatable_views_with_limit = NO; 72SELECT @@session.updatable_views_with_limit; 73@@session.updatable_views_with_limit 74NO 75SET @@session.updatable_views_with_limit = 'NO'; 76SELECT @@session.updatable_views_with_limit; 77@@session.updatable_views_with_limit 78NO 79SET @@session.updatable_views_with_limit = YES; 80SELECT @@session.updatable_views_with_limit; 81@@session.updatable_views_with_limit 82YES 83SET @@session.updatable_views_with_limit = 'YES'; 84SELECT @@session.updatable_views_with_limit; 85@@session.updatable_views_with_limit 86YES 87SET @@session.updatable_views_with_limit = "YES"; 88SELECT @@session.updatable_views_with_limit; 89@@session.updatable_views_with_limit 90YES 91SET @@session.updatable_views_with_limit = "NO"; 92SELECT @@session.updatable_views_with_limit; 93@@session.updatable_views_with_limit 94NO 95SET @@session.updatable_views_with_limit =1; 96SELECT @@session.updatable_views_with_limit; 97@@session.updatable_views_with_limit 98YES 99SET @@session.updatable_views_with_limit = 0; 100SELECT @@session.updatable_views_with_limit; 101@@session.updatable_views_with_limit 102NO 103SET @@session.updatable_views_with_limit = True; 104SELECT @@session.updatable_views_with_limit; 105@@session.updatable_views_with_limit 106YES 107SET @@session.updatable_views_with_limit = False; 108SELECT @@session.updatable_views_with_limit; 109@@session.updatable_views_with_limit 110NO 111'#------------------FN_DYNVARS_005_05-----------------------#' 112SET @@global.updatable_views_with_limit = "TRUE"; 113ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'TRUE' 114SET @@global.updatable_views_with_limit = -1024; 115ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of '-1024' 116SET @@global.updatable_views_with_limit = 2345; 117ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of '2345' 118SET @@global.updatable_views_with_limit = "FALSE"; 119ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'FALSE' 120SET @@global.updatable_views_with_limit = 65530.34; 121ERROR 42000: Incorrect argument type to variable 'updatable_views_with_limit' 122SET @@global.updatable_views_with_limit ="Testing"; 123ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'Testing' 124SET @@session.updatable_views_with_limit = "ON"; 125ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'ON' 126SET @@session.updatable_views_with_limit = "OFF"; 127ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'OFF' 128SET @@session.updatable_views_with_limit = "True"; 129ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'True' 130SET @@session.updatable_views_with_limit = "False"; 131ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'False' 132SET @@session.updatable_views_with_limit = "Test"; 133ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'Test' 134SET @@session.updatable_views_with_limit = 'test'; 135ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'test' 136SET @@session.updatable_views_with_limit = 123456789031; 137ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of '123456789031' 138'#------------------FN_DYNVARS_005_06-----------------------#' 139SELECT @@global.updatable_views_with_limit = VARIABLE_VALUE 140FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 141WHERE VARIABLE_NAME='updatable_views_with_limit'; 142@@global.updatable_views_with_limit = VARIABLE_VALUE 1431 144'#------------------FN_DYNVARS_005_07-----------------------#' 145SELECT @@session.updatable_views_with_limit = VARIABLE_VALUE 146FROM INFORMATION_SCHEMA.SESSION_VARIABLES 147WHERE VARIABLE_NAME='updatable_views_with_limit'; 148@@session.updatable_views_with_limit = VARIABLE_VALUE 1491 150'#---------------------FN_DYNVARS_001_08----------------------#' 151SET @@global.updatable_views_with_limit = NO; 152SET @@session.updatable_views_with_limit = YES; 153SELECT @@updatable_views_with_limit = @@global.updatable_views_with_limit; 154@@updatable_views_with_limit = @@global.updatable_views_with_limit 1550 156'#---------------------FN_DYNVARS_001_09----------------------#' 157SET @@updatable_views_with_limit = YES; 158SELECT @@updatable_views_with_limit = @@local.updatable_views_with_limit; 159@@updatable_views_with_limit = @@local.updatable_views_with_limit 1601 161SELECT @@local.updatable_views_with_limit = @@session.updatable_views_with_limit; 162@@local.updatable_views_with_limit = @@session.updatable_views_with_limit 1631 164'#---------------------FN_DYNVARS_001_10----------------------#' 165SET updatable_views_with_limit = 1027; 166ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of '1027' 167SELECT @@updatable_views_with_limit; 168@@updatable_views_with_limit 169YES 170SELECT local.updatable_views_with_limit; 171ERROR 42S02: Unknown table 'local' in field list 172SELECT session.updatable_views_with_limit; 173ERROR 42S02: Unknown table 'session' in field list 174SELECT updatable_views_with_limit = @@session.updatable_views_with_limit; 175ERROR 42S22: Unknown column 'updatable_views_with_limit' in 'field list' 176SET @@global.updatable_views_with_limit = @start_global_value; 177SELECT @@global.updatable_views_with_limit; 178@@global.updatable_views_with_limit 179YES 180SET @@session.updatable_views_with_limit = @start_session_value; 181SELECT @@session.updatable_views_with_limit; 182@@session.updatable_views_with_limit 183YES 184