From 1c84ac596d34deec5f312fefc49ecaf12a771f2e Mon Sep 17 00:00:00 2001
From: danielk1977 <danielk1977@noemail.net>
Date: Tue, 23 Jun 2009 11:53:09 +0000
Subject: [PATCH] Add a test to verify that #3929 is fixed. (CVS 6801)

FossilOrigin-Name: 16c1ae9bde895d39c4eaababbd1dbf9e3b9cb653
---
 manifest          | 11 ++++++-----
 manifest.uuid     |  2 +-
 test/tkt3929.test | 49 +++++++++++++++++++++++++++++++++++++++++++++++
 3 files changed, 56 insertions(+), 6 deletions(-)
 create mode 100644 test/tkt3929.test

diff --git a/manifest b/manifest
index e872387769..c81e7be617 100644
--- a/manifest
+++ b/manifest
@@ -1,5 +1,5 @@
-C Fix\sa\sfailing\sassert\sin\sbtree.c.\sThe\ssame\sbug\swas\scausing\sa\sspurious\sSQLITE_CORRUPT\sreturn\swhen\scompiled\swithout\sSQLITE_DEBUG.\s(CVS\s6800)
-D 2009-06-23T11:22:29
+C Add\sa\stest\sto\sverify\sthat\s#3929\sis\sfixed.\s(CVS\s6801)
+D 2009-06-23T11:53:09
 F Makefile.arm-wince-mingw32ce-gcc fcd5e9cd67fe88836360bb4f9ef4cb7f8e2fb5a0
 F Makefile.in 8b8fb7823264331210cddf103831816c286ba446
 F Makefile.linux-gcc d53183f4aa6a9192d249731c90dbdffbd2c68654
@@ -655,6 +655,7 @@ F test/tkt3879.test 2ad5bef2c87e9991ce941e054c31abe26ef7fb90
 F test/tkt3911.test 74cd324f3ba653040cc6d94cc4857b290d12d633
 F test/tkt3918.test e6cdf6bfcfe9ba939d86a4238a9dc55d6eec5d42
 F test/tkt3922.test 0b43815bff3b6ab889bf84a17668ee13ab046bfd
+F test/tkt3929.test 6a4c3baefb4e75127356b7d675b5df42c35c00d1
 F test/tokenize.test ce430a7aed48fc98301611429595883fdfcab5d7
 F test/trace.test 19ffbc09885c3321d56358a5738feae8587fb377
 F test/trans.test d887cb07630dc39879a322d958ad8b006137485c
@@ -736,7 +737,7 @@ F tool/speedtest2.tcl ee2149167303ba8e95af97873c575c3e0fab58ff
 F tool/speedtest8.c 2902c46588c40b55661e471d7a86e4dd71a18224
 F tool/speedtest8inst1.c 293327bc76823f473684d589a8160bde1f52c14e
 F tool/vdbe-compress.tcl 672f81d693a03f80f5ae60bfefacd8a349e76746
-P 308f2e61520ac7440700d93ca5bab4a844f2dc17
-R 7eff69d5d72039b2344cb3f983e57232
+P 47ec8749470af7cab9f3ef15effce1a7ba79a654
+R a22ed399ab7c6f7eec8f95fb89f627c5
 U danielk1977
-Z 7b119a6733548bd536b90af0bcc1bc8a
+Z 77f7ae75a7f49b6f7f31cd38f6e68f1d
diff --git a/manifest.uuid b/manifest.uuid
index 06ad1babc9..4e7ed8922f 100644
--- a/manifest.uuid
+++ b/manifest.uuid
@@ -1 +1 @@
-47ec8749470af7cab9f3ef15effce1a7ba79a654
\ No newline at end of file
+16c1ae9bde895d39c4eaababbd1dbf9e3b9cb653
\ No newline at end of file
diff --git a/test/tkt3929.test b/test/tkt3929.test
new file mode 100644
index 0000000000..47e13bfd52
--- /dev/null
+++ b/test/tkt3929.test
@@ -0,0 +1,49 @@
+# 2009 June 23
+#
+# The author disclaims copyright to this source code.  In place of
+# a legal notice, here is a blessing:
+#
+#    May you do good and not evil.
+#    May you find forgiveness for yourself and forgive others.
+#    May you share freely, never taking more than you give.
+#
+#***********************************************************************
+#
+# Tests to verify ticket #3929 is fixed.
+#
+# $Id: tkt3929.test,v 1.1 2009/06/23 11:53:09 danielk1977 Exp $
+
+set testdir [file dirname $argv0]
+source $testdir/tester.tcl
+
+do_test tkt3929-1.0 {
+  execsql {
+    PRAGMA page_size = 1024;
+    CREATE TABLE t1(a, b);
+    CREATE INDEX i1 ON t1(a, b);
+    CREATE TRIGGER t1_t1 AFTER INSERT ON t1 BEGIN
+      UPDATE t1 SET b = 'value: ' || a WHERE t1.rowid = new.rowid;
+    END;
+  }
+} {}
+
+do_test tkt3929-1.1 {
+  execsql {
+    INSERT INTO t1(a) VALUES(1);
+    INSERT INTO t1(a) VALUES(2);
+    SELECT * FROM t1;
+  }
+} {1 {value: 1} 2 {value: 2}}
+
+# Before it was fixed, the following provoked the bug, causing either an
+# assertion failure or a "database is malformed" error.
+#
+do_test tkt3930-1.2 {
+  for {set i 3} {$i < 100} {incr i} {
+    execsql { INSERT INTO t1(a) VALUES($i) }
+  }
+} {}
+
+integrity_check tkt3930-1.3
+finish_test
+
-- 
2.47.3