← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/user_var.result

  • Committer: Monty Taylor
  • Date: 2009-01-28 04:37:46 UTC
  • mto: (779.7.3 devel)
  • mto: This revision was merged to the branch mainline in revision 816.
  • Revision ID: mordred@inaugust.com-20090128043746-d2yukekishwn3ftm
Turned on -Wshadow.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/user_var.result
135
135
hello again     hello   hello again     3       hello again     hello again
136
136
hello again     hello   hello again     3       hello again     hello again
137
137
drop table t1;
138
 
set @a=_utf8'test';
139
 
select collation(@a),coercibility(@a);
140
 
collation(@a)   coercibility(@a)
141
 
utf8_general_ci 2
142
 
select @a=_utf8'TEST';
143
 
@a=_utf8'TEST'
144
 
1
145
 
select @a=_utf8'TEST' collate utf8_bin;
146
 
@a=_utf8'TEST' collate utf8_bin
147
 
0
148
 
set @a=_utf8'test' collate utf8_general_ci;
149
 
select collation(@a),coercibility(@a);
150
 
collation(@a)   coercibility(@a)
151
 
utf8_general_ci 2
152
 
select @a=_utf8'TEST';
153
 
@a=_utf8'TEST'
154
 
1
155
 
select @a=_utf8'TEST' collate utf8_bin;
156
 
@a=_utf8'TEST' collate utf8_bin
157
 
0
158
 
select collation(@a:=_utf8'test');
159
 
collation(@a:=_utf8'test')
 
138
set @a='test';
 
139
select collation(@a),coercibility(@a);
 
140
collation(@a)   coercibility(@a)
 
141
utf8_general_ci 2
 
142
select @a='TEST';
 
143
@a='TEST'
 
144
1
 
145
select @a='TEST' collate utf8_bin;
 
146
@a='TEST' collate utf8_bin
 
147
0
 
148
set @a='test' collate utf8_general_ci;
 
149
select collation(@a),coercibility(@a);
 
150
collation(@a)   coercibility(@a)
 
151
utf8_general_ci 2
 
152
select @a='TEST';
 
153
@a='TEST'
 
154
1
 
155
select @a='TEST' collate utf8_bin;
 
156
@a='TEST' collate utf8_bin
 
157
0
 
158
select collation(@a:='test');
 
159
collation(@a:='test')
160
160
utf8_general_ci
161
 
select coercibility(@a:=_utf8'test');
162
 
coercibility(@a:=_utf8'test')
 
161
select coercibility(@a:='test');
 
162
coercibility(@a:='test')
163
163
2
164
 
select collation(@a:=_utf8'test' collate utf8_bin);
165
 
collation(@a:=_utf8'test' collate utf8_bin)
 
164
select collation(@a:='test' collate utf8_bin);
 
165
collation(@a:='test' collate utf8_bin)
166
166
utf8_bin
167
 
select coercibility(@a:=_utf8'test' collate utf8_bin);
168
 
coercibility(@a:=_utf8'test' collate utf8_bin)
 
167
select coercibility(@a:='test' collate utf8_bin);
 
168
coercibility(@a:='test' collate utf8_bin)
169
169
2
170
 
select (@a:=_utf8'test' collate utf8_bin) = _utf8'TEST';
171
 
(@a:=_utf8'test' collate utf8_bin) = _utf8'TEST'
 
170
select (@a:='test' collate utf8_bin) = 'TEST';
 
171
(@a:='test' collate utf8_bin) = 'TEST'
172
172
0
173
173
select collation(@a),coercibility(@a);
174
174
collation(@a)   coercibility(@a)
175
175
utf8_bin        2
176
 
select (@a:=_utf8'test' collate utf8_bin) = _utf8'TEST' collate utf8_general_ci;
177
 
(@a:=_utf8'test' collate utf8_bin) = _utf8'TEST' collate utf8_general_ci
 
176
select (@a:='test' collate utf8_bin) = 'TEST' collate utf8_general_ci;
 
177
(@a:='test' collate utf8_bin) = 'TEST' collate utf8_general_ci
178
178
1
179
179
set @var= NULL ;
180
180
select FIELD( @var,'1it','Hit') as my_column;