Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Additional tests of flattening (CVS 413) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | e1d93c5923195507642d882fff8cd85c454f69ee |
| User & Date: | drh 2002-03-03 03:11:15 |
Context
|
2002-03-03
| ||
| 03:42 | Fix a memory leak in expression processing. (CVS 414) check-in: dfe431c9 user: drh tags: trunk | |
| 03:11 | Additional tests of flattening (CVS 413) check-in: e1d93c59 user: drh tags: trunk | |
| 03:03 | Suppress superfluous OP_OpenTemps when flattening subqueries. (CVS 412) check-in: 000441c8 user: drh tags: trunk | |
Changes
Changes to test/select6.test.
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
...
270
271
272
273
274
275
276
277
278
|
# 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 SELECT statements that contain # subqueries in their FROM clause. # # $Id: select6.test,v 1.4 2002/03/03 03:03:54 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl do_test select6-1.0 { execsql { BEGIN; ................................................................................ } {2.5} do_test select6-4.5 { execsql { SELECT avg(y) FROM (SELECT DISTINCT y FROM t1 WHERE y<5) ORDER BY y } } {2.5} finish_test |
|
>
>
>
>
>
>
>
|
>
>
|
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
...
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
|
# 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 SELECT statements that contain # subqueries in their FROM clause. # # $Id: select6.test,v 1.5 2002/03/03 03:11:15 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl do_test select6-1.0 { execsql { BEGIN; ................................................................................ } {2.5} do_test select6-4.5 { execsql { SELECT avg(y) FROM (SELECT DISTINCT y FROM t1 WHERE y<5) ORDER BY y } } {2.5} do_test select6-5.1 { execsql { SELECT a,x,b FROM (SELECT x+3 AS 'a', x FROM t1 WHERE y=3) AS 'p', (SELECT x AS 'b' FROM t1 WHERE y=4) AS 'q' WHERE a=b ORDER BY a } } {8 5 8 9 6 9 10 7 10} finish_test |