Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix multiple issues with the ORDER BY LIMIT optimization. This is the proposed resolution to ticket [9936b2fa443fec03ff25]. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
206720129ed2fa8875a286266d05b99f |
| User & Date: | drh 2018-09-08 20:09:46.990 |
References
|
2018-09-17
| ||
| 15:25 | Disable the ORDER BY LIMIT optimization in queries using window functions. This fixes a problem that was introduced by check-in [206720129ed2fa8875a286] which attempted to fix ticket [9936b2fa443fec03ff25f9]. This changes is a fix for the follow-in tocket [510cde277783b5fb5de628]. (check-in: 36c75fd5b7 user: drh tags: branch-3.25) | |
| 15:19 | Disable the ORDER BY LIMIT optimization in queries using window functions. This fixes a problem that was introduced by check-in [206720129ed2fa8875a286] which attempted to fix ticket [9936b2fa443fec03ff25f9]. This changes is a fix for the follow-in tocket [510cde277783b5fb5de628]. (check-in: c6c9585f29 user: drh tags: trunk) | |
| 14:28 | • New ticket [510cde2777] Endless loop on a query with window functions, ORDER BY, and LIMIT. (artifact: 614870a83e user: drh) | |
Context
|
2018-09-08
| ||
| 20:29 | Fix an unreachable branch in the new sqlite3WhereOrderByLimitOptLabel() function of the query planner. (check-in: 5a954533ed user: drh tags: trunk) | |
| 20:09 | Fix multiple issues with the ORDER BY LIMIT optimization. This is the proposed resolution to ticket [9936b2fa443fec03ff25]. (check-in: 206720129e user: drh tags: trunk) | |
| 16:55 | Add a missing call to free() in Lemon. (check-in: 8b4cf33aaf user: mistachkin tags: trunk) | |
Changes
Changes to src/select.c.
Changes to src/sqliteInt.h.
Changes to src/where.c.
Changes to test/limit2.test.