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
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 |