1SET @start_global_value = @@global.default_week_format; 2SELECT @start_global_value; 3@start_global_value 40 5SET @start_session_value = @@session.default_week_format; 6SELECT @start_session_value; 7@start_session_value 80 9'#--------------------FN_DYNVARS_022_01-------------------------#' 10SET @@global.default_week_format = 100; 11Warnings: 12Warning 1292 Truncated incorrect default_week_format value: '100' 13SET @@global.default_week_format = DEFAULT; 14SELECT @@global.default_week_format; 15@@global.default_week_format 160 17SET @@session.default_week_format = 200; 18Warnings: 19Warning 1292 Truncated incorrect default_week_format value: '200' 20SET @@session.default_week_format = DEFAULT; 21SELECT @@session.default_week_format; 22@@session.default_week_format 230 24'#--------------------FN_DYNVARS_022_02-------------------------#' 25SET @@global.default_week_format = @start_global_value; 26SELECT @@global.default_week_format = 0; 27@@global.default_week_format = 0 281 29SET @@session.default_week_format = @start_global_value; 30SELECT @@session.default_week_format = 0; 31@@session.default_week_format = 0 321 33'#--------------------FN_DYNVARS_022_03-------------------------#' 34SET @@global.default_week_format = 1; 35SELECT @@global.default_week_format; 36@@global.default_week_format 371 38SET @@global.default_week_format = 0; 39SELECT @@global.default_week_format; 40@@global.default_week_format 410 42SET @@global.default_week_format = 7; 43SELECT @@global.default_week_format; 44@@global.default_week_format 457 46'#--------------------FN_DYNVARS_022_04-------------------------#' 47SET @@session.default_week_format = 1; 48SELECT @@session.default_week_format; 49@@session.default_week_format 501 51SET @@session.default_week_format = 0; 52SELECT @@session.default_week_format; 53@@session.default_week_format 540 55SET @@session.default_week_format = 7; 56SELECT @@session.default_week_format; 57@@session.default_week_format 587 59'#------------------FN_DYNVARS_022_05-----------------------#' 60SET @@global.default_week_format = 8; 61Warnings: 62Warning 1292 Truncated incorrect default_week_format value: '8' 63SELECT @@global.default_week_format; 64@@global.default_week_format 657 66SET @@global.default_week_format = -1024; 67Warnings: 68Warning 1292 Truncated incorrect default_week_format value: '-1024' 69SELECT @@global.default_week_format; 70@@global.default_week_format 710 72SET @@global.default_week_format = 65536; 73Warnings: 74Warning 1292 Truncated incorrect default_week_format value: '65536' 75SELECT @@global.default_week_format; 76@@global.default_week_format 777 78SET @@global.default_week_format = 65530.30; 79ERROR 42000: Incorrect argument type to variable 'default_week_format' 80SELECT @@global.default_week_format; 81@@global.default_week_format 827 83SET @@global.default_week_format = OFF; 84ERROR 42000: Incorrect argument type to variable 'default_week_format' 85SELECT @@global.default_week_format; 86@@global.default_week_format 877 88SET @@session.default_week_format = ON; 89ERROR 42000: Incorrect argument type to variable 'default_week_format' 90SELECT @@session.default_week_format; 91@@session.default_week_format 927 93SET @@session.default_week_format = 65530.30; 94ERROR 42000: Incorrect argument type to variable 'default_week_format' 95SELECT @@session.default_week_format; 96@@session.default_week_format 977 98SET @@session.default_week_format = 10; 99Warnings: 100Warning 1292 Truncated incorrect default_week_format value: '10' 101SELECT @@session.default_week_format; 102@@session.default_week_format 1037 104SET @@session.default_week_format = -2; 105Warnings: 106Warning 1292 Truncated incorrect default_week_format value: '-2' 107SELECT @@session.default_week_format; 108@@session.default_week_format 1090 110SET @@session.default_week_format = 65550; 111Warnings: 112Warning 1292 Truncated incorrect default_week_format value: '65550' 113SELECT @@session.default_week_format; 114@@session.default_week_format 1157 116'#------------------FN_DYNVARS_022_06-----------------------#' 117SELECT @@global.default_week_format = VARIABLE_VALUE 118FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 119WHERE VARIABLE_NAME='default_week_format'; 120@@global.default_week_format = VARIABLE_VALUE 1211 122SELECT @@session.default_week_format = VARIABLE_VALUE 123FROM INFORMATION_SCHEMA.SESSION_VARIABLES 124WHERE VARIABLE_NAME='default_week_format'; 125@@session.default_week_format = VARIABLE_VALUE 1261 127'#------------------FN_DYNVARS_022_07-----------------------#' 128SET @@global.default_week_format = TRUE; 129SELECT @@global.default_week_format; 130@@global.default_week_format 1311 132SET @@global.default_week_format = FALSE; 133SELECT @@global.default_week_format; 134@@global.default_week_format 1350 136'#---------------------FN_DYNVARS_001_08----------------------#' 137SET @@global.default_week_format = 0; 138SELECT @@default_week_format = @@global.default_week_format; 139@@default_week_format = @@global.default_week_format 1400 141'#---------------------FN_DYNVARS_001_09----------------------#' 142SET @@default_week_format = 1; 143SELECT @@default_week_format = @@local.default_week_format; 144@@default_week_format = @@local.default_week_format 1451 146SELECT @@local.default_week_format = @@session.default_week_format; 147@@local.default_week_format = @@session.default_week_format 1481 149'#---------------------FN_DYNVARS_001_10----------------------#' 150SET default_week_format = 1; 151SELECT @@default_week_format; 152@@default_week_format 1531 154SELECT local.default_week_format; 155ERROR 42S02: Unknown table 'local' in field list 156SELECT session.default_week_format; 157ERROR 42S02: Unknown table 'session' in field list 158SELECT default_week_format = @@session.default_week_format; 159ERROR 42S22: Unknown column 'default_week_format' in 'field list' 160SET @@global.default_week_format = @start_global_value; 161SELECT @@global.default_week_format; 162@@global.default_week_format 1630 164SET @@session.default_week_format = @start_session_value; 165SELECT @@session.default_week_format; 166@@session.default_week_format 1670 168