SQLite

All files named ”test/selectC.test”
Login

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)