Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_autoinc_lock_mode_basic.result

raw
1 SET @global_start_value = @@global.innodb_autoinc_lock_mode;
2 SELECT @global_start_value;
3 @global_start_value
4 2
5 '#--------------------FN_DYNVARS_046_01------------------------#'
6 SET @@global.innodb_autoinc_lock_mode = 0;
7 ERROR HY000: Variable 'innodb_autoinc_lock_mode' is a read only variable
8 SET @@global.innodb_autoinc_lock_mode = DEFAULT;
9 ERROR HY000: Variable 'innodb_autoinc_lock_mode' is a read only variable
10 SELECT @@global.innodb_autoinc_lock_mode;
11 @@global.innodb_autoinc_lock_mode
12 2
13 '#---------------------FN_DYNVARS_046_02-------------------------#'
14 SELECT @@innodb_autoinc_lock_mode;
15 @@innodb_autoinc_lock_mode
16 2
17 SELECT local.innodb_autoinc_lock_mode;
18 ERROR 42S02: Unknown table 'local' in field list
19 SELECT @@global.innodb_autoinc_lock_mode;
20 @@global.innodb_autoinc_lock_mode
21 2
22 '#----------------------FN_DYNVARS_046_03------------------------#'
23 SELECT @@global.innodb_autoinc_lock_mode = VARIABLE_VALUE
24 FROM performance_schema.global_variables
25 WHERE VARIABLE_NAME='innodb_autoinc_lock_mode';
26 @@global.innodb_autoinc_lock_mode = VARIABLE_VALUE
27 1
28 SELECT @@global.innodb_autoinc_lock_mode;
29 @@global.innodb_autoinc_lock_mode
30 2
31 SELECT VARIABLE_VALUE
32 FROM performance_schema.global_variables
33 WHERE VARIABLE_NAME='innodb_autoinc_lock_mode';
34 VARIABLE_VALUE
35 2