Debian Codegraph @

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

raw
1 SET @start_value= @@global.log_statements_unsafe_for_binlog;
2 Warnings:
3 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
4 SET @@global.log_statements_unsafe_for_binlog= DEFAULT;
5 Warnings:
6 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
7 SELECT @@global.log_statements_unsafe_for_binlog;
8 @@global.log_statements_unsafe_for_binlog
9 1
10 Warnings:
11 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
12 SET @@global.log_statements_unsafe_for_binlog= TRUE;
13 Warnings:
14 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
15 SELECT @@global.log_statements_unsafe_for_binlog;
16 @@global.log_statements_unsafe_for_binlog
17 1
18 Warnings:
19 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
20 SET @@global.log_statements_unsafe_for_binlog= true;
21 Warnings:
22 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
23 SELECT @@global.log_statements_unsafe_for_binlog;
24 @@global.log_statements_unsafe_for_binlog
25 1
26 Warnings:
27 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
28 SET @@global.log_statements_unsafe_for_binlog= 0;
29 Warnings:
30 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
31 SELECT @@global.log_statements_unsafe_for_binlog;
32 @@global.log_statements_unsafe_for_binlog
33 0
34 Warnings:
35 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
36 SET @@global.log_statements_unsafe_for_binlog= 1;
37 Warnings:
38 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
39 SELECT @@global.log_statements_unsafe_for_binlog;
40 @@global.log_statements_unsafe_for_binlog
41 1
42 Warnings:
43 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
44 SET @goodvar= TRUE;
45 SET @@global.log_statements_unsafe_for_binlog= @goodvar;
46 Warnings:
47 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
48 SELECT @@global.log_statements_unsafe_for_binlog;
49 @@global.log_statements_unsafe_for_binlog
50 1
51 Warnings:
52 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
53 SET GLOBAL log_statements_unsafe_for_binlog= DEFAULT;
54 Warnings:
55 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
56 SELECT @@global.log_statements_unsafe_for_binlog;
57 @@global.log_statements_unsafe_for_binlog
58 1
59 Warnings:
60 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
61 SET GLOBAL log_statements_unsafe_for_binlog= ON;
62 Warnings:
63 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
64 SELECT @@global.log_statements_unsafe_for_binlog;
65 @@global.log_statements_unsafe_for_binlog
66 1
67 Warnings:
68 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
69 SET GLOBAL log_statements_unsafe_for_binlog= OFF;
70 Warnings:
71 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
72 SELECT @@global.log_statements_unsafe_for_binlog;
73 @@global.log_statements_unsafe_for_binlog
74 0
75 Warnings:
76 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
77 SET GLOBAL log_statements_unsafe_for_binlog= -0;
78 Warnings:
79 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
80 SELECT @@global.log_statements_unsafe_for_binlog;
81 @@global.log_statements_unsafe_for_binlog
82 0
83 Warnings:
84 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
85 SET GLOBAL log_statements_unsafe_for_binlog= 0.00;
86 ERROR 42000: Incorrect argument type to variable 'log_statements_unsafe_for_binlog'
87 SET GLOBAL log_statements_unsafe_for_binlog= +0;
88 Warnings:
89 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
90 SELECT @@global.log_statements_unsafe_for_binlog;
91 @@global.log_statements_unsafe_for_binlog
92 0
93 Warnings:
94 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
95 SET @@global.log_statements_unsafe_for_binlog= 'DEFAULT';
96 ERROR 42000: Variable 'log_statements_unsafe_for_binlog' can't be set to the value of 'DEFAULT'
97 SET @@global.log_statements_unsafe_for_binlog= 'true';
98 ERROR 42000: Variable 'log_statements_unsafe_for_binlog' can't be set to the value of 'true'
99 SET @@global.log_statements_unsafe_for_binlog= BLABLA;
100 ERROR 42000: Variable 'log_statements_unsafe_for_binlog' can't be set to the value of 'BLABLA'
101 SET @@global.log_statements_unsafe_for_binlog= 25;
102 ERROR 42000: Variable 'log_statements_unsafe_for_binlog' can't be set to the value of '25'
103 SET GLOBAL log_statements_unsafe_for_binlog= -1;
104 ERROR 42000: Variable 'log_statements_unsafe_for_binlog' can't be set to the value of '-1'
105 SET @badvar= 'true';
106 SET @@global.log_statements_unsafe_for_binlog= @badvar;
107 ERROR 42000: Variable 'log_statements_unsafe_for_binlog' can't be set to the value of 'true'
108 SET GLOBAL log_statements_unsafe_for_binlog= 'DEFAULT';
109 ERROR 42000: Variable 'log_statements_unsafe_for_binlog' can't be set to the value of 'DEFAULT'
110 SET log_statements_unsafe_for_binlog= TRUE;
111 ERROR HY000: Variable 'log_statements_unsafe_for_binlog' is a GLOBAL variable and should be set with SET GLOBAL
112 SET SESSION log_statements_unsafe_for_binlog= TRUE;
113 ERROR HY000: Variable 'log_statements_unsafe_for_binlog' is a GLOBAL variable and should be set with SET GLOBAL
114 SET @@session.log_statements_unsafe_for_binlog= TRUE;
115 ERROR HY000: Variable 'log_statements_unsafe_for_binlog' is a GLOBAL variable and should be set with SET GLOBAL
116 SET LOCAL log_statements_unsafe_for_binlog= TRUE;
117 ERROR HY000: Variable 'log_statements_unsafe_for_binlog' is a GLOBAL variable and should be set with SET GLOBAL
118 SET @@global log_statements_unsafe_for_binlog= TRUE;
119 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 'log_statements_unsafe_for_binlog= TRUE' at line 1
120 SET @@SESSION log_statements_unsafe_for_binlog= TRUE;
121 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 'log_statements_unsafe_for_binlog= TRUE' at line 1
122 SET @@global.log_statements_unsafe_for_binlog= @start_value;
123 Warnings:
124 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.