~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to plugin/schema_dictionary/tests/r/binary_default.result

  • Committer: Padraig O'Sullivan
  • Date: 2010-04-17 01:38:47 UTC
  • mfrom: (1237.9.238 bad-staging)
  • Revision ID: osullivan.padraig@gmail.com-20100417013847-ibjioqsfbmf5yg4g
Merge trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
create table t1 (a varbinary(10) default '\0\0hi', b int default 42, c varchar(10) default "hello");
 
2
insert into t1 values ();
 
3
select hex(a) from t1;
 
4
hex(a)
 
5
00006869
 
6
select COLUMN_NAME,HEX(COLUMN_DEFAULT) from data_dictionary.columns where table_schema="test" and table_name="t1";
 
7
COLUMN_NAME     HEX(COLUMN_DEFAULT)
 
8
a       00006869
 
9
b       3432
 
10
c       68656C6C6F
 
11
drop table t1;