SQLite

Check-in [73b2606862]
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
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 73b260686264a31f43211efb235e4e0121115a50
User & Date: drh 2008-08-22 12:46:46.000
Context
2008-08-22
12:57
Fix nuisance compiler warnings. Ticket #3309. (CVS 5591) (check-in: 2a365e2994 user: drh tags: trunk)
12:46
Add test case to verify that Ticket #3301 was fixed by (5569) (CVS 5590) (check-in: 73b2606862 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: 7360e5d1f3 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to test/tkt3298.test. 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

# 2008 August 12
#
# The author disclaims copyright to this source code.  In place of
# a legal notice, here is a blessing:
#
#    May you do good and not evil.
#    May you find forgiveness for yourself and forgive others.
#    May you share freely, never taking more than you give.
#
#***********************************************************************
# 
# This file tests changes to the name resolution logic that occurred
# in august of 2008 and where associated with tickets #3298
#
# $Id: tkt3298.test,v 1.1 2008/08/22 12:30:52 drh Exp $

set testdir [file dirname $argv0]
source $testdir/tester.tcl

do_test tkt3298-1.1 {
  execsql {
    CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT);













|

|








1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

# 2008 August 12
#
# The author disclaims copyright to this source code.  In place of
# a legal notice, here is a blessing:
#
#    May you do good and not evil.
#    May you find forgiveness for yourself and forgive others.
#    May you share freely, never taking more than you give.
#
#***********************************************************************
# 
# This file tests changes to the name resolution logic that occurred
# in august of 2008 and where associated with tickets #3298 and #3301
#
# $Id: tkt3298.test,v 1.2 2008/08/22 12:46:46 drh Exp $

set testdir [file dirname $argv0]
source $testdir/tester.tcl

do_test tkt3298-1.1 {
  execsql {
    CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT);
︙︙
56
57
58
59
60
61
62













63
64
65

do_test tkt3298-1.5 {
  execsql {
    DELETE FROM v1 WHERE v1.x=2;
    SELECT * FROM v1 ORDER BY x;
  }
} {0 3}
















finish_test








>
>
>
>
>
>
>
>
>
>
>
>
>




56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78

do_test tkt3298-1.5 {
  execsql {
    DELETE FROM v1 WHERE v1.x=2;
    SELECT * FROM v1 ORDER BY x;
  }
} {0 3}

# Ticket #3301
#
do_test tkt3298-2.1 {
  execsql {
    CREATE TABLE t2(p,q);
    INSERT INTO t2 VALUES(1,11);
    INSERT INTO t2 VALUES(2,22);
    CREATE TABLE t3(x,y);
    INSERT INTO t3 VALUES(1,'one');

    SELECT *, (SELECT z FROM (SELECT y AS z FROM t3 WHERE x=t1.a+1) ) FROM t1;
  }
} {0 2 one}


finish_test