Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
20 check-ins related to "early-winfunc-rewrite-dev"
|
2020-06-07
| ||
| 14:42 | New debugging output. (Leaf check-in: c0d9dfe507 user: drh tags: early-winfunc-rewrite-dev) | |
| 12:26 | Improvements to the treeview debugging display. (check-in: a7c5c73992 user: drh tags: early-winfunc-rewrite-dev) | |
| 00:51 | Extra steps to ensure that queries that involve both window functions and aggregate functions are processed correctly by sqlite3WindowRewrite(). Fix for ticket [e5504e987e419fb0]. (Leaf check-in: 765bbcce1d user: drh tags: branch-3.32-early-winfunc-rewrite) | |
| 00:43 | Extra steps to ensure that queries that involve both window functions and aggregate functions are processed correctly by sqlite3WindowRewrite(). Fix for ticket [e5504e987e419fb0]. (check-in: a6c2147cc6 user: drh tags: early-winfunc-rewrite-dev) | |
|
2020-06-06
| ||
| 20:48 | Merge multiple changes from trunk to address concerns with window-function parse-tree rewriting. (check-in: 05418b2a4a user: drh tags: branch-3.32-early-winfunc-rewrite) | |
| 19:54 | Fix a possible ASAN violation inside of debug-only code following an OOM. (check-in: 0e021887a1 user: drh tags: early-winfunc-rewrite-dev) | |
| 19:35 | When determining if the subquery inserted by the window-function rewriter is an aggregate query, aggregate functions that are in parameters to another window function do not count. Fix for ticket [1f6f353b684fc708] (check-in: 8583c3483c user: drh tags: early-winfunc-rewrite-dev) | |
| 18:45 | Clearly distinguish between window functions and scalar functions in the debugging TreeView output. (check-in: 15babdcb91 user: drh tags: early-winfunc-rewrite-dev) | |
| 18:34 | In the query flattener, defer deleting content until after associated Parse object is destroyed, in case some of the deleted expressions have been collected for use by sAggInfo. (check-in: 03b32be44d user: drh tags: early-winfunc-rewrite-dev) | |
| 14:58 | Remove an incorrect assert() added earlier today. (check-in: 3926ff1725 user: drh tags: early-winfunc-rewrite-dev) | |
| 14:44 | When rewriting the parse-tree for window functions, ensure that the inserted subqueries have an accurate SF_Aggregate bit set. This change also coincidentally fixes ticket [0899cf62f597d7e7], even thought that was not the issue we were working on at the time. (check-in: 2cddb24e91 user: drh tags: early-winfunc-rewrite-dev) | |
| 14:29 | Fix an assert() failure that could occur if an ORDER BY expression attached to a compound query contains a subquery that (a) is itself a compound query, (b) uses window functions and (c) has an ORDER BY clause that includes another sub-query. (check-in: c96914ea02 user: dan tags: early-winfunc-rewrite-dev) | |
| 13:29 | Avoid no-op calls to sqlite3SelectPrep() when processing sqlite3Select() for subqueries. This simplifies the ".selecttrace" debugging output. (check-in: 3de19ee22a user: drh tags: early-winfunc-rewrite-dev) | |
|
2020-06-05
| ||
| 21:36 | Improved tracing of window function parse tree rewrites. (check-in: 7e8060cf96 user: drh tags: early-winfunc-rewrite-dev) | |
| 18:17 | Assign a fake name to the ephemeral subquery tables that are created when making parse-tree changes for window functions. (check-in: c4072267dc user: drh tags: early-winfunc-rewrite-dev) | |
| 15:56 | Do parse-tree transformations required for window functions prior to running aggregate function analysis. Fix for ticket [c8d3b9f0a750a529]. (check-in: 79eff1d038 user: drh tags: branch-3.32-early-winfunc-rewrite) | |
| 15:40 | New test case for fuzzdata8.db. (check-in: 2870d11720 user: drh tags: early-winfunc-rewrite-dev) | |
| 15:26 | Do parse-tree transformations required for window functions prior to running aggregate function analysis. Fix for ticket [c8d3b9f0a750a529]. (check-in: 0b42a2277e user: drh tags: early-winfunc-rewrite-dev) | |
| 14:53 | Ensure that the "push-down" optimization does not push constraints down into compound queries if any of the component queries uses window functions. (Closed-Leaf check-in: 2011e83213 user: dan tags: early-winfunc-rewrite) | |
| 04:01 | In the debugging treeview output, change the name of "SELECT-expr" expression nodes to be "subquery-expr", so as to not confuse them with actual SELECT nodes. (check-in: c1c8937a30 user: drh tags: trunk) | |