Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/with1.test
|
2019-05-23
| ||
| 16:40 | Add test cases for the fix in the previous commit. file: [d3279208] check-in: [c1057b2a] user: dan branch: trunk, size: 29664 | |
|
2019-05-22
| ||
| 22:49 | Renumber the Select.selId values in the copies of SELECT statements that implement VIEWs when the VIEW is expanded, so that when the same VIEW is used twice in the same join, each expansion as a distinct selId. This fixes ticket [ce823231949d3abf42453c8]. file: [f8b59d18] check-in: [3cacc4b9] user: drh branch: trunk, size: 29063 | |
|
2019-02-06
| ||
| 00:55 | If the query flattener detects an error, cause the SELECT code generator to abort immediately. file: [a07b5aad] check-in: [3d3b142f] user: drh branch: trunk, size: 28134 | |
|
2019-01-17
| ||
| 15:40 | Revamp the SrcList allocator routines to be methods of Parse instead of being methods of the "sqlite3" object, so that they can leave better error messages when the SrcList object grows too large. file: [f1fcc3e3] check-in: [df08d472] user: drh branch: trunk, size: 28125 | |
| 14:34 | Limit the size of SrcList objects to 200 entries (compile-time configurable using -DSQLITE_MAX_SRCLIST=n). The maximum number of tables in a join has always been 64, so this is not a real constraint on capability. Limiting the size of a SrcList prevents DOS attacks (discovered by OSSFuzz) using crazy nexted CTE joins. file: [ff15177e] check-in: [7cac614d] user: drh branch: trunk, size: 28111 | |
|
2019-01-16
| ||
| 19:26 | Fix a problem in the code generator for sorting results with SRT_EphemTab and a LIMIT clause. file: [4776e8a5] check-in: [49fcde2f] user: drh branch: trunk, size: 27584 | |
|
2018-12-27
| ||
| 02:16 | Fix a problem in which nested CTEs with the same table name trick the code generator into thinking they are the same CTE, which then tries to use the manifest them both into the same transient table. file: [64fcb1a8] check-in: [202dd033] user: drh branch: trunk, size: 27339 | |
|
2018-09-27
| ||
| 12:14 | Disallow the use of window functions in the recursive part of a recursive CTE. Fix for ticket [e8275b415a2f03bee]. file: [2465d98f] check-in: [7fc29944] user: dan branch: trunk, size: 26670 | |
|
2018-05-03
| ||
| 01:37 | Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. file: [58475190] check-in: [c75eee69] user: drh branch: rework-EQP, size: 26038 | |
|
2018-05-02
| ||
| 18:00 | Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. file: [6b98f6f2] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 26012 | |
|
2017-10-28
| ||
| 12:20 | Add test cases from OSSFuzz to prevent a regression in co-routine processing. file: [ca08e291] check-in: [689743d8] user: drh branch: trunk, size: 25967 | |
|
2017-05-29
| ||
| 13:09 | Correctly initialize the iSelectId of FROM clause terms that are a self join of a reused materialized subquery. Without this, the EXPLAIN QUERY PLAN output for the query will identify the subquery using the uninitialized (and arbitrary) iSelectId. file: [732e3ef3] check-in: [43c9ae37] user: drh branch: trunk, size: 25541 | |
|
2015-12-14
| ||
| 19:42 | Add a missing memAboutToChange() macro to vdbe.c, the lack of which was causing an assert() to fail incorrectly. Problem found by libfuzzer. file: [cef099a4] check-in: [1a247911] user: dan branch: trunk, size: 25196 | |
|
2015-11-07
| ||
| 17:51 | Add test cases for WITH clauses. file: [05c8fc7f] check-in: [e7e65c75] user: dan branch: infinite-with-loop-bug, size: 24828 | |
|
2015-07-05
| ||
| 22:15 | Do not allow recursive CTEs that use aggregate queries in the recursive part. file: [a1e8660b] check-in: [6d2999af] user: drh branch: trunk, size: 22813 | |
|
2015-05-27
| ||
| 13:06 | CTEs have never had working rowids. So disallow the use of the "rowid" column within CTEs. file: [e99845d4] check-in: [0055df04] user: drh branch: no-rowid-in-cte, size: 22592 | |
|
2015-04-12
| ||
| 17:35 | Fix a problem with a stale Select.pWith pointer when a CTE is used together with a compound query and an ORDER BY clause. file: [a86bf7f9] check-in: [9a453f52] user: drh branch: trunk, size: 22374 | |
|
2015-03-21
| ||
| 03:18 | Correctly detect the error of having a "*" wildcard on a SELECT without a FROM clause on the left-hand side of a recursive CTE. file: [9df5cd8a] check-in: [b11d1793] user: drh branch: trunk, size: 22248 | |
|
2014-02-09
| ||
| 18:02 | Use the WITH clause to help resolve names for SELECT statements on the left of a compound query. Proposed fix for ticket [31a19d11b97088296a]. file: [268081a6] check-in: [67bfd59d] user: drh branch: trunk, size: 21709 | |
|
2014-01-24
| ||
| 20:37 | Select collation sequences for ORDER BY expressions attached to recursive CTEs in the same way as they are selected for other compound SELECT statements. file: [ce15d69d] check-in: [9554519c] user: dan branch: trunk, size: 21249 | |
| 16:57 | Add test cases for LIMIT and ORDER BY on recursive CTEs. file: [6c9c27b7] check-in: [67d6c42d] user: dan branch: trunk, size: 19019 | |
| 11:16 | Add test cases showing the use of ORDER BY on a recursive query to control depth-first versus breath-first search of a tree. file: [9d353737] check-in: [83b0b291] user: drh branch: trunk, size: 15817 | |
|
2014-01-22
| ||
| 18:07 | Add support for LIMIT and OFFSET in a recursive query. file: [97166cc7] check-in: [1945484e] user: drh branch: cte-via-queue, size: 12696 | |
| 17:28 | Get ORDER BY working for recursive queries. file: [f4aa699a] check-in: [37b343b0] user: drh branch: cte-via-queue, size: 12443 | |
|
2014-01-18
| ||
| 18:33 | Add a sudoku solver to the recursive query tests in with1.test. file: [cec63b56] check-in: [679eff87] user: drh branch: trunk, size: 11305 | |
| 15:22 | Add asserts() for a couple of unreachable conditions. Add the Mandelbrot Set query as a test case. file: [be21f7ef] check-in: [2ad4583c] user: drh branch: trunk, size: 10112 | |
|
2014-01-17
| ||
| 18:34 | Minor simplification of error message text for a couple of errors associated with WITH clause processing. file: [6e49c784] check-in: [2031004d] user: drh branch: trunk, size: 8351 | |
|
2014-01-16
| ||
| 21:59 | Tweaks to error message text. file: [90490c75] check-in: [090a77d9] user: drh branch: common-table-expr, size: 8381 | |
| 21:02 | Improve the error messages used to report illegal recursive cte references. file: [f1602892] check-in: [54eee9fe] user: dan branch: common-table-expr, size: 8432 | |
|
2014-01-15
| ||
| 19:42 | Fixes so that SQLITE_OMIT_CTE builds work. file: [8ac68051] check-in: [3908e2ea] user: dan branch: common-table-expr, size: 7162 | |
| 18:21 | Disable automatic indices on recursive CTE references. file: [fcd45b01] check-in: [28aa6db8] user: dan branch: common-table-expr, size: 7117 | |
| 18:12 | When resolving names, consider a reference to a recursive CTE column as equivalent to a reference to the outermost name-context. This ensures that correlated sub-queries are correctly identified as such. file: [951807f7] check-in: [61be2da0] user: dan branch: common-table-expr, size: 7120 | |
| 15:27 | Return an error if a CTE specifies a different number of columns than its SELECT statement returns. file: [babb3d9c] check-in: [9a514b50] user: dan branch: common-table-expr, size: 6760 | |
| 14:17 | Disable the flattening optimization if the sub-query is a recursive CTE. file: [77739a9e] check-in: [9472f6d8] user: dan branch: common-table-expr, size: 5676 | |
|
2014-01-14
| ||
| 20:14 | Add code to handle recursive CTEs. file: [12a6661e] check-in: [a5c2a54a] user: dan branch: common-table-expr, size: 4362 | |
|
2014-01-13
| ||
| 15:12 | Add code to handle non-recursive CTEs in the same way as SQL views. file: [fb8409a3] check-in: [a26f399b] user: dan branch: common-table-expr, size: 3525 | |
|
2014-01-11
| ||
| 19:19 | Update the parser so that sub-queries and CTEs may have WITH clauses. file: [e8146198] check-in: [704d3931] user: dan branch: common-table-expr, size: 1036 Added | |