← Back to branch summary

~ubuntu-branches/ubuntu/karmic/mysql-dfsg-5.1/karmic

« back to all changes in this revision

Viewing changes to mysql-test/r/log_bin_trust_routine_creators_basic.result

  • Committer: Bazaar Package Importer
  • Author(s): Mathias Gug
  • Date: 2009-06-25 12:55:45 UTC
  • mfrom: (0.2.1 upstream)
  • mto: This revision was merged to the branch mainline in revision 9.
  • Revision ID: james.westby@ubuntu.com-20090625125545-v27uqh8rlsj8uh2y
Tags: upstream-5.1.34
Import upstream version 5.1.34

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/log_bin_trust_routine_creators_basic.result
1
 
SET @start_global_value = @@global.log_bin_trust_routine_creators;
2
 
SELECT @start_global_value;
3
 
@start_global_value
4
 
1
5
 
'#--------------------FN_DYNVARS_064_01-------------------------#'
6
 
SET @@global.log_bin_trust_routine_creators = TRUE;
7
 
Warnings:
8
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
9
 
SET @@global.log_bin_trust_routine_creators = DEFAULT;
10
 
Warnings:
11
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
12
 
SELECT @@global.log_bin_trust_routine_creators;
13
 
@@global.log_bin_trust_routine_creators
14
 
0
15
 
'#--------------------FN_DYNVARS_064_02-------------------------#'
16
 
SET @@global.log_bin_trust_routine_creators = DEFAULT;
17
 
Warnings:
18
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
19
 
SELECT @@global.log_bin_trust_routine_creators = 'FALSE';
20
 
@@global.log_bin_trust_routine_creators = 'FALSE'
21
 
1
22
 
Warnings:
23
 
Warning 1292    Truncated incorrect DOUBLE value: 'FALSE'
24
 
'#--------------------FN_DYNVARS_064_03-------------------------#'
25
 
SET @@global.log_bin_trust_routine_creators = ON;
26
 
Warnings:
27
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
28
 
SELECT @@global.log_bin_trust_routine_creators;
29
 
@@global.log_bin_trust_routine_creators
30
 
1
31
 
SET @@global.log_bin_trust_routine_creators = OFF;
32
 
Warnings:
33
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
34
 
SELECT @@global.log_bin_trust_routine_creators;
35
 
@@global.log_bin_trust_routine_creators
36
 
0
37
 
SET @@global.log_bin_trust_routine_creators = 0;
38
 
Warnings:
39
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
40
 
SELECT @@global.log_bin_trust_routine_creators;
41
 
@@global.log_bin_trust_routine_creators
42
 
0
43
 
SET @@global.log_bin_trust_routine_creators = 1;
44
 
Warnings:
45
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
46
 
SELECT @@global.log_bin_trust_routine_creators;
47
 
@@global.log_bin_trust_routine_creators
48
 
1
49
 
SET @@global.log_bin_trust_routine_creators = TRUE;
50
 
Warnings:
51
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
52
 
SELECT @@global.log_bin_trust_routine_creators;
53
 
@@global.log_bin_trust_routine_creators
54
 
1
55
 
SET @@global.log_bin_trust_routine_creators = FALSE;
56
 
Warnings:
57
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
58
 
SELECT @@global.log_bin_trust_routine_creators;
59
 
@@global.log_bin_trust_routine_creators
60
 
0
61
 
'#-------------------FN_DYNVARS_064_04----------------------------#'
62
 
SET @@session.log_bin_trust_routine_creators = 0;
63
 
ERROR HY000: Variable 'log_bin_trust_routine_creators' is a GLOBAL variable and should be set with SET GLOBAL
64
 
SELECT @@session.log_bin_trust_routine_creators;
65
 
ERROR HY000: Variable 'log_bin_trust_routine_creators' is a GLOBAL variable
66
 
'#------------------FN_DYNVARS_064_05-----------------------#'
67
 
SET @@global.log_bin_trust_routine_creators = 'ONN';
68
 
ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of 'ONN'
69
 
SET @@global.log_bin_trust_routine_creators = "OFFF";
70
 
ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of 'OFFF'
71
 
SET @@global.log_bin_trust_routine_creators = OF;
72
 
Warnings:
73
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
74
 
SELECT @@global.log_bin_trust_routine_creators;
75
 
@@global.log_bin_trust_routine_creators
76
 
0
77
 
'Bug# 34828: OF is also working as OFF and no error is coming';
78
 
SET @@global.log_bin_trust_routine_creators = TTRUE;
79
 
ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of 'TTRUE'
80
 
SET @@global.log_bin_trust_routine_creators = FELSE;
81
 
ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of 'FELSE'
82
 
SET @@global.log_bin_trust_routine_creators = -1024;
83
 
ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of '-1024'
84
 
SET @@global.log_bin_trust_routine_creators = 65536;
85
 
ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of '65536'
86
 
SET @@global.log_bin_trust_routine_creators = 65530.34;
87
 
ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of '65530'
88
 
SET @@global.log_bin_trust_routine_creators = test;
89
 
ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of 'test'
90
 
'#------------------FN_DYNVARS_064_06-----------------------#'
91
 
SELECT @@global.log_bin_trust_routine_creators = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_bin_trust_routine_creators';
92
 
@@global.log_bin_trust_routine_creators = VARIABLE_VALUE
93
 
1
94
 
SELECT @@session.log_bin_trust_routine_creators = VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='log_bin_trust_routine_creators';
95
 
ERROR HY000: Variable 'log_bin_trust_routine_creators' is a GLOBAL variable
96
 
'#---------------------FN_DYNVARS_064_07----------------------#'
97
 
SET @@global.log_bin_trust_routine_creators = TRUE;
98
 
Warnings:
99
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
100
 
SELECT @@log_bin_trust_routine_creators = @@global.log_bin_trust_routine_creators;
101
 
@@log_bin_trust_routine_creators = @@global.log_bin_trust_routine_creators
102
 
1
103
 
'#---------------------FN_DYNVARS_064_08----------------------#'
104
 
SET @@global.log_bin_trust_routine_creators = TRUE;
105
 
Warnings:
106
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
107
 
SELECT @@log_bin_trust_routine_creators;
108
 
@@log_bin_trust_routine_creators
109
 
1
110
 
SELECT local.log_bin_trust_routine_creators;
111
 
ERROR 42S02: Unknown table 'local' in field list
112
 
SELECT session.log_bin_trust_routine_creators;
113
 
ERROR 42S02: Unknown table 'session' in field list
114
 
SELECT log_bin_trust_routine_creators = @@session.log_bin_trust_routine_creators;
115
 
ERROR 42S22: Unknown column 'log_bin_trust_routine_creators' in 'field list'
116
 
SET @@global.log_bin_trust_routine_creators = @start_global_value;
117
 
Warnings:
118
 
Warning 1287    The syntax '@@log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use '@@log_bin_trust_function_creators' instead
119
 
SELECT @@global.log_bin_trust_routine_creators;
120
 
@@global.log_bin_trust_routine_creators
121
 
1