Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.log_bin_trust_function_creators;
2 Warnings:
3 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
4 SELECT @start_global_value;
5 @start_global_value
6 1
7 '#--------------------FN_DYNVARS_063_01-------------------------#'
8 SET @@global.log_bin_trust_function_creators = TRUE;
9 Warnings:
10 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
11 SET @@global.log_bin_trust_function_creators = DEFAULT;
12 Warnings:
13 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
14 SELECT @@global.log_bin_trust_function_creators;
15 @@global.log_bin_trust_function_creators
16 0
17 Warnings:
18 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
19 '#--------------------FN_DYNVARS_063_02-------------------------#'
20 SET @@global.log_bin_trust_function_creators = DEFAULT;
21 Warnings:
22 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
23 SELECT @@global.log_bin_trust_function_creators = 'FALSE';
24 @@global.log_bin_trust_function_creators = 'FALSE'
25 1
26 Warnings:
27 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
28 Warning 1292 Truncated incorrect DOUBLE value: 'FALSE'
29 '#--------------------FN_DYNVARS_063_03-------------------------#'
30 SET @@global.log_bin_trust_function_creators = ON;
31 Warnings:
32 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
33 SELECT @@global.log_bin_trust_function_creators;
34 @@global.log_bin_trust_function_creators
35 1
36 Warnings:
37 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
38 SET @@global.log_bin_trust_function_creators = OFF;
39 Warnings:
40 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
41 SELECT @@global.log_bin_trust_function_creators;
42 @@global.log_bin_trust_function_creators
43 0
44 Warnings:
45 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
46 SET @@global.log_bin_trust_function_creators = 0;
47 Warnings:
48 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
49 SELECT @@global.log_bin_trust_function_creators;
50 @@global.log_bin_trust_function_creators
51 0
52 Warnings:
53 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
54 SET @@global.log_bin_trust_function_creators = 1;
55 Warnings:
56 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
57 SELECT @@global.log_bin_trust_function_creators;
58 @@global.log_bin_trust_function_creators
59 1
60 Warnings:
61 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
62 SET @@global.log_bin_trust_function_creators = TRUE;
63 Warnings:
64 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
65 SELECT @@global.log_bin_trust_function_creators;
66 @@global.log_bin_trust_function_creators
67 1
68 Warnings:
69 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
70 SET @@global.log_bin_trust_function_creators = FALSE;
71 Warnings:
72 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
73 SELECT @@global.log_bin_trust_function_creators;
74 @@global.log_bin_trust_function_creators
75 0
76 Warnings:
77 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
78 '#-------------------FN_DYNVARS_063_04----------------------------#'
79 SET @@session.log_bin_trust_function_creators = 0;
80 ERROR HY000: Variable 'log_bin_trust_function_creators' is a GLOBAL variable and should be set with SET GLOBAL
81 SELECT @@session.log_bin_trust_function_creators;
82 ERROR HY000: Variable 'log_bin_trust_function_creators' is a GLOBAL variable
83 '#------------------FN_DYNVARS_063_05-----------------------#'
84 SET @@global.log_bin_trust_function_creators = 'ONN';
85 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of 'ONN'
86 SET @@global.log_bin_trust_function_creators = "OFFF";
87 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of 'OFFF'
88 SET @@global.log_bin_trust_function_creators = OF;
89 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 'OF' at line 1
90 SET @@global.log_bin_trust_function_creators = TTRUE;
91 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of 'TTRUE'
92 SET @@global.log_bin_trust_function_creators = FELSE;
93 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of 'FELSE'
94 SET @@global.log_bin_trust_function_creators = -1024;
95 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of '-1024'
96 SET @@global.log_bin_trust_function_creators = 65536;
97 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of '65536'
98 SET @@global.log_bin_trust_function_creators = 65530.34;
99 ERROR 42000: Incorrect argument type to variable 'log_bin_trust_function_creators'
100 SET @@global.log_bin_trust_function_creators = test;
101 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of 'test'
102 '#------------------FN_DYNVARS_063_06-----------------------#'
103 SELECT IF(@@global.log_bin_trust_function_creators, "ON", "OFF") = VARIABLE_VALUE
104 FROM performance_schema.global_variables
105 WHERE VARIABLE_NAME='log_bin_trust_function_creators';
106 IF(@@global.log_bin_trust_function_creators, "ON", "OFF") = VARIABLE_VALUE
107 1
108 SELECT IF(@@session.log_bin_trust_function_creators, "ON", "OFF") = VARIABLE_VALUE
109 FROM performance_schema.session_variables
110 WHERE VARIABLE_NAME='log_bin_trust_function_creators';
111 ERROR HY000: Variable 'log_bin_trust_function_creators' is a GLOBAL variable
112 '#---------------------FN_DYNVARS_063_07----------------------#'
113 SET @@global.log_bin_trust_function_creators = TRUE;
114 Warnings:
115 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
116 SELECT @@log_bin_trust_function_creators = @@global.log_bin_trust_function_creators;
117 @@log_bin_trust_function_creators = @@global.log_bin_trust_function_creators
118 1
119 Warnings:
120 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
121 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
122 '#---------------------FN_DYNVARS_063_08----------------------#'
123 SET @@global.log_bin_trust_function_creators = TRUE;
124 Warnings:
125 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
126 SELECT @@log_bin_trust_function_creators;
127 @@log_bin_trust_function_creators
128 1
129 Warnings:
130 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
131 SELECT local.log_bin_trust_function_creators;
132 ERROR 42S02: Unknown table 'local' in field list
133 SELECT session.log_bin_trust_function_creators;
134 ERROR 42S02: Unknown table 'session' in field list
135 SELECT log_bin_trust_function_creators;
136 ERROR 42S22: Unknown column 'log_bin_trust_function_creators' in 'field list'
137 SELECT @@session.log_bin_trust_function_creators;
138 ERROR HY000: Variable 'log_bin_trust_function_creators' is a GLOBAL variable
139 SET @@global.log_bin_trust_function_creators = @start_global_value;
140 Warnings:
141 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
142 SELECT @@global.log_bin_trust_function_creators;
143 @@global.log_bin_trust_function_creators
144 1
145 Warnings:
146 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.