/ Check-in [edca8913]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:More efficient handling of the LIMIT clause. Scalar subqueries and EXISTS on compound SELECT statements now working properly. Ticket #1473. (CVS 2747)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: edca8913ca012fc0c17343a27f819de95147b1bd
User & Date: drh 2005-10-06 16:53:15
References
2010-04-15
14:43 Ticket [02a8e81d] LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly status still Open with 3 other changes artifact: c271e305 user: drh
Context
2005-10-10
00:05
Make the default TEMP_STORE=1 (TEMP tables stored on disk) in the configure script. (CVS 2748) check-in: 9753af53 user: drh tags: trunk
2005-10-06
16:53
More efficient handling of the LIMIT clause. Scalar subqueries and EXISTS on compound SELECT statements now working properly. Ticket #1473. (CVS 2747) check-in: edca8913 user: drh tags: trunk
13:59
Check-in (2744) as incomplete and broke pragma integrity_check. This completes the change and fixes the problem. (CVS 2746) check-in: 4862eaaf user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/expr.c.

Changes to src/select.c.

Changes to src/sqliteInt.h.

Changes to src/table.c.

Changes to src/vdbe.c.

Added test/tkt1473.test.

Changes to test/where.test.