← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/null_key.result

  • Committer: Olaf van der Spek
  • Date: 2011-07-24 16:27:12 UTC
  • mfrom: (2371 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2384.
  • Revision ID: olafvdspek@gmail.com-20110724162712-nrut3uifjnu295xs
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/null_key.result
79
79
t2      CREATE TEMPORARY TABLE `t2` (
80
80
  `a` INT DEFAULT NULL,
81
81
  `b` INT NOT NULL,
82
 
  UNIQUE KEY `a` (`a`,`b`),
83
 
  KEY `b` (`b`)
 
82
  UNIQUE KEY `a` (`a`,`b`) USING BTREE,
 
83
  KEY `b` (`b`) USING BTREE
84
84
) ENGINE=MyISAM COLLATE = utf8_general_ci
85
85
insert into t2 select * from t1;
86
86
alter table t1 modify b blob not null, add c int DEFAULT 42 not null, drop key a, add unique key (a,b(20),c), drop key b, add key (b(10));