Debian Codegraph @

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

raw
1 SET @start_value = @@select_into_disk_sync;
2 SELECT @start_value;
3 @start_value
4 0
5 '#--------------------FN_DYNVARS_005_01------------------------#'
6 SET @@select_into_disk_sync = 1;
7 SET @@select_into_disk_sync = DEFAULT;
8 SELECT @@select_into_disk_sync;
9 @@select_into_disk_sync
10 0
11 '#--------------------FN_DYNVARS_005_02------------------------#'
12 SET @@select_into_disk_sync = 0;
13 SELECT @@select_into_disk_sync;
14 @@select_into_disk_sync
15 0
16 SET @@select_into_disk_sync = 1;
17 SELECT @@select_into_disk_sync;
18 @@select_into_disk_sync
19 1
20 '#--------------------FN_DYNVARS_005_03-------------------------#'
21 SET @@select_into_disk_sync = 2;
22 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of '2'
23 SET @@select_into_disk_sync = -1;
24 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of '-1'
25 SET @@select_into_disk_sync = TRUEF;
26 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of 'TRUEF'
27 SET @@select_into_disk_sync = TRUE_F;
28 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of 'TRUE_F'
29 SET @@select_into_disk_sync = FALSE0;
30 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of 'FALSE0'
31 SET @@select_into_disk_sync = OON;
32 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of 'OON'
33 SET @@select_into_disk_sync = ONN;
34 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of 'ONN'
35 SET @@select_into_disk_sync = OOFF;
36 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of 'OOFF'
37 SET @@select_into_disk_sync = 0FF;
38 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of '0FF'
39 SET @@select_into_disk_sync = ' ';
40 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of ' '
41 SET @@select_into_disk_sync = " ";
42 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of ' '
43 SET @@select_into_disk_sync = '';
44 ERROR 42000: Variable 'select_into_disk_sync' can't be set to the value of ''
45 '#-------------------FN_DYNVARS_005_04----------------------------#'
46 SET @@global.select_into_disk_sync = 1-@@global.select_into_disk_sync;
47 SELECT @@global.select_into_disk_sync;
48 @@global.select_into_disk_sync
49 1
50 SET @@global.select_into_disk_sync = 1-@@global.select_into_disk_sync;
51 '#----------------------FN_DYNVARS_005_05------------------------#'
52 SELECT IF(@@select_into_disk_sync, "ON", "OFF") = VARIABLE_VALUE
53 FROM performance_schema.session_variables
54 WHERE VARIABLE_NAME='select_into_disk_sync';
55 IF(@@select_into_disk_sync, "ON", "OFF") = VARIABLE_VALUE
56 1
57 '#---------------------FN_DYNVARS_005_06----------------------#'
58 SET @@select_into_disk_sync = OFF;
59 SELECT @@select_into_disk_sync;
60 @@select_into_disk_sync
61 0
62 SET @@select_into_disk_sync = ON;
63 SELECT @@select_into_disk_sync;
64 @@select_into_disk_sync
65 1
66 '#---------------------FN_DYNVARS_005_07----------------------#'
67 SET @@select_into_disk_sync = TRUE;
68 SELECT @@select_into_disk_sync;
69 @@select_into_disk_sync
70 1
71 SET @@select_into_disk_sync = FALSE;
72 SELECT @@select_into_disk_sync;
73 @@select_into_disk_sync
74 0
75 '#---------------------FN_DYNVARS_005_08----------------------#'
76 SET @@select_into_disk_sync = 0;
77 SELECT @@select_into_disk_sync = @@session.select_into_disk_sync;
78 @@select_into_disk_sync = @@session.select_into_disk_sync
79 1
80 SET @@select_into_disk_sync = 1;
81 SELECT @@select_into_disk_sync = @@local.select_into_disk_sync and @@local.select_into_disk_sync = @@session.select_into_disk_sync;
82 @@select_into_disk_sync = @@local.select_into_disk_sync and @@local.select_into_disk_sync = @@session.select_into_disk_sync
83 1
84 '#---------------------FN_DYNVARS_005_09----------------------#'
85 SET select_into_disk_sync = 1;
86 SELECT @@select_into_disk_sync;
87 @@select_into_disk_sync
88 1
89 SET local.select_into_disk_sync = 1;
90 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.select_into_disk_sync = 1' at line 1
91 SELECT local.select_into_disk_sync;
92 ERROR 42S02: Unknown table 'local' in field list
93 SET session.select_into_disk_sync = 1;
94 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.select_into_disk_sync = 1' at line 1
95 SELECT session.select_into_disk_sync;
96 ERROR 42S02: Unknown table 'session' in field list
97 select select_into_disk_sync;
98 ERROR 42S22: Unknown column 'select_into_disk_sync' in 'field list'
99 SET @@select_into_disk_sync = @start_value;
100 SELECT @@select_into_disk_sync;
101 @@select_into_disk_sync
102 0