diff options
| author | unknown <msvensson@shellback.(none)> | 2007-09-22 12:17:14 +0200 |
|---|---|---|
| committer | unknown <msvensson@shellback.(none)> | 2007-09-22 12:17:14 +0200 |
| commit | cfbb6fc63255dadb92af18546fa7ebe8d91aa870 (patch) | |
| tree | b333fbd8340f4db733f6ca5b2206bc599af02379 /mysql-test/t/archive.test | |
| parent | 150953a36a9fd4985225380f9486788a039c5083 (diff) | |
| download | mariadb-git-cfbb6fc63255dadb92af18546fa7ebe8d91aa870.tar.gz | |
Bug#30843 Bad Test addition to t/archive.test
mysql-test/r/archive.result:
Don't care about the "after insert delayed" record when since
we can't guarantee the order it's been inserted
mysql-test/t/archive.test:
Don't care about the "after insert delayed" record when since
we can't guarantee the order it's been inserted
Diffstat (limited to 'mysql-test/t/archive.test')
| -rw-r--r-- | mysql-test/t/archive.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/t/archive.test b/mysql-test/t/archive.test index d1c45a259c6..2d29cab041d 100644 --- a/mysql-test/t/archive.test +++ b/mysql-test/t/archive.test @@ -1347,13 +1347,13 @@ SELECT * FROM t2; # Test INSERT DELAYED and wait until the table has one more record SELECT COUNT(auto) FROM t2; -INSERT DELAYED INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily',''); +INSERT DELAYED INTO t2 VALUES (99999,011403,37,'the','delayed','insert',''); # Insert another record since in Archive delayed values are only # guaranteed to materialize based on either: # 1) A new row showing up from a normal insert # 2) A flush table has occurred. -INSERT INTO t2 VALUES (5,000001,00,'after','delayed','insert',''); +INSERT INTO t2 VALUES (100000,000001,00,'after','delayed','insert',''); # Wait for the delayed insert to appear while (`SELECT COUNT(auto)!=1215 FROM t2`) @@ -1365,7 +1365,7 @@ SELECT COUNT(auto) FROM t2; # Adding test for alter table ALTER TABLE t2 DROP COLUMN fld6; SHOW CREATE TABLE t2; -SELECT * from t2; +SELECT * from t2 WHERE auto != 100000; # # Cleanup, test is over # |