/ All files named "test/subquery.test"
Login

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

History for test/subquery.test

2020-07-29
16:18
[3e623f5c] part of check-in [a80ae2c9] 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: [a80ae2c9] user: drh branch: typos, size: 15252)
2015-04-21
17:07
[d7268d19] part of check-in [9e6beda2] Make sure the datatype and collating sequence of transients tables are not initialized more than once. Otherwise a memory leak results. (check-in: [9e6beda2] user: drh branch: trunk, size: 15253)
2013-10-04
15:58
[666fdecc] part of check-in [2f394de8] 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: [2f394de8] user: drh branch: index-scan-rate, size: 14952)
2013-06-03
22:08
[3b97763a] part of check-in [eb27086e] Remove more vestiges of sqlite_query_plan from the test cases. (check-in: [eb27086e] user: drh branch: nextgen-query-plan-exp, size: 14962)
2013-03-21
21:20
[869562de] part of check-in [6f6e2d50] Many spelling fixes in comments. No changes to code. (check-in: [6f6e2d50] user: mistachkin branch: trunk, size: 14886)
2012-05-21
20:13
[d4aea23a] part of check-in [f3dd1faf] Candidate fix for the nested aggregate query problem of ticket [c2ad16f997ee9c8e]. (check-in: [f3dd1faf] user: drh branch: nested-agg, size: 14886)
2012-04-17
16:38
[c5e0d183] part of check-in [430bb59d] Improved handling of aggregate subqueries within an aggregate query. (check-in: [430bb59d] user: drh branch: trunk, size: 13910)
2009-01-09
01:12
[b524f57c] part of check-in [45bb5703] Increased test coverage. (CVS 6147) (check-in: [45bb5703] user: drh branch: trunk, size: 12672)
2008-07-10
00:32
[d78fe135] part of check-in [636cd723] 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: [636cd723] user: drh branch: trunk, size: 12570)
2007-09-18
16:53
[8203f85d] part of check-in [5c41619e] 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: [5c41619e] user: drh branch: trunk, size: 12578)
2006-01-17
09:35
[ae324ee9] part of check-in [3a54a33d] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 10788)
2005-09-08
10:37
[e6de5333] part of check-in [21adf4bd] 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: [21adf4bd] user: drh branch: trunk, size: 10579)
2005-08-25
12:45
[ed4ecba1] part of check-in [fc9e0460] 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: [fc9e0460] user: drh branch: trunk, size: 10593)
2005-07-21
03:48
[0df3de0d] part of check-in [ef3a157f] Add comments to test cases. Improvements to the query plan test variable. (CVS 2555) (check-in: [ef3a157f] user: drh branch: trunk, size: 10055)
03:15
[d8364e07] part of check-in [c30cbba9] In where.c, split out the code that selects an index into a separate subroutine. (CVS 2554) (check-in: [c30cbba9] user: drh branch: trunk, size: 9461)
2005-05-23
15:06
[0e37f0f0] part of check-in [ef4059e3] 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: [ef4059e3] user: drh branch: trunk, size: 9402)
2005-02-14
06:38
[6274cce7] part of check-in [41d2214b] Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329) (check-in: [41d2214b] user: danielk1977 branch: trunk, size: 8052)
2005-02-12
08:59
[409078e5] part of check-in [f7858d88] Fix a problem with sub-queries and the flattening optimization. Also handle an extra case of database corruption. (CVS 2324) (check-in: [f7858d88] user: danielk1977 branch: trunk, size: 7750)
2005-02-09
01:40
[3b24c027] part of check-in [ddcea6f8] Document SQLITE_DEFAULT_CACHE_SIZE and SQLITE_DEFAULT_TEMP_CACHE_SIZE macros. (CVS 2320) (check-in: [ddcea6f8] user: danielk1977 branch: trunk, size: 6521)
2005-02-08
07:50
[958bf175] part of check-in [f0d3ca10] Fix for correlated subqueries where the parent is an aggregate. Ticket #1105. (CVS 2318) (check-in: [f0d3ca10] user: danielk1977 branch: trunk, size: 6409)
2005-01-30
11:11
[e607b552] part of check-in [9843c0dd] Respect collation sequences in views. Ticket #1088. (CVS 2291) (check-in: [9843c0dd] user: danielk1977 branch: trunk, size: 5651)
2005-01-29
08:32
[ecec0780] part of check-in [b1b50f31] Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) (check-in: [b1b50f31] user: danielk1977 branch: trunk, size: 5362)
2005-01-21
11:55
[a3ed9f11] part of check-in [9c4d0e13] Improve test coverage for minimum feature builds. (CVS 2254) (check-in: [9c4d0e13] user: danielk1977 branch: trunk, size: 1505)
02:34
Added: [34ee5ea7] part of check-in [de8ee3a2] Add a new test file for subqueries. (CVS 2250) (check-in: [de8ee3a2] user: drh branch: trunk, size: 1449)