1SET @global_start_value = @@global.innodb_autoinc_lock_mode;
2SELECT @global_start_value;
3@global_start_value
41
5'#--------------------FN_DYNVARS_046_01------------------------#'
6SET @@global.innodb_autoinc_lock_mode = 0;
7ERROR HY000: Variable 'innodb_autoinc_lock_mode' is a read only variable
8SET @@global.innodb_autoinc_lock_mode = DEFAULT;
9ERROR HY000: Variable 'innodb_autoinc_lock_mode' is a read only variable
10SELECT @@global.innodb_autoinc_lock_mode;
11@@global.innodb_autoinc_lock_mode
121
13'#---------------------FN_DYNVARS_046_02-------------------------#'
14SELECT @@innodb_autoinc_lock_mode;
15@@innodb_autoinc_lock_mode
161
17SELECT local.innodb_autoinc_lock_mode;
18ERROR 42S02: Unknown table 'local' in field list
19SELECT @@global.innodb_autoinc_lock_mode;
20@@global.innodb_autoinc_lock_mode
211
22'#----------------------FN_DYNVARS_046_03------------------------#'
23SELECT @@global.innodb_autoinc_lock_mode = VARIABLE_VALUE
24FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
25WHERE VARIABLE_NAME='innodb_autoinc_lock_mode';
26@@global.innodb_autoinc_lock_mode = VARIABLE_VALUE
271
28SELECT @@global.innodb_autoinc_lock_mode;
29@@global.innodb_autoinc_lock_mode
301
31SELECT VARIABLE_VALUE
32FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
33WHERE VARIABLE_NAME='innodb_autoinc_lock_mode';
34VARIABLE_VALUE
351
36