History log of /sqlite-3.40.0/test/limit.test (Results 1 – 25 of 37)
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, version-3.38.5, version-3.38.4, relese, version-3.38.3, 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, 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
# bc7819d1 05-Mar-2021 drh <>

Fix the processing of implied LIMIT clauses when flattening a compound
query.

FossilOrigin-Name: 90c6b9fcb0e15e2552fe5be53f8201f145bb535cc37b603d488eadf33438412b


Revision tags: 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, version-3.26.0, version-3.25.3, version-3.25.2, version-3.25.1, version-3.25.0, version-3.24.0, version-3.23.2, version-3.23.1, version-3.23.0, 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, 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
# 2af878ec 05-Mar-2015 drh <[email protected]>

New requirements marks on compound SELECT statements.

FossilOrigin-Name: e7991bc510f63f3594603a91f6f3b32e94d90e72


Revision tags: 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
# a22a75e5 21-Mar-2014 drh <[email protected]>

Fix the OFFSET clause so that it works correctly on queries that lack
a FROM clause. Ticket [07d6a0453d4ed8].

FossilOrigin-Name: 179ef81648b0ad557df78b7712f216b876b6fb65


Revision tags: version-3.8.4.1, version-3.8.4, version-3.8.3.1, version-3.8.3, version-3.8.2, version-3.8.1, version-3.8.0.2, version-3.8.0.1, version-3.8.0, version-3.7.17, version-3.7.16.2, version-3.7.16.1, version-3.7.16
# 28a3bcba 30-Jan-2013 drh <[email protected]>

Remove some debugging logic accidently left in the limit.test module.

FossilOrigin-Name: 7d346250e8a212880c4635a455cc9c98a1395c4c


# 547180ba 29-Jan-2013 drh <[email protected]>

Fix LIMIT and OFFSET so that they work and do not leak memory even on
complex queries involving deeply nested views of UNION ALL compounds.
Ticket [db4d96798da8]. Secondary to ticket [d58ccbb3f1b7].

Fix LIMIT and OFFSET so that they work and do not leak memory even on
complex queries involving deeply nested views of UNION ALL compounds.
Ticket [db4d96798da8]. Secondary to ticket [d58ccbb3f1b7].

FossilOrigin-Name: 497ee36cb8d07c936e6896135163c5cd7e94bdde

show more ...


Revision tags: version-3.7.15.2, version-3.7.15.1, version-3.7.15, version-3.7.14.1, version-3.7.14, version-3.7.13, version-3.7.12.1, version-3.7.12, mountain-lion, version-3.7.11, version-3.7.10, version-3.7.9, version-3.7.8, version-3.7.7.1, version-3.7.7, 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, experimental, version-3.7.2, fts3-refactor, cvs-to-fossil-cutover, version-3.6.15, version-3.6.10
# 701bb3b4 02-Aug-2008 drh <[email protected]>

Additional coverage testing. Fix a segfault following OOM in
sqltie3_load_extension(). (CVS 5523)

FossilOrigin-Name: f1e44eb323f05495cbae25113aebcc50d16b40df


# 24acd8f9 16-Jan-2008 danielk1977 <[email protected]>

Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715)

FossilOrigin-Name: 3a289b6d28bcf399845586b15f100d7c3a78b550


# 4b2688ab 20-Jun-2006 danielk1977 <[email protected]>

Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276)

FossilOrigin-Name: c6ea353bd9f5fe6c9cc3349d2034ada283f9c80e


# f42bacc2 26-Apr-2006 drh <[email protected]>

Get LIMIT 0 working on subqueries. Ticket #1784. (CVS 3177)

FossilOrigin-Name: 7f3ef7ddba22d69a23e656836ba76738c9652b4d


# 57bacb22 03-Mar-2006 drh <[email protected]>

Ignore leading spaces on text to numeric conversions. Ticket #1662.
Fixes to test cases broken by the recent changes to round(). (CVS 3118)

FossilOrigin-Name: cdca3383c54b33aeafbbdbbb4ae7c90796cf66

