SQLite

Check-in [df1d6482f9]
Login

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

Overview
Comment:Allow UNION ALL sub-queries to be flattened even if the parent query is a join.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: df1d6482f9e92dafdca1948e96eef52d8646eef9c356394afabe431d6357dd34
User & Date: drh 2020-12-19 13:58:06.688
Original Comment: Allow UNION ALL sub-queriesto be flattened even if the parent query is a join.
References
2021-04-26
21:23
Fix the UNION ALL flattener optimization so that it works better with recursive CTEs. dbsqlfuzz 88ed5c66789fced139d148aed823cba7c0926dd7 (check-in: f80d7bb2c3 user: drh tags: trunk)
2021-02-13
14:26
Fix a problem in the unreleased union-all flattening enhancement (check-in: e4f8a79fd8 user: dan tags: trunk)
Context
2020-12-19
15:39
Fix a broken assert() in fts5 that could be triggered by corrupt database records. (check-in: b79f59f9ad user: dan tags: trunk)
13:58
Allow UNION ALL sub-queries to be flattened even if the parent query is a join. (check-in: df1d6482f9 user: drh tags: trunk)
2020-12-18
18:04
Fix for the previous fix in the case where a UNION ALL sub-query is joined against some other compound query. (Closed-Leaf check-in: 63c5cfb9ae user: dan tags: union-all-flattener)
2020-12-17
15:17
In the CLI, add the ".filectrl data_version" command. And put the various ".filectrl" subcommands in alphabetical order. (check-in: 3434452148 user: drh tags: trunk)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/select.c.
Changes to test/selectC.test.
Added test/unionall.test.
Added test/unionallfault.test.
Changes to test/whereL.test.