/ Check-in [73b26068]
Login

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

Overview
Comment:Add test case to verify that Ticket #3301 was fixed by (5569) (CVS 5590)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 73b260686264a31f43211efb235e4e0121115a50
User & Date: drh 2008-08-22 12:46:46
Context
2008-08-22
12:57
Fix nuisance compiler warnings. Ticket #3309. (CVS 5591) check-in: 2a365e29 user: drh tags: trunk
12:46
Add test case to verify that Ticket #3301 was fixed by (5569) (CVS 5590) check-in: 73b26068 user: drh tags: trunk
12:30
Allow the WHERE clause in an UPDATE or DELETE against a view with an INSTEAD OF trigger to refer to the view by name. Ticket #3298. (CVS 5589) check-in: 7360e5d1 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/tkt3298.test.

     6      6   #    May you do good and not evil.
     7      7   #    May you find forgiveness for yourself and forgive others.
     8      8   #    May you share freely, never taking more than you give.
     9      9   #
    10     10   #***********************************************************************
    11     11   # 
    12     12   # This file tests changes to the name resolution logic that occurred
    13         -# in august of 2008 and where associated with tickets #3298
           13  +# in august of 2008 and where associated with tickets #3298 and #3301
    14     14   #
    15         -# $Id: tkt3298.test,v 1.1 2008/08/22 12:30:52 drh Exp $
           15  +# $Id: tkt3298.test,v 1.2 2008/08/22 12:46:46 drh Exp $
    16     16   
    17     17   set testdir [file dirname $argv0]
    18     18   source $testdir/tester.tcl
    19     19   
    20     20   do_test tkt3298-1.1 {
    21     21     execsql {
    22     22       CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT);
................................................................................
    56     56   do_test tkt3298-1.5 {
    57     57     execsql {
    58     58       DELETE FROM v1 WHERE v1.x=2;
    59     59       SELECT * FROM v1 ORDER BY x;
    60     60     }
    61     61   } {0 3}
    62     62   
           63  +# Ticket #3301
           64  +#
           65  +do_test tkt3298-2.1 {
           66  +  execsql {
           67  +    CREATE TABLE t2(p,q);
           68  +    INSERT INTO t2 VALUES(1,11);
           69  +    INSERT INTO t2 VALUES(2,22);
           70  +    CREATE TABLE t3(x,y);
           71  +    INSERT INTO t3 VALUES(1,'one');
           72  +
           73  +    SELECT *, (SELECT z FROM (SELECT y AS z FROM t3 WHERE x=t1.a+1) ) FROM t1;
           74  +  }
           75  +} {0 2 one}
    63     76   
    64     77   
    65     78   finish_test