Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/e_select.test
2023-10-20
| ||
20:19 | [327a15f140] part of check-in [b91c19bf26] Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG. (check-in: [b91c19bf26] user: drh branch: string_agg, size: 82630) | |
2022-05-10
| ||
17:42 | [89fa483f68] part of check-in [3eda4030f7] Fix a stale requirement mark. (check-in: [3eda4030f7] user: drh branch: echo-sql, size: 82632) | |
2022-04-07
| ||
01:11 | [9b7ca08975] part of check-in [158156a3e3] Improved technique for parsing the ON and USING clauses of a join is faster and uses less memory. (check-in: [158156a3e3] user: drh branch: trunk, size: 82646) | |
2021-06-16
| ||
12:26 | [c5425a423d] part of check-in [be00e45b72] Adjustments to requirement markings in comments. No changes to code. (check-in: [be00e45b72] user: drh branch: trunk, size: 82674) | |
2018-12-22
| ||
15:46 | [f947420566] part of check-in [ad70f03ced] Remove unnecessary whitespace from testcase result strings. (check-in: [ad70f03ced] user: drh branch: trunk, size: 82600) | |
2018-06-05
| ||
20:04 | [c5a669b4d6] part of check-in [dce2dfbe15] Calculate non-aggregate expressions in the SELECT list of an aggregate query that does not use min() or max() once per group, instead of once per row visited. (check-in: [dce2dfbe15] user: dan branch: exp-agg-opt, size: 82615) | |
2018-03-20
| ||
21:16 | [6fd45fd4a5] part of check-in [5b7abecc7a] If terms of the WHERE clause require that the right table in a LEFT JOIN not be a null row, then simplify the LEFT JOIN into an ordinary JOIN. (check-in: [5b7abecc7a] user: drh branch: join-strength-reduction, size: 82618) | |
2016-11-22
| ||
19:15 | [16651bb681] part of check-in [f5ac98efb5] Update requirement marks to reflect changes in wording in the documentation. No changes to code. (check-in: [f5ac98efb5] user: drh branch: trunk, size: 82606) | |
2014-01-30
| ||
17:47 | [52692ff384] part of check-in [1973d80e47] Update evidence marks on SELECT tests. Comment changes only. No changes to code or tests. (check-in: [1973d80e47] user: drh branch: trunk, size: 82612) | |
15:03 | [d159f8b9f4] part of check-in [4a34378b9b] Fix requirements marks only. No changes to code or tests. (check-in: [4a34378b9b] user: drh branch: trunk, size: 82617) | |
14:10 | [5ea777ed64] part of check-in [8560091e85] Update a requirement mark and add some additional test cases to cover the requirement associated with ORDER BY and LIMIT on compound SELECT statements. (check-in: [8560091e85] user: drh branch: trunk, size: 82599) | |
2014-01-27
| ||
15:02 | [51c062a9bd] part of check-in [be1acb610f] Update some requirements marks to conform with improvements in the documentation. (check-in: [be1acb610f] user: drh branch: trunk, size: 82115) | |
2013-10-08
| ||
18:40 | [d3226cb94f] part of check-in [18bd6ba96d] Further refinement of the idea of multiplying run-time cost estimates by the estimated row size. (check-in: [18bd6ba96d] user: drh branch: row-size-est, size: 82214) | |
2013-08-02
| ||
23:40 | [f2358d074b] part of check-in [213020769f] Updates to requirements marks. No code changes. (check-in: [213020769f] user: drh branch: trunk, size: 82198) | |
2013-03-21
| ||
21:20 | [d5af998a40] part of check-in [6f6e2d5094] Many spelling fixes in comments. No changes to code. (check-in: [6f6e2d5094] user: mistachkin branch: trunk, size: 82412) | |
2012-09-27
| ||
19:53 | [07e8d81268] part of check-in [0d57332005] More test cases an bug fixes for the ORDER BY optimization of joins. All veryquick tests now pass. (check-in: [0d57332005] user: drh branch: qp-enhancements, size: 82413) | |
2012-09-15
| ||
18:45 | [69013a64b4] part of check-in [cfaa7bc128] Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (check-in: [cfaa7bc128] user: drh branch: fullscan-covering-index, size: 82416) | |
2012-02-13
| ||
10:00 | [f5d4b81205] 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: 82416) | |
2012-02-02
| ||
18:42 | [99202f99a9] part of check-in [f27c7b4fb1] Fix a problem with NULL handling in aggregate min/max when returning values from the row containing the min or max. (check-in: [f27c7b4fb1] user: drh branch: output-minmax-row, size: 82368) | |
17:35 | [f0aa7a972a] part of check-in [adb29232b6] For queries of the form "SELECT p, max(q) FROM t1", the value of column p returned is the one on the same row that holds the maximum value of q. (check-in: [adb29232b6] user: drh branch: output-minmax-row, size: 82374) | |
2011-12-30
| ||
16:07 | [6f488c2285] part of check-in [1bb23a3b52] Fix up requirements marks for syntax diagrams to reflect the new and improved GIF renderings. (check-in: [1bb23a3b52] user: drh branch: trunk, size: 82371) | |
2011-06-30
| ||
20:17 | [8d7fac7a26] part of check-in [f7ba0219ef] Experimental changes to improve optimization of DISTINCT queries. (check-in: [f7ba0219ef] user: dan branch: experimental, size: 82371) | |
2011-06-20
| ||
22:34 | [7ac53674e8] part of check-in [bd980be471] Fix typos in evidence marks on tests. (check-in: [bd980be471] user: drh branch: trunk, size: 82371) | |
2010-11-02
| ||
15:26 | [bf385ae3aa] part of check-in [3771faa88e] Add evidence marks for the sqlite3_blob_reopen() interface. Fix compiler warnings in test1.c. Fix incorrect evidence marks on e_select.tcl. (check-in: [3771faa88e] user: drh branch: trunk, size: 82375) | |
2010-09-24
| ||
19:14 | [6c0244eacf] part of check-in [f44de500be] Modify some evidence tags to match updated gifs. (check-in: [f44de500be] user: dan branch: trunk, size: 82257) | |
18:04 | [418edbdf91] part of check-in [30801892c6] Add new file e_vacuum.test. Move part of e_select.test into e_select2.test. (check-in: [30801892c6] user: dan branch: experimental, size: 82257) | |
08:00 | [e9075e798a] part of check-in [7893e52595] Modify testable statement ids in a few test files to account for recent docsrc changes. (check-in: [7893e52595] user: dan branch: trunk, size: 100988) | |
2010-09-18
| ||
19:00 | [64b9cc44f8] part of check-in [8023a3091b] Add new test file e_insert.test. (check-in: [8023a3091b] user: dan branch: trunk, size: 101289) | |
15:15 | [8b1747f86c] part of check-in [14227724a8] Fix a couple of stale evidence marks in e_select.test. (check-in: [14227724a8] user: dan branch: trunk, size: 102591) | |
15:03 | [d693d19856] part of check-in [0ee9e75571] Add tests to e_select.test. (check-in: [0ee9e75571] user: dan branch: trunk, size: 102591) | |
2010-09-17
| ||
19:04 | [66d398699f] part of check-in [2254e93bd5] Add tests for some syntax diagrams in lang_select.html. (check-in: [2254e93bd5] user: dan branch: trunk, size: 99791) | |
2010-09-16
| ||
18:51 | [08868f620e] part of check-in [7c989db55c] Add tests for ORDER BY, LIMIT and OFFSET clauses to e_select.test. (check-in: [7c989db55c] user: dan branch: trunk, size: 95272) | |
2010-09-15
| ||
19:02 | [8eea9e86a3] part of check-in [14f1566327] Add tests for ORDER BY clauses to e_select.test. (check-in: [14f1566327] user: dan branch: trunk, size: 84152) | |
2010-09-14
| ||
18:56 | [64b04eb0de] part of check-in [a0f01ebab9] Further tests for compound SELECT statements. (check-in: [a0f01ebab9] user: dan branch: trunk, size: 74081) | |
2010-09-13
| ||
18:58 | [d2c9d04481] part of check-in [8b0b009f29] Add tests for compound SELECT statements to e_select.test. (check-in: [8b0b009f29] user: dan branch: trunk, size: 68599) | |
2010-09-11
| ||
17:37 | [b033fb107c] part of check-in [43a99d9a88] Add tests for "DISTINCT" and "ALL" to e_select.test. (check-in: [43a99d9a88] user: dan branch: trunk, size: 58819) | |
2010-09-10
| ||
19:18 | [ea3648d047] part of check-in [3a051a76f7] Add tests to e_select.test. (check-in: [3a051a76f7] user: dan branch: trunk, size: 52921) | |
2010-09-09
| ||
19:02 | [e70de931b3] part of check-in [5e73f7b2b7] Add test cases to e_select.test. (check-in: [5e73f7b2b7] user: dan branch: trunk, size: 45636) | |
11:33 | [a3f2bc8bf2] part of check-in [721b73fa5c] Add WHERE clause tests to e_select.test. (check-in: [721b73fa5c] user: dan branch: trunk, size: 40490) | |
10:00 | [1adce7a2fc] part of check-in [2c6b1ca952] Add tests for sub-select statements in the FROM clause of a SELECT to e_select.test. (check-in: [2c6b1ca952] user: dan branch: trunk, size: 38357) | |
2010-09-08
| ||
19:16 | [59c4dd36b2] part of check-in [8fe34faf6b] Fix problem with test names in e_select.test. (check-in: [8fe34faf6b] user: dan branch: trunk, size: 34904) | |
19:02 | [f84259a150] part of check-in [727ced6bab] Add tests to e_select.test. (check-in: [727ced6bab] user: dan branch: trunk, size: 34821) | |
2010-09-07
| ||
19:05 | [844c606826] part of check-in [282dae7edf] Add tests to e_select.test. (check-in: [282dae7edf] user: dan branch: trunk, size: 19523) | |
2010-09-06
| ||
18:50 | [0c491c94d6] part of check-in [9db26d5ef5] Add test cases to e_select.test. (check-in: [9db26d5ef5] user: dan branch: trunk, size: 12926) | |
2010-09-04
| ||
18:52 | Added: [f2469d2c20] part of check-in [8b9d8c226e] Add test file e_select.test. (check-in: [8b9d8c226e] user: dan branch: trunk, size: 6998) | |