/ File History
Login

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