← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/execute/r/basic.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/suite/execute/r/basic.result
30
30
Table   Create Table
31
31
t1      CREATE TABLE `t1` (
32
32
  `a` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
33
 
  UNIQUE KEY `a` (`a`)
 
33
  UNIQUE KEY `a` (`a`) USING BTREE
34
34
) ENGINE=InnoDB COLLATE = utf8_general_ci
35
35
EXECUTE "INSERT INTO t1 VALUES ()";
36
36
EXECUTE "DROP TABLE t1";
160
160
Table   Create Table
161
161
t1      CREATE TABLE `t1` (
162
162
  `a` INT DEFAULT NULL,
163
 
  KEY `a_index` (`a`)
 
163
  KEY `a_index` (`a`) USING BTREE
164
164
) ENGINE=InnoDB COLLATE = utf8_general_ci
165
165
SET @var = "DROP INDEX a_index ON t1";
166
166
EXECUTE @var;