/ 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 Unified Diffs Show Whitespace Changes Patch

Changes to test/tkt3298.test.

6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
..
56
57
58
59
60
61
62













63
64
65
#    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);
................................................................................
do_test tkt3298-1.5 {
  execsql {
    DELETE FROM v1 WHERE v1.x=2;
    SELECT * FROM v1 ORDER BY x;
  }
} {0 3}
















finish_test







|

|







 







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



6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
..
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
#    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);
................................................................................
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