/ Check-in [e36e59f0]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Remove debugging code that was accidently left in join4.test. (CVS 1819)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: e36e59f02eec166ef2c4e0991c97ceb536e3c3f3
User & Date: drh 2004-07-19 19:28:44
Context
2004-07-19
22:08
The OsFile under Unix records a pointer back to the pager. This is intended to be used for an externalized locking patch. (CVS 1821) check-in: 511ee639 user: drh tags: trunk
19:28
Remove debugging code that was accidently left in join4.test. (CVS 1819) check-in: e36e59f0 user: drh tags: trunk
19:14
Fix for ticket #813. (CVS 1818) check-in: 88e4bfa1 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/join4.test.

     9      9   #
    10     10   #***********************************************************************
    11     11   # This file implements regression tests for SQLite library.
    12     12   #
    13     13   # This file implements tests for left outer joins containing WHERE
    14     14   # clauses that restrict the scope of the left term of the join.
    15     15   #
    16         -# $Id: join4.test,v 1.1 2004/07/19 19:14:01 drh Exp $
           16  +# $Id: join4.test,v 1.2 2004/07/19 19:28:44 drh Exp $
    17     17   
    18     18   set testdir [file dirname $argv0]
    19     19   source $testdir/tester.tcl
    20     20   
    21     21   do_test join4-1.1 {
    22     22     execsql {
    23     23       create temp table t1(a integer, b varchar(10));
................................................................................
    39     39       select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
    40     40     }
    41     41   } {1 one {} {} {} 2 two 2 niban ok 3 three {} {} {} 4 four {} {} {}}
    42     42   do_test join4-1.3 {
    43     43     execsql {
    44     44       create index i2 on t2(z);
    45     45     }
    46         -btree_breakpoint
    47     46     execsql {
    48     47       select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
    49     48     }
    50     49   } {2 two 2 niban ok}
    51     50   do_test join4-1.4 {
    52     51     execsql {
    53     52       select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'