SQLite

All files named ”test/e_select.test”
Login

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)