diff options
| author | drh <drh@noemail.net> | 2004-05-27 17:22:54 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2004-05-27 17:22:54 +0000 |
| commit | 5f3b4ab53c209ffed8682563e8de31c3a5411f59 (patch) | |
| tree | a751f75060c8ef60f8f5bebcdf74117224f472cf /test/in.test | |
| parent | 6d88bad4f9c200e532f5fd33d14f43391647460a (diff) | |
| download | sqlite-5f3b4ab53c209ffed8682563e8de31c3a5411f59.tar.gz sqlite-5f3b4ab53c209ffed8682563e8de31c3a5411f59.zip | |
Remove the COPY command. (CVS 1477)
FossilOrigin-Name: 287f86731c71401dbac098e08357367b4f8e5a43
Diffstat (limited to 'test/in.test')
| -rw-r--r-- | test/in.test | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/test/in.test b/test/in.test index 9fb8adf0e..c717a90b4 100644 --- a/test/in.test +++ b/test/in.test @@ -11,7 +11,7 @@ # This file implements regression tests for SQLite library. The # focus of this file is testing the IN and BETWEEN operator. # -# $Id: in.test,v 1.11 2004/01/15 03:30:25 drh Exp $ +# $Id: in.test,v 1.12 2004/05/27 17:22:56 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl @@ -19,17 +19,17 @@ source $testdir/tester.tcl # Generate the test data we will need for the first squences of tests. # do_test in-1.0 { - set fd [open data1.txt w] + execsql { + BEGIN; + CREATE TABLE t1(a int, b int); + } for {set i 1} {$i<=10} {incr i} { - puts $fd "$i\t[expr {int(pow(2,$i))}]" + execsql "INSERT INTO t1 VALUES($i,[expr {int(pow(2,$i))}])" } - close $fd execsql { - CREATE TABLE t1(a int, b int); - COPY t1 FROM 'data1.txt'; + COMMIT; + SELECT count(*) FROM t1; } - file delete -force data1.txt - execsql {SELECT count(*) FROM t1} } {10} # Do basic testing of BETWEEN. |