← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/archive.test

  • Committer: Padraig O'Sullivan
  • Date: 2009-11-28 22:02:19 UTC
  • mfrom: (1228 push)
  • mto: (1228.4.1 push)
  • mto: This revision was merged to the branch mainline in revision 1234.
  • Revision ID: osullivan.padraig@gmail.com-20091128220219-m3x28m8q2unbirke
Merge from trunk.

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;