← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/common-tests.inc

  • Committer: Brian Aker
  • Date: 2008-10-11 02:12:38 UTC
  • Revision ID: brian@tangent.org-20081011021238-bq0uu7pzrx20zaq2
Modified test to just use myisam. This should allow us to continue to use
the EXPLAINS in it.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/common-tests.inc
16
16
CREATE TABLE t1 (
17
17
  Period int DEFAULT '0000' NOT NULL,
18
18
  Varor_period int DEFAULT '0' NOT NULL
19
 
);
 
19
) ENGINE=myisam;
20
20
 
21
21
INSERT INTO t1 VALUES (9410,9412);
22
22
  
39
39
  UNIQUE fld1 (fld1),
40
40
  KEY fld3 (fld3),
41
41
  PRIMARY KEY (auto)
42
 
);  
 
42
) ENGINE=myisam;  
43
43
 
44
44
#
45
45
# Populate table
1369
1369
 price2     double(11,0),
1370
1370
 key (period),
1371
1371
 key (name)
1372
 
);
 
1372
) engine=myisam;
1373
1373
 
1374
1374
--disable_query_log
1375
1375
INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1001,"Iranizes",37,5987435,234724);