Debian Codegraph @

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

raw
1 SET @start_session_value = @@session.unique_checks;
2 SELECT @start_session_value;
3 @start_session_value
4 1
5 '#--------------------FN_DYNVARS_005_01-------------------------#'
6 SET @@session.unique_checks= 1;
7 SET @@session.unique_checks= DEFAULT;
8 SELECT @@session.unique_checks;
9 @@session.unique_checks
10 0
11 '#--------------------FN_DYNVARS_005_04-------------------------#'
12 SET @@session.unique_checks =1;
13 SELECT @@session.unique_checks;
14 @@session.unique_checks
15 1
16 SET @@session.unique_checks = 0;
17 SELECT @@session.unique_checks;
18 @@session.unique_checks
19 0
20 SET @@session.unique_checks = True;
21 SELECT @@session.unique_checks;
22 @@session.unique_checks
23 1
24 SET @@session.unique_checks = False;
25 SELECT @@session.unique_checks;
26 @@session.unique_checks
27 0
28 SET @@session.unique_checks = "ON";
29 SELECT @@session.unique_checks;
30 @@session.unique_checks
31 1
32 SET @@session.unique_checks = "OFF";
33 SELECT @@session.unique_checks;
34 @@session.unique_checks
35 0
36 '#------------------FN_DYNVARS_005_05-----------------------#'
37 SET @@session.unique_checks = 'No';
38 ERROR 42000: Variable 'unique_checks' can't be set to the value of 'No'
39 SET @@session.unique_checks = "yes";
40 ERROR 42000: Variable 'unique_checks' can't be set to the value of 'yes'
41 SET @@session.unique_checks = yes;
42 ERROR 42000: Variable 'unique_checks' can't be set to the value of 'yes'
43 SET @@session.unique_checks = NO;
44 ERROR 42000: Variable 'unique_checks' can't be set to the value of 'NO'
45 SET @@session.unique_checks = "True";
46 ERROR 42000: Variable 'unique_checks' can't be set to the value of 'True'
47 SET @@session.unique_checks = "False";
48 ERROR 42000: Variable 'unique_checks' can't be set to the value of 'False'
49 SET @@session.unique_checks = "Test";
50 ERROR 42000: Variable 'unique_checks' can't be set to the value of 'Test'
51 SET @@session.unique_checks = 'test';
52 ERROR 42000: Variable 'unique_checks' can't be set to the value of 'test'
53 SET @@session.unique_checks = 123456789031;
54 ERROR 42000: Variable 'unique_checks' can't be set to the value of '123456789031'
55 '#------------------FN_DYNVARS_005_07-----------------------#'
56 SELECT IF(@@session.unique_checks, "ON", "OFF") = VARIABLE_VALUE
57 FROM performance_schema.session_variables
58 WHERE VARIABLE_NAME='unique_checks';
59 IF(@@session.unique_checks, "ON", "OFF") = VARIABLE_VALUE
60 1
61 '#---------------------FN_DYNVARS_001_08----------------------#'
62 SET @@unique_checks = 1;
63 SELECT @@unique_checks = @@local.unique_checks;
64 @@unique_checks = @@local.unique_checks
65 1
66 SELECT @@local.unique_checks = @@session.unique_checks;
67 @@local.unique_checks = @@session.unique_checks
68 1
69 '#---------------------FN_DYNVARS_001_09----------------------#'
70 SET unique_checks = 1027;
71 ERROR 42000: Variable 'unique_checks' can't be set to the value of '1027'
72 SELECT @@unique_checks;
73 @@unique_checks
74 1
75 SELECT local.unique_checks;
76 ERROR 42S02: Unknown table 'local' in field list
77 SELECT session.unique_checks;
78 ERROR 42S02: Unknown table 'session' in field list
79 SELECT unique_checks = @@session.unique_checks;
80 ERROR 42S22: Unknown column 'unique_checks' in 'field list'
81 SET @@session.unique_checks = @start_session_value;
82 SELECT @@session.unique_checks;
83 @@session.unique_checks
84 1