summaryrefslogtreecommitdiff
path: root/mysql-test/t/archive.test
diff options
context:
space:
mode:
authormsvensson@shellback.(none) <>2007-09-21 09:48:30 +0200
committermsvensson@shellback.(none) <>2007-09-21 09:48:30 +0200
commite41434fb950e5bd29d400c371b33038cb87b7446 (patch)
tree6637d760ae14b7d8dc4e8cae8770e9a27b8c3349 /mysql-test/t/archive.test
parent5e926bc1204059783375ae23c3fa34b7ad75bc0c (diff)
downloadmariadb-git-e41434fb950e5bd29d400c371b33038cb87b7446.tar.gz
Bug#30843 Bad Test addition to t/archive.test
- Add extra insert
Diffstat (limited to 'mysql-test/t/archive.test')
-rw-r--r--mysql-test/t/archive.test10
1 files changed, 9 insertions, 1 deletions
diff --git a/mysql-test/t/archive.test b/mysql-test/t/archive.test
index 61033fca3f7..d1c45a259c6 100644
--- a/mysql-test/t/archive.test
+++ b/mysql-test/t/archive.test
@@ -1348,7 +1348,15 @@ 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','');
-while (`SELECT COUNT(auto)!=1214 FROM t2`)
+
+# 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','');
+
+# Wait for the delayed insert to appear
+while (`SELECT COUNT(auto)!=1215 FROM t2`)
{
sleep 0.1;
}