Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add the example from #3359 to the test suite. (CVS 6027) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
84f8417c0794d3e5cec88f59ea71a7d5 |
| User & Date: | danielk1977 2008-12-14 14:45:21 |
Context
|
2008-12-15
| ||
| 15:27 | Convert the "~" and "NOT" operators to be two-address instructions. Ticket #3541. (CVS 6028) check-in: ea9b747e user: drh tags: trunk | |
|
2008-12-14
| ||
| 14:45 | Add the example from #3359 to the test suite. (CVS 6027) check-in: 84f8417c user: danielk1977 tags: trunk | |
| 02:55 | Fix the name of the source algorithm in the comments of the script generators for the recently checked-in test cases for integer boundary-value testing. (CVS 6026) check-in: adba0f3c user: drh tags: trunk | |
Changes
Changes to test/view.test.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
561
562
563
564
565
566
567
568
569
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this file is testing VIEW statements. # # $Id: view.test,v 1.38 2008/08/21 14:54:29 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Omit this entire file if the library is not configured with views enabled. ifcapable !view { finish_test return ................................................................................ execsql { CREATE VIEW v3308c AS SELECT t1.oid, A, t1.b+t1.c AS x FROM t1; } execsql2 { SELECT * FROM v3308c } } {rowid 1 a 1 x 5 rowid 2 a 4 x 11} finish_test |
|
>
>
>
>
>
>
>
>
>
>
|
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this file is testing VIEW statements. # # $Id: view.test,v 1.39 2008/12/14 14:45:21 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Omit this entire file if the library is not configured with views enabled. ifcapable !view { finish_test return ................................................................................ execsql { CREATE VIEW v3308c AS SELECT t1.oid, A, t1.b+t1.c AS x FROM t1; } execsql2 { SELECT * FROM v3308c } } {rowid 1 a 1 x 5 rowid 2 a 4 x 11} # Ticket #3539 had this crashing (see commit [5940]). do_test view-20.1 { execsql { DROP TABLE IF EXISTS t1; DROP VIEW IF EXISTS v1; CREATE TABLE t1(c1); CREATE VIEW v1 AS SELECT c1 FROM (SELECT t1.c1 FROM t1); } } {} finish_test |