Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/with1.test
2025-04-10
| ||
10:18 | [1ee171d7c3] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 32599) | |
2023-02-15
| ||
17:53 | [b93833890e] part of check-in [5dec3cc022] Do not compute result columns of subqueries that are never used. Make those columns NULL instead. This optimization potentially resolves the enhancement request described by [ticket baa5bb76c35a124c]. (check-in: [5dec3cc022] user: drh branch: omit-unused-subquery-columns, size: 32603) | |
2022-04-22
| ||
16:15 | [9ad67fdeb2] part of check-in [8d631a6b9e] Honor the MATERIALIZED keyword on a common table expression by not flattening the CTE into an outer query. (check-in: [8d631a6b9e] user: drh branch: trunk, size: 32583) | |
2021-05-20
| ||
18:11 | [7bc5abfe4c] part of check-in [179dcb6ba7] Enhance one test case to use various alternative definitions of DUAL. (check-in: [179dcb6ba7] user: drh branch: trunk, size: 32515) | |
00:44 | [8a4f82b104] part of check-in [5614279daf] Replace [0f0959c6f95046e8] with a new and better solution that also fixes the CTE name resolution problem described in forum post 8590e3f6dc. Test cases for both problems added. (check-in: [5614279daf] user: drh branch: trunk, size: 32316) | |
2021-03-20
| ||
15:11 | [b231edbf0f] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 31660) | |
2020-10-19
| ||
01:23 | [780be387f0] part of check-in [5481fa8c79] Allow multiple recursive terms in the compound SELECT of a recursive CTE. This facilitates writing a query to find find the connected components of an undirected graph. (check-in: [5481fa8c79] user: drh branch: cte-enhancement, size: 31690) | |
2020-09-17
| ||
00:46 | [323659eaf3] part of check-in [7d2b590d3a] DISTINCT may not be ignored inside a UNION ALL common table expression. Fix for ticket [c51489c3b8f919c5] (check-in: [7d2b590d3a] user: drh branch: trunk, size: 31705) | |
2020-01-21
| ||
14:42 | [584580a5ae] part of check-in [c7e29458a7] Fix an assert() that could fail in SQLITE_MUTATION_TEST builds following an error in a query that uses CTEs. (check-in: [c7e29458a7] user: dan branch: trunk, size: 30648) | |
2020-01-03
| ||
02:20 | [386d1c1763] part of check-in [ff9492d3ff] When generating the name of a view (or common table expression) because the SQL does not specify a name, avoid the names "true" and "false" which might be confused for the boolean literals of the same name, leading to an inconsistent abstract syntax tree. (check-in: [ff9492d3ff] user: drh branch: trunk, size: 30456) | |
2019-05-23
| ||
16:40 | [d32792084d] part of check-in [c1057b2a60] Add test cases for the fix in the previous commit. (check-in: [c1057b2a60] user: dan branch: trunk, size: 29664) | |
2019-05-22
| ||
22:49 | [f8b59d186a] part of check-in [3cacc4b940] 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]. (check-in: [3cacc4b940] user: drh branch: trunk, size: 29063) | |
2019-02-06
| ||
00:55 | [a07b5aad7f] part of check-in [3d3b142f10] If the query flattener detects an error, cause the SELECT code generator to abort immediately. (check-in: [3d3b142f10] user: drh branch: trunk, size: 28134) | |
2019-01-17
| ||
15:40 | [f1fcc3e35e] part of check-in [df08d472b0] 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. (check-in: [df08d472b0] user: drh branch: trunk, size: 28125) | |
14:34 | [ff15177e0e] part of check-in [7cac614d5d] 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. (check-in: [7cac614d5d] user: drh branch: trunk, size: 28111) | |
2019-01-16
| ||
19:26 | [4776e8a577] part of check-in [49fcde2f1f] Fix a problem in the code generator for sorting results with SRT_EphemTab and a LIMIT clause. (check-in: [49fcde2f1f] user: drh branch: trunk, size: 27584) | |
2018-12-27
| ||
02:16 | [64fcb1a816] part of check-in [202dd03301] 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. (check-in: [202dd03301] user: drh branch: trunk, size: 27339) | |
2018-09-27
| ||
12:14 | [2465d98ffc] part of check-in [7fc2994434] Disallow the use of window functions in the recursive part of a recursive CTE. Fix for ticket [e8275b415a2f03bee]. (check-in: [7fc2994434] user: dan branch: trunk, size: 26670) | |
2018-05-03
| ||
01:37 | [58475190cd] part of check-in [c75eee69fa] Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. (check-in: [c75eee69fa] user: drh branch: rework-EQP, size: 26038) | |
2018-05-02
| ||
18:00 | [6b98f6f2ad] part of check-in [5f0e803e33] 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. (check-in: [5f0e803e33] user: drh branch: rework-EQP, size: 26012) | |
2017-10-28
| ||
12:20 | [ca08e29124] part of check-in [689743d8e3] Add test cases from OSSFuzz to prevent a regression in co-routine processing. (check-in: [689743d8e3] user: drh branch: trunk, size: 25967) | |
2017-05-29
| ||
13:09 | [732e3ef398] part of check-in [43c9ae371f] 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. (check-in: [43c9ae371f] user: drh branch: trunk, size: 25541) | |
2015-12-14
| ||
19:42 | [cef099a491] part of check-in [1a24791109] Add a missing memAboutToChange() macro to vdbe.c, the lack of which was causing an assert() to fail incorrectly. Problem found by libfuzzer. (check-in: [1a24791109] user: dan branch: trunk, size: 25196) | |
2015-11-07
| ||
17:51 | [05c8fc7f80] part of check-in [e7e65c7559] Add test cases for WITH clauses. (check-in: [e7e65c7559] user: dan branch: infinite-with-loop-bug, size: 24828) | |
2015-07-05
| ||
22:15 | [a1e8660be8] part of check-in [6d2999afbc] Do not allow recursive CTEs that use aggregate queries in the recursive part. (check-in: [6d2999afbc] user: drh branch: trunk, size: 22813) | |
2015-05-27
| ||
13:06 | [e99845d4f4] part of check-in [0055df0445] CTEs have never had working rowids. So disallow the use of the "rowid" column within CTEs. (check-in: [0055df0445] user: drh branch: no-rowid-in-cte, size: 22592) | |
2015-04-12
| ||
17:35 | [a86bf7f928] part of check-in [9a453f52a2] Fix a problem with a stale Select.pWith pointer when a CTE is used together with a compound query and an ORDER BY clause. (check-in: [9a453f52a2] user: drh branch: trunk, size: 22374) | |
2015-03-21
| ||
03:18 | [9df5cd8a62] part of check-in [b11d1793a0] Correctly detect the error of having a "*" wildcard on a SELECT without a FROM clause on the left-hand side of a recursive CTE. (check-in: [b11d1793a0] user: drh branch: trunk, size: 22248) | |
2014-02-09
| ||
18:02 | [268081a6b1] part of check-in [67bfd59d90] Use the WITH clause to help resolve names for SELECT statements on the left of a compound query. Proposed fix for ticket [31a19d11b97088296a]. (check-in: [67bfd59d90] user: drh branch: trunk, size: 21709) | |
2014-01-24
| ||
20:37 | [ce15d69d34] part of check-in [9554519c12] Select collation sequences for ORDER BY expressions attached to recursive CTEs in the same way as they are selected for other compound SELECT statements. (check-in: [9554519c12] user: dan branch: trunk, size: 21249) | |
16:57 | [6c9c27b76e] part of check-in [67d6c42d44] Add test cases for LIMIT and ORDER BY on recursive CTEs. (check-in: [67d6c42d44] user: dan branch: trunk, size: 19019) | |
11:16 | [9d3537372c] part of check-in [83b0b29165] Add test cases showing the use of ORDER BY on a recursive query to control depth-first versus breath-first search of a tree. (check-in: [83b0b29165] user: drh branch: trunk, size: 15817) | |
2014-01-22
| ||
18:07 | [97166cc72d] part of check-in [1945484e6b] Add support for LIMIT and OFFSET in a recursive query. (check-in: [1945484e6b] user: drh branch: cte-via-queue, size: 12696) | |
17:28 | [f4aa699a37] part of check-in [37b343b018] Get ORDER BY working for recursive queries. (check-in: [37b343b018] user: drh branch: cte-via-queue, size: 12443) | |
2014-01-18
| ||
18:33 | [cec63b5679] part of check-in [679eff8759] Add a sudoku solver to the recursive query tests in with1.test. (check-in: [679eff8759] user: drh branch: trunk, size: 11305) | |
15:22 | [be21f7efdc] part of check-in [2ad4583c0c] Add asserts() for a couple of unreachable conditions. Add the Mandelbrot Set query as a test case. (check-in: [2ad4583c0c] user: drh branch: trunk, size: 10112) | |
2014-01-17
| ||
18:34 | [6e49c7841a] part of check-in [2031004d96] Minor simplification of error message text for a couple of errors associated with WITH clause processing. (check-in: [2031004d96] user: drh branch: trunk, size: 8351) | |
2014-01-16
| ||
21:59 | [90490c75e9] part of check-in [090a77d978] Tweaks to error message text. (check-in: [090a77d978] user: drh branch: common-table-expr, size: 8381) | |
21:02 | [f160289268] part of check-in [54eee9fe99] Improve the error messages used to report illegal recursive cte references. (check-in: [54eee9fe99] user: dan branch: common-table-expr, size: 8432) | |
2014-01-15
| ||
19:42 | [8ac68051fc] part of check-in [3908e2ea2e] Fixes so that SQLITE_OMIT_CTE builds work. (check-in: [3908e2ea2e] user: dan branch: common-table-expr, size: 7162) | |
18:21 | [fcd45b0128] part of check-in [28aa6db8c8] Disable automatic indices on recursive CTE references. (check-in: [28aa6db8c8] user: dan branch: common-table-expr, size: 7117) | |
18:12 | [951807f724] part of check-in [61be2da0ae] 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. (check-in: [61be2da0ae] user: dan branch: common-table-expr, size: 7120) | |
15:27 | [babb3d9c40] part of check-in [9a514b50e4] Return an error if a CTE specifies a different number of columns than its SELECT statement returns. (check-in: [9a514b50e4] user: dan branch: common-table-expr, size: 6760) | |
14:17 | [77739a9e5e] part of check-in [9472f6d820] Disable the flattening optimization if the sub-query is a recursive CTE. (check-in: [9472f6d820] user: dan branch: common-table-expr, size: 5676) | |
2014-01-14
| ||
20:14 | [12a6661eab] part of check-in [a5c2a54a07] Add code to handle recursive CTEs. (check-in: [a5c2a54a07] user: dan branch: common-table-expr, size: 4362) | |
2014-01-13
| ||
15:12 | [fb8409a35b] part of check-in [a26f399ba4] Add code to handle non-recursive CTEs in the same way as SQL views. (check-in: [a26f399ba4] user: dan branch: common-table-expr, size: 3525) | |
2014-01-11
| ||
19:19 | Added: [e814619831] part of check-in [704d3931b8] Update the parser so that sub-queries and CTEs may have WITH clauses. (check-in: [704d3931b8] user: dan branch: common-table-expr, size: 1036) | |