← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to plugin/coercibility_function/tests/r/coercibility.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-10-02 14:17:48 UTC
  • mfrom: (1.1.1 upstream)
  • mto: (2.1.17 sid)
  • mto: This revision was merged to the branch mainline in revision 3.
  • Revision ID: james.westby@ubuntu.com-20101002141748-m6vbfbfjhrw1153e
Tags: 2010.09.1802-1
* New upstream release.
* Removed pid-file argument hack.
* Updated GPL-2 address to be new address.
* Directly copy in drizzledump.1 since debian doesn't have sphinx 1.0 yet.
* Link to jquery from libjs-jquery. Add it as a depend.
* Add drizzled.8 symlink to the install files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/coercibility_function/tests/r/coercibility.result
 
1
select coercibility('hello' collate utf8_roman_ci);
 
2
coercibility('hello' collate utf8_roman_ci)
 
3
0
 
4
set @a='hello';
 
5
select coercibility(@a);
 
6
coercibility(@a)
 
7
2
 
8
select coercibility(user());
 
9
coercibility(user())
 
10
3
 
11
select coercibility('hello');
 
12
coercibility('hello')
 
13
4
 
14
select coercibility(NULL);
 
15
coercibility(NULL)
 
16
5
 
17
create table t1 (a char(10));
 
18
insert into t1 values ('a'),('b'),('c');
 
19
select coercibility(max(a)) from t1;
 
20
coercibility(max(a))
 
21
2
 
22
drop table t1;
 
23
explain extended select coercibility(conv(130,16,10));
 
24
id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
 
25
1       SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    No tables used
 
26
Warnings:
 
27
Note    1003    select coercibility(conv(130,16,10)) AS `coercibility(conv(130,16,10))`
 
28
set @a='test';
 
29
select collation(@a),coercibility(@a);
 
30
collation(@a)   coercibility(@a)
 
31
utf8_general_ci 2
 
32
select @a='TEST';
 
33
@a='TEST'
 
34
1
 
35
select @a='TEST' collate utf8_bin;
 
36
@a='TEST' collate utf8_bin
 
37
0
 
38
set @a='test' collate utf8_general_ci;
 
39
select collation(@a),coercibility(@a);
 
40
collation(@a)   coercibility(@a)
 
41
utf8_general_ci 2
 
42
select @a='TEST';
 
43
@a='TEST'
 
44
1
 
45
select @a='TEST' collate utf8_bin;
 
46
@a='TEST' collate utf8_bin
 
47
0
 
48
select collation(@a:='test');
 
49
collation(@a:='test')
 
50
utf8_general_ci
 
51
select coercibility(@a:='test');
 
52
coercibility(@a:='test')
 
53
2
 
54
select collation(@a:='test' collate utf8_bin);
 
55
collation(@a:='test' collate utf8_bin)
 
56
utf8_bin
 
57
select coercibility(@a:='test' collate utf8_bin);
 
58
coercibility(@a:='test' collate utf8_bin)
 
59
2
 
60
select (@a:='test' collate utf8_bin) = 'TEST';
 
61
(@a:='test' collate utf8_bin) = 'TEST'
 
62
0
 
63
select collation(@a),coercibility(@a);
 
64
collation(@a)   coercibility(@a)
 
65
utf8_bin        2
 
66
select (@a:='test' collate utf8_bin) = 'TEST' collate utf8_general_ci;
 
67
(@a:='test' collate utf8_bin) = 'TEST' collate utf8_general_ci
 
68
1
 
69
select @v, coercibility(@v);
 
70
@v      coercibility(@v)
 
71
NULL    2
 
72
set @v1=null, @v2=1, @v3=1.1, @v4=now();
 
73
select coercibility(@v1),coercibility(@v2),coercibility(@v3),coercibility(@v4);
 
74
coercibility(@v1)       coercibility(@v2)       coercibility(@v3)       coercibility(@v4)
 
75
2       2       2       2