~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/strict.result

  • Committer: Brian Aker
  • Date: 2011-07-15 08:26:31 UTC
  • mto: (2392.1.1 drizzle-autoconf)
  • mto: This revision was merged to the branch mainline in revision 2369.
  • Revision ID: brian@tangent.org-20110715082631-y8oo7j1aug8nwlym
This patch fixes 798940, we will also just now add the type of index to our create statements.

Show diffs side-by-side

added added

removed removed

Lines of Context:
434
434
t1      CREATE TABLE `t1` (
435
435
  `a` INT NOT NULL,
436
436
  `b` TIMESTAMP NULL DEFAULT NULL,
437
 
  PRIMARY KEY (`a`)
 
437
  PRIMARY KEY (`a`) USING BTREE
438
438
) ENGINE=DEFAULT COLLATE = utf8_general_ci
439
439
drop table t1;
440
440
create table t1(a int, b timestamp default 20050102030405);
444
444
t1      CREATE TABLE `t1` (
445
445
  `a` INT NOT NULL,
446
446
  `b` TIMESTAMP NULL DEFAULT '2005-01-02 03:04:05',
447
 
  PRIMARY KEY (`a`)
 
447
  PRIMARY KEY (`a`) USING BTREE
448
448
) ENGINE=DEFAULT COLLATE = utf8_general_ci
449
449
drop table t1;
450
450
create table t1 (date date not null);