diff options
| author | msvensson@shellback.(none) <> | 2007-09-21 09:48:30 +0200 |
|---|---|---|
| committer | msvensson@shellback.(none) <> | 2007-09-21 09:48:30 +0200 |
| commit | e41434fb950e5bd29d400c371b33038cb87b7446 (patch) | |
| tree | 6637d760ae14b7d8dc4e8cae8770e9a27b8c3349 /mysql-test | |
| parent | 5e926bc1204059783375ae23c3fa34b7ad75bc0c (diff) | |
| download | mariadb-git-e41434fb950e5bd29d400c371b33038cb87b7446.tar.gz | |
Bug#30843 Bad Test addition to t/archive.test
- Add extra insert
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/archive.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/archive.test | 10 |
2 files changed, 12 insertions, 2 deletions
diff --git a/mysql-test/r/archive.result b/mysql-test/r/archive.result index b6a313ddf1a..a1c11417bd0 100644 --- a/mysql-test/r/archive.result +++ b/mysql-test/r/archive.result @@ -11124,9 +11124,10 @@ SELECT COUNT(auto) FROM t2; COUNT(auto) 1213 INSERT DELAYED INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily',''); +INSERT INTO t2 VALUES (5,000001,00,'after','delayed','insert',''); SELECT COUNT(auto) FROM t2; COUNT(auto) -1214 +1215 ALTER TABLE t2 DROP COLUMN fld6; SHOW CREATE TABLE t2; Table Create Table @@ -12354,6 +12355,7 @@ auto fld1 companynr fld3 fld4 fld5 3 011402 37 Romans scholastics jarring 4 011403 37 intercepted audiology tinily 4 011403 37 intercepted audiology tinily +5 000001 00 after delayed insert drop table t1, t2, t4; create table t1 (i int) engine=archive; insert into t1 values (1); 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; } |