← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/binary.test

  • Committer: Brian Aker
  • Date: 2009-11-13 00:56:59 UTC
  • Revision ID: brian@gir.local-20091113005659-c8e29r7wt6x4irqw
Removed bits of charset support from the parser.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/binary.test
29
29
# Test of binary and normal strings
30
30
#
31
31
 
32
 
create table t1 (a char(10) not null, b char(10) binary not null,key (a), key(b));
 
32
create table t1 (a char(10) not null, b char(10) not null,key (a), key(b));
33
33
insert into t1 values ("hello ","hello "),("hello2 ","hello2 ");
34
34
select concat("-",a,"-",b,"-") from t1 where a="hello";
35
35
select concat("-",a,"-",b,"-") from t1 where a="hello ";
57
57
#
58
58
# Test of binary and upper/lower
59
59
#
60
 
create table t1 (a char(3) binary, b varbinary(3));
 
60
create table t1 (a char(3), b varbinary(3));
61
61
insert into t1 values ('aaa','bbb'),('AAA','BBB');
62
62
select upper(a),upper(b) from t1;
63
63
select lower(a),lower(b) from t1;