1SET @start_global_value = @@global.auto_increment_offset; 2SELECT @start_global_value; 3@start_global_value 41 5SET @start_session_value = @@session.auto_increment_offset; 6SELECT @start_session_value; 7@start_session_value 81 9'#--------------------FN_DYNVARS_002_01-------------------------#' 10SET @@global.auto_increment_offset = 100; 11SET @@global.auto_increment_offset = DEFAULT; 12SELECT @@global.auto_increment_offset; 13@@global.auto_increment_offset 141 15SET @@session.auto_increment_offset = 200; 16SET @@session.auto_increment_offset = DEFAULT; 17SELECT @@session.auto_increment_offset; 18@@session.auto_increment_offset 191 20'#--------------------FN_DYNVARS_002_02-------------------------#' 21SET @@global.auto_increment_offset = @start_global_value; 22SELECT @@global.auto_increment_offset = 1; 23@@global.auto_increment_offset = 1 241 25SET @@session.auto_increment_offset = @start_session_value; 26SELECT @@session.auto_increment_offset = 1; 27@@session.auto_increment_offset = 1 281 29'#--------------------FN_DYNVARS_002_03-------------------------#' 30SET @@global.auto_increment_offset = 1; 31SELECT @@global.auto_increment_offset; 32@@global.auto_increment_offset 331 34SET @@global.auto_increment_offset = 60020; 35SELECT @@global.auto_increment_offset; 36@@global.auto_increment_offset 3760020 38SET @@global.auto_increment_offset = 65535; 39SELECT @@global.auto_increment_offset; 40@@global.auto_increment_offset 4165535 42'#--------------------FN_DYNVARS_002_04-------------------------#' 43SET @@session.auto_increment_offset = 1; 44SELECT @@session.auto_increment_offset; 45@@session.auto_increment_offset 461 47SET @@session.auto_increment_offset = 50050; 48SELECT @@session.auto_increment_offset; 49@@session.auto_increment_offset 5050050 51SET @@session.auto_increment_offset = 65535; 52SELECT @@session.auto_increment_offset; 53@@session.auto_increment_offset 5465535 55'#------------------FN_DYNVARS_002_05-----------------------#' 56SET @@global.auto_increment_offset = 0; 57Warnings: 58Warning 1292 Truncated incorrect auto_increment_offset value: '0' 59SELECT @@global.auto_increment_offset; 60@@global.auto_increment_offset 611 62SET @@global.auto_increment_offset = -1024; 63Warnings: 64Warning 1292 Truncated incorrect auto_increment_offset value: '-1024' 65SELECT @@global.auto_increment_offset; 66@@global.auto_increment_offset 671 68SET @@global.auto_increment_offset = 65536; 69Warnings: 70Warning 1292 Truncated incorrect auto_increment_offset value: '65536' 71SELECT @@global.auto_increment_offset; 72@@global.auto_increment_offset 7365535 74SET @@global.auto_increment_offset = ON; 75ERROR 42000: Incorrect argument type to variable 'auto_increment_offset' 76SELECT @@global.auto_increment_offset; 77@@global.auto_increment_offset 7865535 79SET @@global.auto_increment_offset = OFF; 80ERROR 42000: Incorrect argument type to variable 'auto_increment_offset' 81SELECT @@global.auto_increment_offset; 82@@global.auto_increment_offset 8365535 84SET @@global.auto_increment_offset = test; 85ERROR 42000: Incorrect argument type to variable 'auto_increment_offset' 86SELECT @@global.auto_increment_offset; 87@@global.auto_increment_offset 8865535 89SET @@session.auto_increment_offset = 0; 90Warnings: 91Warning 1292 Truncated incorrect auto_increment_offset value: '0' 92SELECT @@session.auto_increment_offset; 93@@session.auto_increment_offset 941 95SET @@session.auto_increment_offset = -2; 96Warnings: 97Warning 1292 Truncated incorrect auto_increment_offset value: '-2' 98SELECT @@session.auto_increment_offset; 99@@session.auto_increment_offset 1001 101SET @@session.auto_increment_offset = 65550; 102Warnings: 103Warning 1292 Truncated incorrect auto_increment_offset value: '65550' 104SELECT @@session.auto_increment_offset; 105@@session.auto_increment_offset 10665535 107SET @@session.auto_increment_offset = ON; 108ERROR 42000: Incorrect argument type to variable 'auto_increment_offset' 109SELECT @@session.auto_increment_offset; 110@@session.auto_increment_offset 11165535 112SET @@session.auto_increment_offset = OFF; 113ERROR 42000: Incorrect argument type to variable 'auto_increment_offset' 114SELECT @@session.auto_increment_offset; 115@@session.auto_increment_offset 11665535 117SET @@session.auto_increment_offset = test; 118ERROR 42000: Incorrect argument type to variable 'auto_increment_offset' 119SELECT @@session.auto_increment_offset; 120@@session.auto_increment_offset 12165535 122'#------------------FN_DYNVARS_002_06-----------------------#' 123SELECT @@global.auto_increment_offset = VARIABLE_VALUE 124FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 125WHERE VARIABLE_NAME='auto_increment_offset'; 126@@global.auto_increment_offset = VARIABLE_VALUE 1271 128'#------------------FN_DYNVARS_002_07-----------------------#' 129SELECT @@session.auto_increment_offset = VARIABLE_VALUE 130FROM INFORMATION_SCHEMA.SESSION_VARIABLES 131WHERE VARIABLE_NAME='auto_increment_offset'; 132@@session.auto_increment_offset = VARIABLE_VALUE 1331 134'#------------------FN_DYNVARS_002_08-----------------------#' 135SET @@global.auto_increment_offset = TRUE; 136SELECT @@global.auto_increment_offset; 137@@global.auto_increment_offset 1381 139SET @@global.auto_increment_offset = FALSE; 140Warnings: 141Warning 1292 Truncated incorrect auto_increment_offset value: '0' 142SELECT @@global.auto_increment_offset; 143@@global.auto_increment_offset 1441 145'#---------------------FN_DYNVARS_001_09----------------------#' 146SET @@global.auto_increment_offset = 10; 147SET @@session.auto_increment_offset = 11; 148SELECT @@auto_increment_offset = @@global.auto_increment_offset; 149@@auto_increment_offset = @@global.auto_increment_offset 1500 151'#---------------------FN_DYNVARS_001_10----------------------#' 152SET @@auto_increment_offset = 100; 153SELECT @@auto_increment_offset = @@local.auto_increment_offset; 154@@auto_increment_offset = @@local.auto_increment_offset 1551 156SELECT @@local.auto_increment_offset = @@session.auto_increment_offset; 157@@local.auto_increment_offset = @@session.auto_increment_offset 1581 159'#---------------------FN_DYNVARS_001_11----------------------#' 160SET auto_increment_offset = 1; 161SELECT @@auto_increment_offset; 162@@auto_increment_offset 1631 164SELECT local.auto_increment_offset; 165ERROR 42S02: Unknown table 'local' in field list 166SELECT session.auto_increment_offset; 167ERROR 42S02: Unknown table 'session' in field list 168SELECT auto_increment_offset = @@session.auto_increment_offset; 169ERROR 42S22: Unknown column 'auto_increment_offset' in 'field list' 170SET @@global.auto_increment_offset = @start_global_value; 171SELECT @@global.auto_increment_offset; 172@@global.auto_increment_offset 1731 174SET @@session.auto_increment_offset = @start_session_value; 175SELECT @@session.auto_increment_offset; 176@@session.auto_increment_offset 1771 178