← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/binary.result

Merged build.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/binary.result
1
1
drop table if exists t1,t2;
2
 
create table t1 (a char(10) not null, b char(10) binary not null,key (a), key(b));
 
2
create table t1 (a char(10) not null, b char(10) not null,key (a), key(b));
3
3
insert into t1 values ("hello ","hello "),("hello2 ","hello2 ");
4
4
select concat("-",a,"-",b,"-") from t1 where a="hello";
5
5
concat("-",a,"-",b,"-")
41
41
select b from t1 having binary b like '';
42
42
b
43
43
drop table t1;
44
 
create table t1 (a char(3) binary, b varbinary(3));
 
44
create table t1 (a char(3), b varbinary(3));
45
45
insert into t1 values ('aaa','bbb'),('AAA','BBB');
46
46
select upper(a),upper(b) from t1;
47
47
upper(a)        upper(b)
67
67
aaa     bbb
68
68
select collation(a), collation(b), collation(binary 'ccc') from t1 limit 1;
69
69
collation(a)    collation(b)    collation(binary 'ccc')
70
 
utf8_bin        binary  binary
 
70
utf8_general_ci binary  binary
71
71
drop table t1;
72
72
create table t1( firstname char(20), lastname char(20));
73
73
insert into t1 values ("john","doe"),("John","Doe");