History log of /sqlite-3.40.0/test/e_select.test (Results 1 – 25 of 45)
Revision (<<< Hide revision tags) (Show revision tags >>>) Date Author Comments
Revision tags: release, version-3.50.2, version-3.50.1, major-release, version-3.50.0, version-3.49.2, patch-release, version-3.44.4, version-3.49.1, version-3.49.0, major-relase, relase, version-3.48.0, version-3.47.2, version-3.47.1, version-3.47.0, version-3.46.1, version-3.46.0, version-3.45.3, version-3.44.3, version-3.45.2, version-3.45.1, vesion-3.45.1, version-3.45.0, version-3.44.2, version-3.44.1, version-3.44.0, version-3.43.2, version-3.43.1, version-3.43.0, version-3.42.0, version-3.41.2, version-3.41.1, version-3.41.0, version-3.40.1, version-3.40.0, version-3.39.4, version-3.39.3, version-3.39.2, version-3.39.1, version-3.39.0
# 0338f53b 10-May-2022 drh <>

Fix a stale requirement mark.

FossilOrigin-Name: fcda7fb1f184a31a67572aae15f3cdcd60f8aac199106a7b0f90aca251ca7017


# d2b960cf 10-May-2022 drh <>

Fix a stale requirement mark.

FossilOrigin-Name: 3eda4030f73384abf18b97cd8a4606e10b23e382d1b72dff7526aebfde23e0af


Revision tags: version-3.38.5, version-3.38.4, relese, version-3.38.3
# d44f8b23 07-Apr-2022 drh <>

Improved technique for parsing the ON and USING clauses of a join is faster
and uses less memory.

FossilOrigin-Name: 158156a3e3d50042cafc75dea3aaaa68b1f2efb9c3d178518ea6e68e32e0d21c


Revision tags: version-3.38.2, version-3.38.1, version-3.38.0, version-3.37.2, version-3.37.1, version-3.37.0, version-3.36.0
# cbe83495 16-Jun-2021 drh <>

Adjustments to requirement markings in comments. No changes to code.

FossilOrigin-Name: be00e45b723adf64bc78927dc12de3116fd04912a52e5c105a52f235c57698f5


Revision tags: version-3.35.5, version-3.35.4, version-3.35.3, same-as-3.35.3, version-3.35.2, version-3.35.1, version-3.35.0, patch, version-3.34.1, version-3.34.0, version-3.33.0, version-3.32.3, version-3.32.2, version-3.32.1, version-3.32.0, version-3.31.1, version-3.31.0, version-3.30.1, version-3.30.0, version-3.29.0, version-3.28.0, version-3.27.2, version-3.27.1, version-3.27.0
# 3a07548b 22-Dec-2018 drh <[email protected]>

Remove unnecessary whitespace from testcase result strings.

FossilOrigin-Name: ad70f03ceda74163903d247a975666b35fae722a27c48dd3efd31c1164b5627e


Revision tags: version-3.26.0, version-3.25.3, version-3.25.2, version-3.25.1, version-3.25.0
# 280c894b 05-Jun-2018 dan <[email protected]>

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.

FossilOrigin-Name: dce2dfbe1590deb3ef56

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.

FossilOrigin-Name: dce2dfbe1590deb3ef5661230ae2d232bd492441195defbf698ac56f9629211c

show more ...


Revision tags: version-3.24.0, version-3.23.2, version-3.23.1, version-3.23.0
# 2589787c 20-Mar-2018 drh <[email protected]>

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.

FossilOrigin-Name: 5b7abecc7ab8ccbbb8cb5e0f672e67625c25

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.

FossilOrigin-Name: 5b7abecc7ab8ccbbb8cb5e0f672e67625c2555ad03442efbf34cb395f5bb71a8

show more ...


Revision tags: version-3.22.0, version-3.21.0, version-3.20.1, version-3.19.4, version-3.20.0, version-3.18.2, version-3.18.1, version-3.19.3, version-3.19.2, version-3.19.1, version-3.19.0, version-3.18.0, version-3.17.0, version-3.16.2, version-3.16.1, version-3.16.0, version-3.15.2
# 50da6635 22-Nov-2016 drh <[email protected]>

Update requirement marks to reflect changes in wording in the documentation.
No changes to code.

FossilOrigin-Name: f5ac98efb5d5f7751c5c560bed9c7885e60ac4bc


Revision tags: version-3.15.1, version-3.15.0, version-3.14.2, version-3.14.1, version-3.14.0, version-3.13.0, version-3.12.2, version-3.12.1, version-3.9.3, version-3.12.0, version-3.11.1, version-3.11.0, version-3.10.2, version-3.10.1, version-3.10.0, version-3.9.2, version-3.9.1, version-3.9.0, version-3.8.11.1, version-3.8.11, version-3.8.10.2, version-3.8.10.1, version-3.8.10, version-3.8.9, version-3.8.8.3, version-3.8.8.2, version-3.8.8.1, version-3.8.8, version-3.8.7.4, version-3.8.7.3, version-3.8.7.2, version-3.8.7.1, version-3.8.6.1, version-3.8.7, version-3.8.6, version-3.8.5, version-3.8.4.3, version-3.8.4.2, version-3.8.4.1, version-3.8.4, version-3.8.3.1, version-3.8.3
# bb44b3de 30-Jan-2014 drh <[email protected]>

