1SET @session_start_value = @@session.sql_quote_show_create; 2SELECT @session_start_value; 3@session_start_value 41 5'#--------------------FN_DYNVARS_162_01------------------------#' 6SET @@session.sql_quote_show_create = 0; 7SET @@session.sql_quote_show_create = DEFAULT; 8SELECT @@session.sql_quote_show_create; 9@@session.sql_quote_show_create 101 11SET @@session.sql_quote_show_create = 1; 12SET @@session.sql_quote_show_create = DEFAULT; 13SELECT @@session.sql_quote_show_create; 14@@session.sql_quote_show_create 151 16'#---------------------FN_DYNVARS_162_02-------------------------#' 17SET sql_quote_show_create = 1; 18SELECT @@sql_quote_show_create; 19@@sql_quote_show_create 201 21SELECT session.sql_quote_show_create; 22ERROR 42S02: Unknown table 'session' in field list 23SELECT local.sql_quote_show_create; 24ERROR 42S02: Unknown table 'local' in field list 25SET session sql_quote_show_create = 0; 26SELECT @@session.sql_quote_show_create; 27@@session.sql_quote_show_create 280 29'#--------------------FN_DYNVARS_162_03------------------------#' 30SET @@session.sql_quote_show_create = 0; 31SELECT @@session.sql_quote_show_create; 32@@session.sql_quote_show_create 330 34SET @@session.sql_quote_show_create = 1; 35SELECT @@session.sql_quote_show_create; 36@@session.sql_quote_show_create 371 38'#--------------------FN_DYNVARS_162_04-------------------------#' 39SET @@session.sql_quote_show_create = -1; 40ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of '-1' 41SET @@session.sql_quote_show_create = 2; 42ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of '2' 43SET @@session.sql_quote_show_create = "T"; 44ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'T' 45SET @@session.sql_quote_show_create = "Y"; 46ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'Y' 47SET @@session.sql_quote_show_create = TR�E; 48ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'TR�E' 49SET @@session.sql_quote_show_create = �N; 50ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of '�N' 51SET @@session.sql_quote_show_create = OF; 52ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'OF' 53SET @@session.sql_quote_show_create = �FF; 54ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of '�FF' 55SET @@session.sql_quote_show_create = '�'; 56ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of '�' 57SET @@session.sql_quote_show_create = NO; 58ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'NO' 59'#-------------------FN_DYNVARS_162_05----------------------------#' 60SET @@global.sql_quote_show_create = 1-@@global.sql_quote_show_create; 61SELECT @@global.sql_quote_show_create; 62@@global.sql_quote_show_create 630 64SET @@global.sql_quote_show_create = 1-@@global.sql_quote_show_create; 65SELECT @@global.sql_quote_show_create; 66@@global.sql_quote_show_create 671 68'#----------------------FN_DYNVARS_162_06------------------------#' 69SELECT count(VARIABLE_VALUE) 70FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 71WHERE VARIABLE_NAME='sql_quote_show_create'; 72count(VARIABLE_VALUE) 731 74'#----------------------FN_DYNVARS_162_07------------------------#' 75SELECT IF(@@session.sql_quote_show_create, "ON", "OFF") = VARIABLE_VALUE 76FROM INFORMATION_SCHEMA.SESSION_VARIABLES 77WHERE VARIABLE_NAME='sql_quote_show_create'; 78IF(@@session.sql_quote_show_create, "ON", "OFF") = VARIABLE_VALUE 791 80SELECT @@session.sql_quote_show_create; 81@@session.sql_quote_show_create 821 83SELECT VARIABLE_VALUE 84FROM INFORMATION_SCHEMA.SESSION_VARIABLES 85WHERE VARIABLE_NAME='sql_quote_show_create'; 86VARIABLE_VALUE 87ON 88'#---------------------FN_DYNVARS_162_08-------------------------#' 89SET @@session.sql_quote_show_create = OFF; 90SELECT @@session.sql_quote_show_create; 91@@session.sql_quote_show_create 920 93SET @@session.sql_quote_show_create = ON; 94SELECT @@session.sql_quote_show_create; 95@@session.sql_quote_show_create 961 97'#---------------------FN_DYNVARS_162_09----------------------#' 98SET @@session.sql_quote_show_create = TRUE; 99SELECT @@session.sql_quote_show_create; 100@@session.sql_quote_show_create 1011 102SET @@session.sql_quote_show_create = FALSE; 103SELECT @@session.sql_quote_show_create; 104@@session.sql_quote_show_create 1050 106SET @@session.sql_quote_show_create = @session_start_value; 107SELECT @@session.sql_quote_show_create; 108@@session.sql_quote_show_create 1091 110