summaryrefslogtreecommitdiff
path: root/mysql-test/r/archive.result
diff options
context:
space:
mode:
authormsvensson@shellback.(none) <>2007-09-22 12:17:14 +0200
committermsvensson@shellback.(none) <>2007-09-22 12:17:14 +0200
commitd8fd59a42300122a3e4a04ae5db16e63d4b26df4 (patch)
treeb333fbd8340f4db733f6ca5b2206bc599af02379 /mysql-test/r/archive.result
parentb6708a9757e7e1f077ac88f0154ad29458d52815 (diff)
downloadmariadb-git-d8fd59a42300122a3e4a04ae5db16e63d4b26df4.tar.gz
Bug#30843 Bad Test addition to t/archive.test
Diffstat (limited to 'mysql-test/r/archive.result')
-rw-r--r--mysql-test/r/archive.result9
1 files changed, 4 insertions, 5 deletions
diff --git a/mysql-test/r/archive.result b/mysql-test/r/archive.result
index a1c11417bd0..a0b13b14b17 100644
--- a/mysql-test/r/archive.result
+++ b/mysql-test/r/archive.result
@@ -11123,8 +11123,8 @@ auto fld1 companynr fld3 fld4 fld5 fld6
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','');
+INSERT DELAYED INTO t2 VALUES (99999,011403,37,'the','delayed','insert','');
+INSERT INTO t2 VALUES (100000,000001,00,'after','delayed','insert','');
SELECT COUNT(auto) FROM t2;
COUNT(auto)
1215
@@ -11139,7 +11139,7 @@ t2 CREATE TABLE `t2` (
`fld4` char(35) NOT NULL default '',
`fld5` char(35) NOT NULL default ''
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-SELECT * from t2;
+SELECT * from t2 WHERE auto != 100000;
auto fld1 companynr fld3 fld4 fld5
1 000001 00 Omaha teethe neat
2 011401 37 breaking dreaded Steinberg
@@ -12354,8 +12354,7 @@ auto fld1 companynr fld3 fld4 fld5
2 011401 37 breaking dreaded Steinberg
3 011402 37 Romans scholastics jarring
4 011403 37 intercepted audiology tinily
-4 011403 37 intercepted audiology tinily
-5 000001 00 after delayed insert
+99999 011403 37 the delayed insert
drop table t1, t2, t4;
create table t1 (i int) engine=archive;
insert into t1 values (1);