← 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-01-17 02:46:52 UTC
  • Revision ID: brian@gir-3.local-20090117024652-4ducefje08ajbs1q
Refactor append_identifier and remove dead OPTION_QUOTE_SHOW_CREATE option
(we always quote).

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) not null,key (a), key(b));
 
32
create table t1 (a char(10) not null, b char(10) binary 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), b varbinary(3));
 
60
create table t1 (a char(3) binary, 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;
85
85
# Bug #6552 CHAR column w/o length is legal, BINARY w/o length is not
86
86
#
87
87
create table t1 (a char);
88
 
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
89
88
show create table t1;
90
89
drop table t1;
91
90
--error 1064