Ignore leading spaces on text to numeric conversions. Ticket #1662.
Fixes to test cases broken by the recent changes to round(). (CVS 3118)

FossilOrigin-Name: cdca3383c54b33aeafbbdbbb4ae7c90796cf66e5

show more ...


# 3bdca9c9 17-Jan-2006 danielk1977 <[email protected]>

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

FossilOrigin-Name: 3a54a33dcb7e765ee3773397407e8929a8cfe1a9


# 15007a99 08-Jan-2006 drh <[email protected]>

Get LIMIT and OFFSET working again for negative limits and offsets.
Ticket #1586. (CVS 2889)

FossilOrigin-Name: b2ac0be07ec76ab23b7e5b800c0bc62d0bc97f4b


# 3d1d95e6 08-Sep-2005 drh <[email protected]>

The SUM() aggregate function returns an integer result if all inputs are
integers. Any single non-integer input causes the result to be a floating
point value. (CVS 2669)

FossilOrigin-Name: 21adf4b

The SUM() aggregate function returns an integer result if all inputs are
integers. Any single non-integer input causes the result to be a floating
point value. (CVS 2669)

FossilOrigin-Name: 21adf4bd99e732650a1e8e9a1cc954126983a654

show more ...


# a2dc3b1a 05-Feb-2005 danielk1977 <[email protected]>

Allow expressions (including variables) in LIMIT and OFFSET clauses. Ticket #1096. (CVS 2316)

FossilOrigin-Name: 515e5033a5482f55e7edb66d69ff3da7e234ff2e


# e61b9f4f 21-Jan-2005 danielk1977 <[email protected]>

Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252)

FossilOrigin-Name: d4e19efcef68d834c55c7d496cdb3696d63a31a2


# 3e8c37e7 21-Jan-2005 danielk1977 <[email protected]>

Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251)

FossilOrigin-Name: bb0254ab14417f0ab40f10f37cb63a60507f070a


# 4489f9bd 20-Jan-2005 danielk1977 <[email protected]>

Fix some test scripts so that they work with a minimal build configuration. (CVS 2241)

FossilOrigin-Name: d267fb3ca3f31ee138c9613cb84e873ede7f141a


# 018d1a49 15-Jan-2005 drh <[email protected]>

Test coverage improvements. (CVS 2215)

FossilOrigin-Name: 92f9d2b2f480fccfa6e8b70a1d19058b92a4ea8f


# be5fd490 16-Dec-2004 drh <[email protected]>

Make sure LIMITs are handled correctly on UNION operators. Ticket #1035. (CVS 2166)

FossilOrigin-Name: ece0085f86bd715c95a6c59f41b4a97de2555faf


# 27c77438 22-Nov-2004 danielk1977 <[email protected]>

Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138)

FossilOrigin-Name: 007be591b7829f9ff38e4b14ba5a5043796c2ff3


# 0fa8ddbd 22-Nov-2004 danielk1977 <[email protected]>

Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132)

FossilOrigin-Name: 711e8d7695dfc74b3f1ee00591dcdda2cd7fc7d5


# 92febd92 20-Aug-2004 drh <[email protected]>

Tcl interface transfers values directly between SQLite and Tcl_Objs, without
at translation to strings. (CVS 1898)

FossilOrigin-Name: e97c331362545ce21117776c7b61d3488668f2bf


# bab39e13 19-Jul-2004 drh <[email protected]>

Refinements to the LIMIT patch (1823) for ticket #749. (CVS 1825)

FossilOrigin-Name: 9d4f43f030438b3e7358032de2e04132b80e04a8


# ea48eb2e 19-Jul-2004 drh <[email protected]>

LIMIT occurs after DISTINCT. Ticket #749. (CVS 1823)

FossilOrigin-Name: e6bc8aa80824a9156e78fc99b5ac7045b97d29c3


# 5f3b4ab5 27-May-2004 drh <[email protected]>

Remove the COPY command. (CVS 1477)

FossilOrigin-Name: 287f86731c71401dbac098e08357367b4f8e5a43


12