← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/archive.test

  • Committer: Brian Aker
  • Date: 2009-11-26 18:48:20 UTC
  • mfrom: (1226.1.3 push)
  • Revision ID: brian@gaz-20091126184820-hltr0upee0ahopsj
Bundle Brian + Monty  (been through staging, just collecting it as want
overall patch as seen by staging).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/archive.test
1318
1318
INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
1319
1319
INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
1320
1320
SELECT * FROM t2;
1321
 
OPTIMIZE TABLE t2;
 
1321
ALTER TABLE t2 ENGINE=ARCHIVE;
1322
1322
SELECT * FROM t2;
1323
1323
INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W');
1324
1324
INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
1325
1325
INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
1326
 
OPTIMIZE TABLE t2;
 
1326
ALTER TABLE t2 ENGINE=ARCHIVE;
1327
1327
SELECT * FROM t2;
1328
1328
 
1329
1329
#
1402
1402
INSERT INTO t5 VALUES (3, "foo");
1403
1403
INSERT INTO t5 VALUES (NULL, "foo");
1404
1404
SELECT * FROM t5;
1405
 
OPTIMIZE TABLE t5;
 
1405
ALTER TABLE t5 ENGINE=ARCHIVE;
1406
1406
SELECT * FROM t5;
1407
1407
 
1408
1408
SELECT * FROM t5 WHERE a=32;