Debian Codegraph @

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

raw
1 #
2 # wsrep_slave_fk_checks
3 #
4 # save the initial value
5 SET @wsrep_slave_fk_checks_global_saved = @@global.wsrep_slave_fk_checks;
6 # default
7 SELECT @@global.wsrep_slave_fk_checks;
8 @@global.wsrep_slave_fk_checks
9 1
10
11 # scope
12 SELECT @@session.wsrep_slave_fk_checks;
13 ERROR HY000: Variable 'wsrep_slave_FK_checks' is a GLOBAL variable
14 SET @@global.wsrep_slave_fk_checks=OFF;
15 Warnings:
16 Warning 1287 '@@wsrep_slave_FK_checks' is deprecated and will be removed in a future release
17 SELECT @@global.wsrep_slave_fk_checks;
18 @@global.wsrep_slave_fk_checks
19 0
20 SET @@global.wsrep_slave_fk_checks=ON;
21 Warnings:
22 Warning 1287 '@@wsrep_slave_FK_checks' is deprecated and will be removed in a future release
23 SELECT @@global.wsrep_slave_fk_checks;
24 @@global.wsrep_slave_fk_checks
25 1
26
27 # valid values
28 SET @@global.wsrep_slave_fk_checks='OFF';
29 Warnings:
30 Warning 1287 '@@wsrep_slave_FK_checks' is deprecated and will be removed in a future release
31 SELECT @@global.wsrep_slave_fk_checks;
32 @@global.wsrep_slave_fk_checks
33 0
34 SET @@global.wsrep_slave_fk_checks=ON;
35 Warnings:
36 Warning 1287 '@@wsrep_slave_FK_checks' is deprecated and will be removed in a future release
37 SELECT @@global.wsrep_slave_fk_checks;
38 @@global.wsrep_slave_fk_checks
39 1
40 SET @@global.wsrep_slave_fk_checks=default;
41 Warnings:
42 Warning 1287 '@@wsrep_slave_FK_checks' is deprecated and will be removed in a future release
43 SELECT @@global.wsrep_slave_fk_checks;
44 @@global.wsrep_slave_fk_checks
45 1
46
47 # invalid values
48 SET @@global.wsrep_slave_fk_checks=NULL;
49 ERROR 42000: Variable 'wsrep_slave_FK_checks' can't be set to the value of 'NULL'
50 SET @@global.wsrep_slave_fk_checks='junk';
51 ERROR 42000: Variable 'wsrep_slave_FK_checks' can't be set to the value of 'junk'
52
53 # restore the initial value
54 SET @@global.wsrep_slave_fk_checks = @wsrep_slave_fk_checks_global_saved;
55 Warnings:
56 Warning 1287 '@@wsrep_slave_FK_checks' is deprecated and will be removed in a future release
57 # End of test