Remove the COPY command. (CVS 1477)

FossilOrigin-Name: 287f86731c71401dbac098e08357367b4f8e5a43

1 files changed, 7 insertions, 7 deletions

diff --git a/test/select3.test b/test/select3.test
index a1adb2d8f..0e9dc05b8 100644
--- a/test/select3.test
+++ b/test/select3.test
@@ -12,7 +12,7 @@
 # focus of this file is testing aggregate functions and the
 # GROUP BY and HAVING clauses of SELECT statements.
 #
-# $Id: select3.test,v 1.9 2004/05/21 02:14:25 drh Exp $
+# $Id: select3.test,v 1.10 2004/05/27 17:22:56 drh Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
@@ -20,17 +20,17 @@ source $testdir/tester.tcl
 # Build some test data
 #
 do_test select3-1.0 {
-  set fd [open data1.txt w]
+  execsql {
+    CREATE TABLE t1(n int, log int);
+    BEGIN;
+  }
   for {set i 1} {$i<32} {incr i} {
     for {set j 0} {pow(2,$j)<$i} {incr j} {}
-    puts $fd "$i\t$j"
+    execsql "INSERT INTO t1 VALUES($i,$j)"
   }
-  close $fd
   execsql {
-    CREATE TABLE t1(n int, log int);
-    COPY t1 FROM 'data1.txt'
+    COMMIT
   }
-  file delete data1.txt
   execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
 } {0 1 2 3 4 5}