1SET @start_global_value = @@global.completion_type; 2SELECT @start_global_value; 3@start_global_value 4NO_CHAIN 5SET @start_session_value = @@session.completion_type; 6SELECT @start_session_value; 7@start_session_value 8NO_CHAIN 9'#--------------------FN_DYNVARS_017_01-------------------------#' 10SET @@global.completion_type = 2; 11SET @@global.completion_type = DEFAULT; 12SELECT @@global.completion_type; 13@@global.completion_type 14NO_CHAIN 15SET @@session.completion_type = 1; 16SET @@session.completion_type = DEFAULT; 17SELECT @@session.completion_type; 18@@session.completion_type 19NO_CHAIN 20'#--------------------FN_DYNVARS_017_03-------------------------#' 21SET @@global.completion_type = 0; 22SELECT @@global.completion_type; 23@@global.completion_type 24NO_CHAIN 25SET @@global.completion_type = 1; 26SELECT @@global.completion_type; 27@@global.completion_type 28CHAIN 29SET @@global.completion_type = 2; 30SELECT @@global.completion_type; 31@@global.completion_type 32RELEASE 33SET @@global.completion_type = NO_CHAIN; 34SELECT @@global.completion_type; 35@@global.completion_type 36NO_CHAIN 37SET @@global.completion_type = CHAIN; 38SELECT @@global.completion_type; 39@@global.completion_type 40CHAIN 41SET @@global.completion_type = 'RELEASE'; 42SELECT @@global.completion_type; 43@@global.completion_type 44RELEASE 45'#--------------------FN_DYNVARS_017_04-------------------------#' 46SET @@session.completion_type = 0; 47SELECT @@session.completion_type; 48@@session.completion_type 49NO_CHAIN 50SET @@session.completion_type = 1; 51SELECT @@session.completion_type; 52@@session.completion_type 53CHAIN 54SET @@session.completion_type = 2; 55SELECT @@session.completion_type; 56@@session.completion_type 57RELEASE 58SET @@session.completion_type = 'NO_CHAIN'; 59SELECT @@session.completion_type; 60@@session.completion_type 61NO_CHAIN 62SET @@session.completion_type = 'CHAIN'; 63SELECT @@session.completion_type; 64@@session.completion_type 65CHAIN 66SET @@session.completion_type = 'RELEASE'; 67SELECT @@session.completion_type; 68@@session.completion_type 69RELEASE 70'#------------------FN_DYNVARS_017_05-----------------------#' 71set sql_mode=TRADITIONAL; 72SET @@global.completion_type = 10; 73ERROR 42000: Variable 'completion_type' can't be set to the value of '10' 74SET @@global.completion_type = -1024; 75ERROR 42000: Variable 'completion_type' can't be set to the value of '-1024' 76SET @@global.completion_type = 2.4; 77ERROR 42000: Incorrect argument type to variable 'completion_type' 78SET @@global.completion_type = OFF; 79ERROR 42000: Variable 'completion_type' can't be set to the value of 'OFF' 80SET @@session.completion_type = 10; 81ERROR 42000: Variable 'completion_type' can't be set to the value of '10' 82SET @@session.completion_type = -2; 83ERROR 42000: Variable 'completion_type' can't be set to the value of '-2' 84SET @@session.completion_type = 1.2; 85ERROR 42000: Incorrect argument type to variable 'completion_type' 86SET @@session.completion_type = ON; 87ERROR 42000: Variable 'completion_type' can't be set to the value of 'ON' 88'#------------------FN_DYNVARS_017_06-----------------------#' 89SELECT @@global.completion_type = VARIABLE_VALUE 90FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 91WHERE VARIABLE_NAME='completion_type'; 92@@global.completion_type = VARIABLE_VALUE 931 94SELECT @@session.completion_type = VARIABLE_VALUE 95FROM INFORMATION_SCHEMA.SESSION_VARIABLES 96WHERE VARIABLE_NAME='completion_type'; 97@@session.completion_type = VARIABLE_VALUE 981 99'#------------------FN_DYNVARS_017_07-----------------------#' 100SET @@global.completion_type = TRUE; 101SELECT @@global.completion_type; 102@@global.completion_type 103CHAIN 104SET @@global.completion_type = FALSE; 105SELECT @@global.completion_type; 106@@global.completion_type 107NO_CHAIN 108'#---------------------FN_DYNVARS_001_08----------------------#' 109SET @@completion_type = 1; 110SELECT @@completion_type = @@local.completion_type; 111@@completion_type = @@local.completion_type 1121 113SELECT @@local.completion_type = @@session.completion_type; 114@@local.completion_type = @@session.completion_type 1151 116'#---------------------FN_DYNVARS_001_09----------------------#' 117SET completion_type = 1; 118SELECT @@completion_type; 119@@completion_type 120CHAIN 121SET local.completion_type = 1; 122ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.completion_type = 1' at line 1 123SELECT local.completion_type; 124ERROR 42S02: Unknown table 'local' in field list 125SET session.completion_type = 1; 126ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.completion_type = 1' at line 1 127SELECT session.completion_type; 128ERROR 42S02: Unknown table 'session' in field list 129SELECT completion_type = @@session.completion_type; 130ERROR 42S22: Unknown column 'completion_type' in 'field list' 131SET @@global.completion_type = @start_global_value; 132SELECT @@global.completion_type; 133@@global.completion_type 134NO_CHAIN 135SET @@session.completion_type = @start_session_value; 136SELECT @@session.completion_type; 137@@session.completion_type 138NO_CHAIN 139set sql_mode=''; 140Warnings: 141Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. 142