Debian Codegraph @

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

raw
1 SELECT COUNT(@@GLOBAL.innodb_force_primary_key);
2 COUNT(@@GLOBAL.innodb_force_primary_key)
3 1
4 1 Expected
5 SET @@GLOBAL.innodb_force_primary_key=1;
6 Expected ok
7 SELECT COUNT(@@GLOBAL.innodb_force_primary_key);
8 COUNT(@@GLOBAL.innodb_force_primary_key)
9 1
10 1 Expected
11 SELECT IF(@@GLOBAL.innodb_force_primary_key, 'ON', 'OFF') = VARIABLE_VALUE
12 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
13 WHERE VARIABLE_NAME='innodb_force_primary_key';
14 IF(@@GLOBAL.innodb_force_primary_key, 'ON', 'OFF') = VARIABLE_VALUE
15 1
16 1 Expected
17 SELECT COUNT(@@GLOBAL.innodb_force_primary_key);
18 COUNT(@@GLOBAL.innodb_force_primary_key)
19 1
20 1 Expected
21 SELECT COUNT(VARIABLE_VALUE)
22 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
23 WHERE VARIABLE_NAME='innodb_force_primary_key';
24 COUNT(VARIABLE_VALUE)
25 1
26 1 Expected
27 SELECT @@innodb_force_primary_key = @@GLOBAL.innodb_force_primary_key;
28 @@innodb_force_primary_key = @@GLOBAL.innodb_force_primary_key
29 1
30 1 Expected
31 SELECT COUNT(@@innodb_force_primary_key);
32 COUNT(@@innodb_force_primary_key)
33 1
34 1 Expected
35 SELECT COUNT(@@local.innodb_force_primary_key);
36 ERROR HY000: Variable 'innodb_force_primary_key' is a GLOBAL variable
37 Expected Variable 'innodb_force_primary_key' is a GLOBAL variable
38 SELECT COUNT(@@SESSION.innodb_force_primary_key);
39 ERROR HY000: Variable 'innodb_force_primary_key' is a GLOBAL variable
40 Expected Variable 'innodb_force_primary_key' is a GLOBAL variable
41 SELECT COUNT(@@GLOBAL.innodb_force_primary_key);
42 COUNT(@@GLOBAL.innodb_force_primary_key)
43 1
44 1 Expected