From 1691cd4bc0c949351d82da415d84cde2156b4e31 Mon Sep 17 00:00:00 2001
From: drh <drh@noemail.net>
Date: Tue, 28 Apr 2009 04:51:29 +0000
Subject: [PATCH] Add test cases for sqlite3_complete with an EXPLAIN QUERY
 PLAN on a CREATE TRIGGER statement.  Ticket #3828. (CVS 6553)

FossilOrigin-Name: 6b86b40edadb9c9cbc0db5a43a8277434f9d7171
---
 manifest       | 12 ++++++------
 manifest.uuid  |  2 +-
 test/main.test | 12 +++++++++++-
 3 files changed, 18 insertions(+), 8 deletions(-)

diff --git a/manifest b/manifest
index f36eeecafb..37d23a85d7 100644
--- a/manifest
+++ b/manifest
@@ -1,5 +1,5 @@
-C Make\ssure\ssqlite3_open16()\salways\szeros\sthe\sdb\sreturn\spointer\sif\nSQLite\sinitialization\sfails.\s(CVS\s6552)
-D 2009-04-28T04:47:31
+C Add\stest\scases\sfor\ssqlite3_complete\swith\san\sEXPLAIN\sQUERY\sPLAN\son\sa\nCREATE\sTRIGGER\sstatement.\s\sTicket\s#3828.\s(CVS\s6553)
+D 2009-04-28T04:51:29
 F Makefile.arm-wince-mingw32ce-gcc fcd5e9cd67fe88836360bb4f9ef4cb7f8e2fb5a0
 F Makefile.in 583e87706abc3026960ed759aff6371faf84c211
 F Makefile.linux-gcc d53183f4aa6a9192d249731c90dbdffbd2c68654
@@ -442,7 +442,7 @@ F test/lock4.test 991b57669a868bbfd39fe0c0df0d493985829105
 F test/lock5.test 6b1f78f09ad1522843dad571b76b321e6f439bf7
 F test/lock6.test 862aa71e97b288d6b3f92ba3313f51bd0b003776
 F test/lookaside.test 1dd350dc6dff015c47c07fcc5a727a72fc5bae02
-F test/main.test 9b048ee1d2fdbc0a232b87b236d64e9ff7b68e68
+F test/main.test 347ab987f16167858781383427476b33dc69fdb7
 F test/make-where7.tcl 05c16b5d4f5d6512881dfec560cb793915932ef9
 F test/malloc.test cd2b9f515ba98beb5e335acdd94c3ad7a6f7fc4a
 F test/malloc3.test 4bc57f850b212f706f3e1b37c4eced1d5a727cd1
@@ -725,7 +725,7 @@ F tool/speedtest16.c c8a9c793df96db7e4933f0852abb7a03d48f2e81
 F tool/speedtest2.tcl ee2149167303ba8e95af97873c575c3e0fab58ff
 F tool/speedtest8.c 2902c46588c40b55661e471d7a86e4dd71a18224
 F tool/speedtest8inst1.c 293327bc76823f473684d589a8160bde1f52c14e
-P 3ac1b15f552fe005630e43a92fffa6a4abd6675d
-R ce7ad2cfeceaae4924fa46a2e9663c12
+P 057c7d171397e19c8f3ac2362ea45f2b4a50530c
+R e9cf7dcfedeb1269850001610142cf1c
 U drh
-Z fff0fc60f9b3711ffd15eacee148c143
+Z 6cc8d771e93fc6aa7c555d8857beb7c3
diff --git a/manifest.uuid b/manifest.uuid
index 509e3d8ef5..a4f0dbc910 100644
--- a/manifest.uuid
+++ b/manifest.uuid
@@ -1 +1 @@
-057c7d171397e19c8f3ac2362ea45f2b4a50530c
\ No newline at end of file
+6b86b40edadb9c9cbc0db5a43a8277434f9d7171
\ No newline at end of file
diff --git a/test/main.test b/test/main.test
index 44268ca7bb..12262c1c51 100644
--- a/test/main.test
+++ b/test/main.test
@@ -11,7 +11,7 @@
 # This file implements regression tests for SQLite library.  The
 # focus of this file is exercising the code in main.c.
 #
-# $Id: main.test,v 1.31 2009/04/25 08:39:15 danielk1977 Exp $
+# $Id: main.test,v 1.32 2009/04/28 04:51:29 drh Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
@@ -85,6 +85,16 @@ ifcapable {trigger} {
       CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr;
     }
   } {0}
+  do_test main-1.17.2 {
+    db complete {
+      EXPLAIN CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr;
+    }
+  } {0}
+  do_test main-1.17.3 {
+    db complete {
+      EXPLAIN QUERY PLAN CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr;
+    }
+  } {0}
   do_test main-1.18 {
     db complete {
       CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr; END;
-- 
2.47.2