Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Tests for the subquery flattening fix of check-in (2987). (CVS 2988) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
72a067f0df5818c0fdb3b9f8af20f83b |
User & Date: | drh 2006-01-22 00:14:39.000 |
Context
2006-01-22
| ||
00:42 | Code size reductions in select.c. (CVS 2989) (check-in: 3c2eee5e1f user: drh tags: trunk) | |
00:14 | Tests for the subquery flattening fix of check-in (2987). (CVS 2988) (check-in: 72a067f0df user: drh tags: trunk) | |
2006-01-21
| ||
22:19 | Do not flatten subqueries in a join where the subquery includes a LIMIT. Ticket #1634. This is just an initial fix. Many test cases need to be added prior to closing the ticket. (CVS 2987) (check-in: af18c0f431 user: drh tags: trunk) | |
Changes
Changes to test/select6.test.
︙ | ︙ | |||
8 9 10 11 12 13 14 | # 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. # | | | 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | # 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.22 2006/01/22 00:14:39 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Omit this whole file if the library is build without subquery support. ifcapable !subquery { finish_test |
︙ | ︙ | |||
449 450 451 452 453 454 455 456 | (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n WHERE y=p) AS e, (SELECT r AS z FROM t4 WHERE q=11) AS f WHERE e.r=f.z } } {1} } ;# ifcapable view | > | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 | (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n WHERE y=p) AS e, (SELECT r AS z FROM t4 WHERE q=11) AS f WHERE e.r=f.z } } {1} } ;# ifcapable view # Ticket #1634 # do_test select6-9.1 { execsql { SELECT a.x, b.x FROM t1 AS a, (SELECT x FROM t1 LIMIT 2) AS b } } {1 1 1 2 2 1 2 2 3 1 3 2 4 1 4 2} do_test select6-9.2 { execsql { SELECT x FROM (SELECT x FROM t1 LIMIT 2); } } {1 2} do_test select6-9.3 { execsql { SELECT x FROM (SELECT x FROM t1 LIMIT 2 OFFSET 1); } } {2 3} do_test select6-9.4 { execsql { SELECT x FROM (SELECT x FROM t1) LIMIT 2; } } {1 2} do_test select6-9.5 { execsql { SELECT x FROM (SELECT x FROM t1) LIMIT 2 OFFSET 1; } } {2 3} do_test select6-9.6 { execsql { SELECT x FROM (SELECT x FROM t1 LIMIT 2) LIMIT 3; } } {1 2} do_test select6-9.7 { execsql { SELECT x FROM (SELECT x FROM t1 LIMIT -1) LIMIT 3; } } {1 2 3} do_test select6-9.8 { execsql { SELECT x FROM (SELECT x FROM t1 LIMIT -1); } } {1 2 3 4} do_test select6-9.9 { execsql { SELECT x FROM (SELECT x FROM t1 LIMIT -1 OFFSET 1); } } {2 3 4} finish_test |