Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/selectC.test
2023-09-15
| ||
20:04 | [5bbdc8459a] part of check-in [796a65fa61] Drop support for the view-scan optimization as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subsqueries by a factor of 8. (check-in: [796a65fa61] user: drh branch: branch-3.28, size: 6859) | |
2023-06-09
| ||
13:08 | [294b7566a3] part of check-in [f587891134] Experimental change to add a per-connection option that raises an error if a bare column appears in an aggregate query. (check-in: [f587891134] user: drh branch: newbie-safe-aggregates, size: 6901) | |
2023-02-16
| ||
19:04 | [ef9eddcd89] part of check-in [57a4e91f43] Back-port omit-unused-subquery-column enhancements into the 3.28 branch. (check-in: [57a4e91f43] user: drh branch: branch-3.28, size: 6845) | |
15:54 | [38c530b0cc] part of check-in [cc148503db] Do not perform the omit-unused-subquery-columns optimizations on a subquery that is DISTINCT, as that can lead to incorrect results. (check-in: [cc148503db] user: drh branch: omit-unused-subquery-columns, size: 6859) | |
2022-09-01
| ||
10:41 | [2bbed4310e] part of check-in [e3754cc188] In the query planner, add a heuristic that will reduce the cost of a full table scan for a materialized view or subquery if the full scan is the outer-most loop. This is shown to speed up some queries. (check-in: [e3754cc188] user: drh branch: branch-3.28, size: 6717) | |
2020-12-16
| ||
20:00 | [fec14c9015] part of check-in [00e4bf74d3] Allow sub-queries that use UNION ALL to be flattened, even if the parent query is a join. Still some problems on this branch. (check-in: [00e4bf74d3] user: dan branch: union-all-flattener, size: 6731) | |
2017-01-05
| ||
17:23 | [e25243f8ca] part of check-in [590ca83b8e] Fix handling the case where a sub-query in a FROM clause is itself a UNION ALL, and one side of that UNION ALL is a query on a view that includes an ORDER BY. Fix for ticket [190c2507]. (check-in: [590ca83b8e] user: dan branch: trunk, size: 6718) | |
2012-02-13
| ||
10:00 | [871fb55d88] part of check-in [76bb649ee2] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649ee2] user: dan branch: trunk, size: 5812) | |
2010-08-13
| ||
16:38 | [f9bf1bc458] part of check-in [497aafd8ed] Do not apply the flattening optimization if the sub-query is DISTINCT. Fix for [e4b8a2ba6e]. (check-in: [497aafd8ed] user: dan branch: trunk, size: 5802) | |
2010-03-31
| ||
15:02 | [33bb5673a8] part of check-in [ffc23409c7] Clear the column cache before populating aggregate accumulator registers. Fix fo r [883034dcb5]. (check-in: [ffc23409c7] user: dan branch: trunk, size: 5133) | |
2009-09-21
| ||
16:06 | [07a45610c8] part of check-in [fb6ceed388] Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. (check-in: [fb6ceed388] user: dan branch: trunk, size: 3597) | |
2009-05-17
| ||
15:26 | [035597b7a5] part of check-in [dd665eac8c] Take care to free the memory for the ORDER BY clause on SELECT statements containing errors and contained within triggers. Ticket #3863. (CVS 6644) (check-in: [dd665eac8c] user: drh branch: trunk, size: 3551) | |
2009-03-02
| ||
01:22 | [ae49d258c8] part of check-in [fa0008502e] Fix a bug in the GROUP BY alias name resolution. The bug was by check-in (6305). Discovered by regression test on 64-bit linux. Test cases added so that the problems is detected on 32-bit systems. (CVS 6332) (check-in: [fa0008502e] user: drh branch: trunk, size: 3120) | |
2008-09-17
| ||
00:13 | [44f4e1b2c8] part of check-in [f8b759f197] Fix for tickets #3378 and #3381 that preserves the aliasing optimization. And yet, this fix feels uncomfortable. Seeking an alternative... (CVS 5712) (check-in: [f8b759f197] user: drh branch: trunk, size: 2512) | |
2008-09-16
| ||
18:02 | [afc5b7bb57] part of check-in [a67da9dd2f] Add test cases for ticket #3378 and #3381. Add a temporary hack to get those to problems fixed. The hack causes failures in alias.test, but those are much less serious than the aforementioned tickets. This is a stop-gap until we can figure out a proper fix. (CVS 5711) (check-in: [a67da9dd2f] user: drh branch: trunk, size: 2398) | |
15:09 | Added: [fbce7d0dce] part of check-in [3847faff55] Add test script selectC.test which demonstrates ticket #3381. (CVS 5708) (check-in: [3847faff55] user: drh branch: trunk, size: 1601) | |