Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/e_select.test
|
2018-12-22
| ||
| 15:46 | [f9474205] part of check-in [ad70f03c] Remove unnecessary whitespace from testcase result strings. (check-in: [ad70f03c] user: drh branch: trunk, size: 82600) | |
|
2018-06-05
| ||
| 20:04 | [c5a669b4] part of check-in [dce2dfbe] 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: [dce2dfbe] user: dan branch: exp-agg-opt, size: 82615) | |
|
2018-03-20
| ||
| 21:16 | [6fd45fd4] part of check-in [5b7abecc] 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: [5b7abecc] user: drh branch: join-strength-reduction, size: 82618) | |
|
2016-11-22
| ||
| 19:15 | [16651bb6] part of check-in [f5ac98ef] Update requirement marks to reflect changes in wording in the documentation. No changes to code. (check-in: [f5ac98ef] user: drh branch: trunk, size: 82606) | |
|
2014-01-30
| ||
| 17:47 | [52692ff3] part of check-in [1973d80e] Update evidence marks on SELECT tests. Comment changes only. No changes to code or tests. (check-in: [1973d80e] user: drh branch: trunk, size: 82612) | |
| 15:03 | [d159f8b9] part of check-in [4a34378b] Fix requirements marks only. No changes to code or tests. (check-in: [4a34378b] user: drh branch: trunk, size: 82617) | |
| 14:10 | [5ea777ed] part of check-in [8560091e] 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: [8560091e] user: drh branch: trunk, size: 82599) | |
|
2014-01-27
| ||
| 15:02 | [51c062a9] part of check-in [be1acb61] Update some requirements marks to conform with improvements in the documentation. (check-in: [be1acb61] user: drh branch: trunk, size: 82115) | |
|
2013-10-08
| ||
| 18:40 | [d3226cb9] part of check-in [18bd6ba9] Further refinement of the idea of multiplying run-time cost estimates by the estimated row size. (check-in: [18bd6ba9] user: drh branch: row-size-est, size: 82214) | |
|
2013-08-02
| ||
| 23:40 | [f2358d07] part of check-in [21302076] Updates to requirements marks. No code changes. (check-in: [21302076] user: drh branch: trunk, size: 82198) | |
|
2013-03-21
| ||
| 21:20 | [d5af998a] part of check-in [6f6e2d50] Many spelling fixes in comments. No changes to code. (check-in: [6f6e2d50] user: mistachkin branch: trunk, size: 82412) | |
|
2012-09-27
| ||
| 19:53 | [07e8d812] part of check-in [0d573320] More test cases an bug fixes for the ORDER BY optimization of joins. All veryquick tests now pass. (check-in: [0d573320] user: drh branch: qp-enhancements, size: 82413) | |
|
2012-09-15
| ||
| 18:45 | [69013a64] part of check-in [cfaa7bc1] 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: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 82416) | |
|
2012-02-13
| ||
| 10:00 | [f5d4b812] part of check-in [76bb649e] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649e] user: dan branch: trunk, size: 82416) | |
|
2012-02-02
| ||
| 18:42 | [99202f99] part of check-in [f27c7b4f] Fix a problem with NULL handling in aggregate min/max when returning values from the row containing the min or max. (check-in: [f27c7b4f] user: drh branch: output-minmax-row, size: 82368) | |
| 17:35 | [f0aa7a97] part of check-in [adb29232] 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: [adb29232] user: drh branch: output-minmax-row, size: 82374) | |
|
2011-12-30
| ||
| 16:07 | [6f488c22] part of check-in [1bb23a3b] Fix up requirements marks for syntax diagrams to reflect the new and improved GIF renderings. (check-in: [1bb23a3b] user: drh branch: trunk, size: 82371) | |
|
2011-06-30
| ||
| 20:17 | [8d7fac7a] part of check-in [f7ba0219] Experimental changes to improve optimization of DISTINCT queries. (check-in: [f7ba0219] user: dan branch: experimental, size: 82371) | |
|
2011-06-20
| ||
| 22:34 | [7ac53674] part of check-in [bd980be4] Fix typos in evidence marks on tests. (check-in: [bd980be4] user: drh branch: trunk, size: 82371) | |
|
2010-11-02
| ||
| 15:26 | [bf385ae3] part of check-in [3771faa8] 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: [3771faa8] user: drh branch: trunk, size: 82375) | |
|
2010-09-24
| ||
| 19:14 | [6c0244ea] part of check-in [f44de500] Modify some evidence tags to match updated gifs. (check-in: [f44de500] user: dan branch: trunk, size: 82257) | |
| 18:04 | [418edbdf] part of check-in [30801892] Add new file e_vacuum.test. Move part of e_select.test into e_select2.test. (check-in: [30801892] user: dan branch: experimental, size: 82257) | |
| 08:00 | [e9075e79] part of check-in [7893e525] Modify testable statement ids in a few test files to account for recent docsrc changes. (check-in: [7893e525] user: dan branch: trunk, size: 100988) | |
|
2010-09-18
| ||
| 19:00 | [64b9cc44] part of check-in [8023a309] Add new test file e_insert.test. (check-in: [8023a309] user: dan branch: trunk, size: 101289) | |
| 15:15 | [8b1747f8] part of check-in [14227724] Fix a couple of stale evidence marks in e_select.test. (check-in: [14227724] user: dan branch: trunk, size: 102591) | |
| 15:03 | [d693d198] part of check-in [0ee9e755] Add tests to e_select.test. (check-in: [0ee9e755] user: dan branch: trunk, size: 102591) | |
|
2010-09-17
| ||
| 19:04 | [66d39869] part of check-in [2254e93b] Add tests for some syntax diagrams in lang_select.html. (check-in: [2254e93b] user: dan branch: trunk, size: 99791) | |
|
2010-09-16
| ||
| 18:51 | [08868f62] part of check-in [7c989db5] Add tests for ORDER BY, LIMIT and OFFSET clauses to e_select.test. (check-in: [7c989db5] user: dan branch: trunk, size: 95272) | |
|
2010-09-15
| ||
| 19:02 | [8eea9e86] part of check-in [14f15663] Add tests for ORDER BY clauses to e_select.test. (check-in: [14f15663] user: dan branch: trunk, size: 84152) | |
|
2010-09-14
| ||
| 18:56 | [64b04eb0] part of check-in [a0f01eba] Further tests for compound SELECT statements. (check-in: [a0f01eba] user: dan branch: trunk, size: 74081) | |
|
2010-09-13
| ||
| 18:58 | [d2c9d044] part of check-in [8b0b009f] Add tests for compound SELECT statements to e_select.test. (check-in: [8b0b009f] user: dan branch: trunk, size: 68599) | |
|
2010-09-11
| ||
| 17:37 | [b033fb10] part of check-in [43a99d9a] Add tests for "DISTINCT" and "ALL" to e_select.test. (check-in: [43a99d9a] user: dan branch: trunk, size: 58819) | |
|
2010-09-10
| ||
| 19:18 | [ea3648d0] part of check-in [3a051a76] Add tests to e_select.test. (check-in: [3a051a76] user: dan branch: trunk, size: 52921) | |
|
2010-09-09
| ||
| 19:02 | [e70de931] part of check-in [5e73f7b2] Add test cases to e_select.test. (check-in: [5e73f7b2] user: dan branch: trunk, size: 45636) | |
| 11:33 | [a3f2bc8b] part of check-in [721b73fa] Add WHERE clause tests to e_select.test. (check-in: [721b73fa] user: dan branch: trunk, size: 40490) | |
| 10:00 | [1adce7a2] part of check-in [2c6b1ca9] Add tests for sub-select statements in the FROM clause of a SELECT to e_select.test. (check-in: [2c6b1ca9] user: dan branch: trunk, size: 38357) | |
|
2010-09-08
| ||
| 19:16 | [59c4dd36] part of check-in [8fe34faf] Fix problem with test names in e_select.test. (check-in: [8fe34faf] user: dan branch: trunk, size: 34904) | |
| 19:02 | [f84259a1] part of check-in [727ced6b] Add tests to e_select.test. (check-in: [727ced6b] user: dan branch: trunk, size: 34821) | |
|
2010-09-07
| ||
| 19:05 | [844c6068] part of check-in [282dae7e] Add tests to e_select.test. (check-in: [282dae7e] user: dan branch: trunk, size: 19523) | |
|
2010-09-06
| ||
| 18:50 | [0c491c94] part of check-in [9db26d5e] Add test cases to e_select.test. (check-in: [9db26d5e] user: dan branch: trunk, size: 12926) | |
|
2010-09-04
| ||
| 18:52 | [f2469d2c] part of check-in [8b9d8c22] Add test file e_select.test. (check-in: [8b9d8c22] user: dan branch: trunk, size: 6998) Added | |