Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_force_primary_key_basic.test

raw
1 --source include/have_innodb.inc
2
3 let $force_pk=`select @@innodb_force_primary_key`;
4
5 SELECT COUNT(@@GLOBAL.innodb_force_primary_key);
6 --echo 1 Expected
7
8 ####################################################################
9 # Check if Value can set #
10 ####################################################################
11
12 SET @@GLOBAL.innodb_force_primary_key=1;
13 --echo Expected ok
14
15 SELECT COUNT(@@GLOBAL.innodb_force_primary_key);
16 --echo 1 Expected
17
18 #################################################################
19 # Check if the value in GLOBAL Table matches value in variable #
20 #################################################################
21
22 SELECT IF(@@GLOBAL.innodb_force_primary_key, 'ON', 'OFF') = VARIABLE_VALUE
23 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
24 WHERE VARIABLE_NAME='innodb_force_primary_key';
25 --echo 1 Expected
26
27 SELECT COUNT(@@GLOBAL.innodb_force_primary_key);
28 --echo 1 Expected
29
30 SELECT COUNT(VARIABLE_VALUE)
31 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
32 WHERE VARIABLE_NAME='innodb_force_primary_key';
33 --echo 1 Expected
34
35 ################################################################################
36 # Check if accessing variable with and without GLOBAL point to same variable #
37 ################################################################################
38 SELECT @@innodb_force_primary_key = @@GLOBAL.innodb_force_primary_key;
39 --echo 1 Expected
40
41 SELECT COUNT(@@innodb_force_primary_key);
42 --echo 1 Expected
43
44 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
45 SELECT COUNT(@@local.innodb_force_primary_key);
46 --echo Expected Variable 'innodb_force_primary_key' is a GLOBAL variable
47
48 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
49 SELECT COUNT(@@SESSION.innodb_force_primary_key);
50 --echo Expected Variable 'innodb_force_primary_key' is a GLOBAL variable
51
52 SELECT COUNT(@@GLOBAL.innodb_force_primary_key);
53 --echo 1 Expected
54
55 --disable_query_log
56 eval set global innodb_force_primary_key=$force_pk;
57 --enable_query_log