:-) (CVS 1697)

FossilOrigin-Name: 5d773b5d4e9c23b81f53afd0cef7bd2300fff329

1 files changed, 7 insertions, 6 deletions

diff --git a/test/insert.test b/test/insert.test
index 45a642ed6..25988903d 100644
--- a/test/insert.test
+++ b/test/insert.test
@@ -23,7 +23,7 @@
 # This file implements regression tests for SQLite library.  The
 # focus of this file is testing the INSERT statement.
 #
-# $Id: insert.test,v 1.3 2000/06/03 18:06:53 drh Exp $
+# $Id: insert.test,v 1.4 2000/06/07 14:42:27 drh Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
@@ -126,12 +126,13 @@ do_test insert-2.3 {
 # on a table that has indices.  In particular we want to verify
 # that the correct default values are inserted into the indices.
 #
-execsql {DELETE FROM test2}
-execsql {CREATE INDEX index9 ON test2(f1,f2)}
-execsql {CREATE INDEX indext ON test2(f4,f5)}
-
 do_test insert-3.1 {
-  execsql {SELECT * from test2}
+  execsql {
+    DELETE FROM test2;
+    CREATE INDEX index9 ON test2(f1,f2);
+    CREATE INDEX indext ON test2(f4,f5);
+    SELECT * from test2;
+  }
 } {}
 do_test insert-3.2 {
   execsql {INSERT INTO test2(f2,f4) VALUES(-3.33,'hum')}