~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/archive/tests/r/archive.result

  • Committer: Stewart Smith
  • Date: 2010-08-05 16:41:55 UTC
  • mfrom: (1638.9.13)
  • mto: (1720.1.1 drizzle)
  • mto: This revision was merged to the branch mainline in revision 1721.
  • Revision ID: stewart@flamingspork.com-20100805164155-7olu6iv6rwoxfsne
Merged store-foreign-key-in-table-proto into show-create-table-using-table-message.

Show diffs side-by-side

added added

removed removed

Lines of Context:
9920
9920
  `fld3` varchar(30) NOT NULL DEFAULT '',
9921
9921
  `fld4` varchar(35) NOT NULL DEFAULT '',
9922
9922
  `fld5` varchar(35) NOT NULL DEFAULT ''
9923
 
) ENGINE=ARCHIVE
 
9923
) ENGINE=ARCHIVE COLLATE = utf8_general_ci
9924
9924
SELECT * FROM t2 WHERE auto != 100000;
9925
9925
auto    fld1    companynr       fld3    fld4    fld5
9926
9926
1       1       0       Omaha   teethe  neat
11441
11441
  `b` blob,
11442
11442
  `c` int DEFAULT NULL,
11443
11443
  KEY `a` (`a`)
11444
 
) ENGINE=ARCHIVE
 
11444
) ENGINE=ARCHIVE COLLATE = utf8_general_ci
11445
11445
DROP TABLE t1, t2, t4, t5, t6;
11446
11446
create table t1(a blob) engine=archive;
11447
11447
insert into t1 set a='';