Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/subquery.test
2025-04-14
| ||
19:43 | [23087f9b1c] part of check-in [92513f6bce] Improved estimate on the number of output rows in a recursive common table expression that uses the UNION operator. Follow-up to [f911f1c4977fbcae] and it's output row estimate changes associated with DISTINCT queries. (check-in: [92513f6bce] user: drh branch: trunk, size: 21320) | |
2024-04-25
| ||
17:52 | [903abf4104] part of check-in [bbdf22e3d9] Further improvements to the computation of affinity for compound subqueries: make sure that the selected affinity is compatible with a literal values in arms to the left of the arm that is used to determine affinity. (check-in: [bbdf22e3d9] user: drh branch: compound-subquery-affinity, size: 20176) | |
2023-09-15
| ||
20:04 | [3f46cc25b0] 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: 16418) | |
19:00 | [312c5d2630] part of check-in [27390051e8] Do not reduce subquery output row count estimates due to DISTINCT until after the decision of whether or not to use an index for ORDER BY has been made. (check-in: [27390051e8] user: drh branch: rethink-viewscan, size: 17029) | |
2022-01-16
| ||
19:11 | [3a1a5b600b] part of check-in [4883776669] Fix test cases so that they all still work even with -DSQLITE_DQS=0. (check-in: [4883776669] user: drh branch: trunk, size: 15894) | |
2022-01-12
| ||
20:31 | [e6fb2ad0a7] part of check-in [9282bcde30] When the result of a subquery is to be stored in a register and that subquery has an ORDER BY clause and an OFFSET, NULL out the destination register before starting the ORDER BY so that the register will be set correctly even if the OFFSET is larger than the number of output rows. Fix for the problem reported in forum post 0ec80f12d02acb3f. (check-in: [9282bcde30] user: drh branch: trunk, size: 15894) | |
2020-07-29
| ||
16:18 | [3e623f5c1e] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 15252) | |
2015-04-21
| ||
17:07 | [d7268d193d] part of check-in [9e6beda2c8] Make sure the datatype and collating sequence of transients tables are not initialized more than once. Otherwise a memory leak results. (check-in: [9e6beda2c8] user: drh branch: trunk, size: 15253) | |
2013-10-04
| ||
15:58 | [666fdeccea] part of check-in [2f394de88f] Fix test cases so that they work when the query planner uses index size estimates to determine whether or not to try an covering index scan. (check-in: [2f394de88f] user: drh branch: index-scan-rate, size: 14952) | |
2013-06-03
| ||
22:08 | [3b97763ada] part of check-in [eb27086e8a] Remove more vestiges of sqlite_query_plan from the test cases. (check-in: [eb27086e8a] user: drh branch: nextgen-query-plan-exp, size: 14962) | |
2013-03-21
| ||
21:20 | [869562de9e] part of check-in [6f6e2d5094] Many spelling fixes in comments. No changes to code. (check-in: [6f6e2d5094] user: mistachkin branch: trunk, size: 14886) | |
2012-05-21
| ||
20:13 | [d4aea23ac2] part of check-in [f3dd1fafd4] Candidate fix for the nested aggregate query problem of ticket [c2ad16f997ee9c8e]. (check-in: [f3dd1fafd4] user: drh branch: nested-agg, size: 14886) | |
2012-04-17
| ||
16:38 | [c5e0d183f1] part of check-in [430bb59d79] Improved handling of aggregate subqueries within an aggregate query. (check-in: [430bb59d79] user: drh branch: trunk, size: 13910) | |
2009-01-09
| ||
01:12 | [b524f57c95] part of check-in [45bb5703d7] Increased test coverage. (CVS 6147) (check-in: [45bb5703d7] user: drh branch: trunk, size: 12672) | |
2008-07-10
| ||
00:32 | [d78fe135ff] part of check-in [636cd72329] Remove unused code. Test coverage enhancements. Modify the algorithm used to select column names for VIEWs of joins so that the constructed column names omits the underlying table names. (CVS 5386) (check-in: [636cd72329] user: drh branch: trunk, size: 12570) | |
2007-09-18
| ||
16:53 | [8203f85db5] part of check-in [5c41619e29] Add disabled test cases for ticket #2652. We will enable these test cases after #2652 is fixed. The fix will be difficult and will probably take a while. On the other hand, correlated aggregate queries have never worked in SQLite and the problem is just now coming to light, so it is probably not a pressing issue. (CVS 4435) (check-in: [5c41619e29] user: drh branch: trunk, size: 12578) | |
2006-01-17
| ||
09:35 | [ae324ee928] part of check-in [3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33dcb] user: danielk1977 branch: trunk, size: 10788) | |
2005-09-08
| ||
10:37 | [e6de53332c] part of check-in [21adf4bd99] The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) (check-in: [21adf4bd99] user: drh branch: trunk, size: 10579) | |
2005-08-25
| ||
12:45 | [ed4ecba1af] part of check-in [fc9e04609b] When the left-hand side of an IN operator is constant and the right-hand side is a SELECT, recognize that the IN operator is not constant. Ticket #1380. (CVS 2624) (check-in: [fc9e04609b] user: drh branch: trunk, size: 10593) | |
2005-07-21
| ||
03:48 | [0df3de0dbb] part of check-in [ef3a157f46] Add comments to test cases. Improvements to the query plan test variable. (CVS 2555) (check-in: [ef3a157f46] user: drh branch: trunk, size: 10055) | |
03:15 | [d8364e0719] part of check-in [c30cbba9ea] In where.c, split out the code that selects an index into a separate subroutine. (CVS 2554) (check-in: [c30cbba9ea] user: drh branch: trunk, size: 9461) | |
2005-05-23
| ||
15:06 | [0e37f0f032] part of check-in [ef4059e3af] Make sure that the use of a double-quoted string literal does not trick the optimizer into using a correlated subquery when a static subquery would suffice. (CVS 2477) (check-in: [ef4059e3af] user: drh branch: trunk, size: 9402) | |
2005-02-14
| ||
06:38 | [6274cce761] part of check-in [41d2214b83] Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329) (check-in: [41d2214b83] user: danielk1977 branch: trunk, size: 8052) | |
2005-02-12
| ||
08:59 | [409078e5fd] part of check-in [f7858d8830] Fix a problem with sub-queries and the flattening optimization. Also handle an extra case of database corruption. (CVS 2324) (check-in: [f7858d8830] user: danielk1977 branch: trunk, size: 7750) | |
2005-02-09
| ||
01:40 | [3b24c02749] part of check-in [ddcea6f889] Document SQLITE_DEFAULT_CACHE_SIZE and SQLITE_DEFAULT_TEMP_CACHE_SIZE macros. (CVS 2320) (check-in: [ddcea6f889] user: danielk1977 branch: trunk, size: 6521) | |
2005-02-08
| ||
07:50 | [958bf1752c] part of check-in [f0d3ca10c5] Fix for correlated subqueries where the parent is an aggregate. Ticket #1105. (CVS 2318) (check-in: [f0d3ca10c5] user: danielk1977 branch: trunk, size: 6409) | |
2005-01-30
| ||
11:11 | [e607b55276] part of check-in [9843c0dd79] Respect collation sequences in views. Ticket #1088. (CVS 2291) (check-in: [9843c0dd79] user: danielk1977 branch: trunk, size: 5651) | |
2005-01-29
| ||
08:32 | [ecec0780e2] part of check-in [b1b50f3158] Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) (check-in: [b1b50f3158] user: danielk1977 branch: trunk, size: 5362) | |
2005-01-21
| ||
11:55 | [a3ed9f11a4] part of check-in [9c4d0e13e8] Improve test coverage for minimum feature builds. (CVS 2254) (check-in: [9c4d0e13e8] user: danielk1977 branch: trunk, size: 1505) | |
02:34 | Added: [34ee5ea737] part of check-in [de8ee3a29e] Add a new test file for subqueries. (CVS 2250) (check-in: [de8ee3a29e] user: drh branch: trunk, size: 1449) | |