← 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-05-13 02:07:22 UTC
  • mfrom: (1008.1.5 merge)
  • Revision ID: brian@gaz-20090513020722-9nqehweityhn6ab0
Merge in refactoring around lock system

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/archive.test
1352
1352
SELECT * FROM t2;
1353
1353
 
1354
1354
 
1355
 
# Test INSERT DELAYED and wait until the table has one more record
1356
 
SELECT COUNT(auto) FROM t2;
1357
 
INSERT DELAYED INTO t2 VALUES (99999,011403,37,'the','delayed','insert','');
1358
 
 
1359
 
# Insert another record since in Archive delayed values are only
1360
 
# guaranteed to materialize based on either:
1361
 
# 1) A new row showing up from a normal insert
1362
 
# 2) A flush table  has occurred.
1363
 
INSERT INTO t2 VALUES (100000,000001,00,'after','delayed','insert','');
1364
 
 
1365
 
# Wait for the delayed insert to appear
1366
 
while (`SELECT COUNT(auto)!=1215 FROM t2`)
1367
 
{
1368
 
  sleep 0.1;
1369
 
}
1370
 
SELECT COUNT(auto) FROM t2;
1371
 
 
1372
1355
# Adding test for ALTER TABLE
1373
1356
ALTER TABLE t2 DROP COLUMN fld6; 
1374
1357
SHOW CREATE TABLE t2;