/ File History
Login

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

History of test/with1.test

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