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