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 SELECT @start_global_value;
3 @start_global_value
4 1
5 '#--------------------FN_DYNVARS_063_01-------------------------#'
6 SET @@global.log_bin_trust_function_creators = TRUE;
7 SET @@global.log_bin_trust_function_creators = DEFAULT;
8 SELECT @@global.log_bin_trust_function_creators;
9 @@global.log_bin_trust_function_creators
10 0
11 '#--------------------FN_DYNVARS_063_02-------------------------#'
12 SET @@global.log_bin_trust_function_creators = DEFAULT;
13 SELECT @@global.log_bin_trust_function_creators = 'FALSE';
14 @@global.log_bin_trust_function_creators = 'FALSE'
15 1
16 Warnings:
17 Warning 1292 Truncated incorrect DECIMAL value: 'FALSE'
18 '#--------------------FN_DYNVARS_063_03-------------------------#'
19 SET @@global.log_bin_trust_function_creators = ON;
20 SELECT @@global.log_bin_trust_function_creators;
21 @@global.log_bin_trust_function_creators
22 1
23 SET @@global.log_bin_trust_function_creators = OFF;
24 SELECT @@global.log_bin_trust_function_creators;
25 @@global.log_bin_trust_function_creators
26 0
27 SET @@global.log_bin_trust_function_creators = 0;
28 SELECT @@global.log_bin_trust_function_creators;
29 @@global.log_bin_trust_function_creators
30 0
31 SET @@global.log_bin_trust_function_creators = 1;
32 SELECT @@global.log_bin_trust_function_creators;
33 @@global.log_bin_trust_function_creators
34 1
35 SET @@global.log_bin_trust_function_creators = TRUE;
36 SELECT @@global.log_bin_trust_function_creators;
37 @@global.log_bin_trust_function_creators
38 1
39 SET @@global.log_bin_trust_function_creators = FALSE;
40 SELECT @@global.log_bin_trust_function_creators;
41 @@global.log_bin_trust_function_creators
42 0
43 '#-------------------FN_DYNVARS_063_04----------------------------#'
44 SET @@session.log_bin_trust_function_creators = 0;
45 ERROR HY000: Variable 'log_bin_trust_function_creators' is a GLOBAL variable and should be set with SET GLOBAL
46 SELECT @@session.log_bin_trust_function_creators;
47 ERROR HY000: Variable 'log_bin_trust_function_creators' is a GLOBAL variable
48 '#------------------FN_DYNVARS_063_05-----------------------#'
49 SET @@global.log_bin_trust_function_creators = 'ONN';
50 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of 'ONN'
51 SET @@global.log_bin_trust_function_creators = "OFFF";
52 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of 'OFFF'
53 SET @@global.log_bin_trust_function_creators = OF;
54 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of 'OF'
55 SET @@global.log_bin_trust_function_creators = TTRUE;
56 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of 'TTRUE'
57 SET @@global.log_bin_trust_function_creators = FELSE;
58 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of 'FELSE'
59 SET @@global.log_bin_trust_function_creators = -1024;
60 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of '-1024'
61 SET @@global.log_bin_trust_function_creators = 65536;
62 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of '65536'
63 SET @@global.log_bin_trust_function_creators = 65530.34;
64 ERROR 42000: Incorrect argument type to variable 'log_bin_trust_function_creators'
65 SET @@global.log_bin_trust_function_creators = test;
66 ERROR 42000: Variable 'log_bin_trust_function_creators' can't be set to the value of 'test'
67 '#------------------FN_DYNVARS_063_06-----------------------#'
68 SELECT IF(@@global.log_bin_trust_function_creators, "ON", "OFF") = VARIABLE_VALUE
69 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
70 WHERE VARIABLE_NAME='log_bin_trust_function_creators';
71 IF(@@global.log_bin_trust_function_creators, "ON", "OFF") = VARIABLE_VALUE
72 1
73 SELECT IF(@@session.log_bin_trust_function_creators, "ON", "OFF") = VARIABLE_VALUE
74 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
75 WHERE VARIABLE_NAME='log_bin_trust_function_creators';
76 ERROR HY000: Variable 'log_bin_trust_function_creators' is a GLOBAL variable
77 '#---------------------FN_DYNVARS_063_07----------------------#'
78 SET @@global.log_bin_trust_function_creators = TRUE;
79 SELECT @@log_bin_trust_function_creators = @@global.log_bin_trust_function_creators;
80 @@log_bin_trust_function_creators = @@global.log_bin_trust_function_creators
81 1
82 '#---------------------FN_DYNVARS_063_08----------------------#'
83 SET @@global.log_bin_trust_function_creators = TRUE;
84 SELECT @@log_bin_trust_function_creators;
85 @@log_bin_trust_function_creators
86 1
87 SELECT local.log_bin_trust_function_creators;
88 ERROR 42S02: Unknown table 'local' in SELECT
89 SELECT session.log_bin_trust_function_creators;
90 ERROR 42S02: Unknown table 'session' in SELECT
91 SELECT log_bin_trust_function_creators = @@session.log_bin_trust_function_creators;
92 ERROR 42S22: Unknown column 'log_bin_trust_function_creators' in 'SELECT'
93 SET @@global.log_bin_trust_function_creators = @start_global_value;
94 SELECT @@global.log_bin_trust_function_creators;
95 @@global.log_bin_trust_function_creators
96 1