/ File History
Login

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

History of test/subquery.test

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