Update evidence marks on SELECT tests. Comment changes only.
No changes to code or tests.

FossilOrigin-Name: 1973d80e474cb95d053e04415b22154897d4d710


# 9a2555f5 30-Jan-2014 drh <[email protected]>

Fix requirements marks only. No changes to code or tests.

FossilOrigin-Name: 4a34378b9b02e463081729186dcb9b0404dbcd06


# a88aca54 30-Jan-2014 drh <[email protected]>

Update a requirement mark and add some additional test cases to cover
the requirement associated with ORDER BY and LIMIT on compound SELECT
statements.

FossilOrigin-Name: 8560091e85f2f99a24810648868

Update a requirement mark and add some additional test cases to cover
the requirement associated with ORDER BY and LIMIT on compound SELECT
statements.

FossilOrigin-Name: 8560091e85f2f99a24810648868bf2e081c32698

show more ...


# a820c05a 27-Jan-2014 drh <[email protected]>

Update some requirements marks to conform with improvements
in the documentation.

FossilOrigin-Name: be1acb610f7e594b417dd8409b7a7aa8f3af5f77


Revision tags: version-3.8.2, version-3.8.1
# 186ad8cc 08-Oct-2013 drh <[email protected]>

Further refinement of the idea of multiplying run-time cost estimates by
the estimated row size.

FossilOrigin-Name: 18bd6ba96d19de6047baebfa15b1f739577c9ec4


Revision tags: version-3.8.0.2, version-3.8.0.1, version-3.8.0
# 39759747 02-Aug-2013 drh <[email protected]>

Updates to requirements marks. No code changes.

FossilOrigin-Name: 213020769f310aec1591d97756b53891d0b64005


Revision tags: version-3.7.17, version-3.7.16.2, version-3.7.16.1
# 48864df9 21-Mar-2013 mistachkin <[email protected]>

Many spelling fixes in comments. No changes to code.

FossilOrigin-Name: 6f6e2d50941e444ebc83604daddcc034137a05b7


Revision tags: version-3.7.16, version-3.7.15.2, version-3.7.15.1, version-3.7.15, version-3.7.14.1
# 5343b2d4 27-Sep-2012 drh <[email protected]>

More test cases an bug fixes for the ORDER BY optimization of joins. All
veryquick tests now pass.

FossilOrigin-Name: 0d573320057b0903a5589cabfb1b1ece1c57958e


# 3f4d1d1b 15-Sep-2012 drh <[email protected]>

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.

FossilOrigin-Name: cfaa7bc12847a7006ccc93815f

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.

FossilOrigin-Name: cfaa7bc12847a7006ccc93815f2395ad5259744a

show more ...


Revision tags: version-3.7.14, version-3.7.13, version-3.7.12.1, version-3.7.12, mountain-lion, version-3.7.11
# 2f56da3f 13-Feb-2012 dan <[email protected]>

Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.

FossilOrigin-Name: 76bb649ee2633226324130f5898622c348f93769


# 94a6d998 02-Feb-2012 drh <[email protected]>

Fix a problem with NULL handling in aggregate min/max when returning
values from the row containing the min or max.

FossilOrigin-Name: f27c7b4fb193126548e6a620ac89664d1efa3856


# 7a95789c 02-Feb-2012 drh <[email protected]>

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.

FossilOrigin-Name: adb29232b659c5332b6841776372407fcc

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.

FossilOrigin-Name: adb29232b659c5332b6841776372407fcc350b08

show more ...


Revision tags: version-3.7.10
# f4692ccc 30-Dec-2011 drh <[email protected]>

Fix up requirements marks for syntax diagrams to reflect the new and improved
GIF renderings.

FossilOrigin-Name: 1bb23a3b5297e07e08c26362f71aef0c5b978875


Revision tags: version-3.7.9, version-3.7.8
# 38cc40c2 30-Jun-2011 dan <[email protected]>

Experimental changes to improve optimization of DISTINCT queries.

FossilOrigin-Name: f7ba0219ef2f235543c258be736955d91ca5ecce


Revision tags: version-3.7.7.1, version-3.7.7
# 1a475194 20-Jun-2011 drh <[email protected]>

Fix typos in evidence marks on tests.

FossilOrigin-Name: bd980be471b185e2dc45875804103d5afc8f78cf


Revision tags: version-3.7.6.3, version-3.7.6.2, version-3.7.6.1, version-3.7.6, version-3.7.5, version-3.7.4
# 07bf3918 02-Nov-2010 drh <[email protected]>

Add evidence marks for the sqlite3_blob_reopen() interface. Fix compiler
warnings in test1.c. Fix incorrect evidence marks on e_select.tcl.

FossilOrigin-Name: 3771faa88eda3eb91264ce0982e22f53596ab

Add evidence marks for the sqlite3_blob_reopen() interface. Fix compiler
warnings in test1.c. Fix incorrect evidence marks on e_select.tcl.

FossilOrigin-Name: 3771faa88eda3eb91264ce0982e22f53596abd4b

show more ...


# e4c2d054 24-Sep-2010 dan <[email protected]>

Modify some evidence tags to match updated gifs.

FossilOrigin-Name: f44de500be5130d5ad800759acb76377eaa92367


12