History log of /sqlite-3.40.0/test/subquery.test (Results 1 – 25 of 25)
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
# 7d44b22d 16-Jan-2022 drh <>

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

FossilOrigin-Name: 4883776669ee2f2310ea82b0d6df4d008eebaa7cb252102539cf21a635402ebb


# 8efc6a8c 12-Jan-2022 drh <>

When the result of a subquery is to be stored in a register and that
subquery has an ORDER BY clause and an OFFSET, NULL out the destination
register before starting the ORDER BY so that the register

When the result of a subquery is to be stored in a register and that
subquery has an ORDER BY clause and an OFFSET, NULL out the destination
register before starting the ORDER BY so that the register will be set
correctly even if the OFFSET is larger than the number of output rows.
Fix for the problem reported in
[forum:/forumpost/0ec80f12d02acb3f|forum post 0ec80f12d02acb3f].

FossilOrigin-Name: 9282bcde301cee2a5c3c068b5b0b7ce992c155ece894413a6a9a51a81e4133fd

show more ...


Revision tags: 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, 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
# dfb5e1cb 21-Apr-2015 drh <[email protected]>

Make sure the datatype and collating sequence of transients tables are
not initialized more than once. Otherwise a memory leak results.

FossilOrigin-Name: 9e6beda2c8d879e438ee933e658f860d6eb42a20


Revision tags: 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, version-3.8.2, version-3.8.1
# 165674d8 04-Oct-2013 drh <[email protected]>

Fix test cases so that they work when the query planner uses index size
estimates to determine whether or not to try an covering index scan.

FossilOrigin-Name: 2f394de88f23dacd3c61e586a4214ffc6f927d

Fix test cases so that they work when the query planner uses index size
estimates to determine whether or not to try an covering index scan.

FossilOrigin-Name: 2f394de88f23dacd3c61e586a4214ffc6f927d97

show more ...


Revision tags: version-3.8.0.2, version-3.8.0.1, version-3.8.0
# 7c171098 03-Jun-2013 drh <[email protected]>

Remove more vestiges of sqlite_query_plan from the test cases.

FossilOrigin-Name: eb27086e8a8a4d5fcb2ea358256a555e34339423


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, version-3.7.14, version-3.7.13, version-3.7.12.1
# 3a8c4be7 21-May-2012 drh <[email protected]>

Candidate fix for the nested aggregate query problem of ticket
[c2ad16f997ee9c8e].

FossilOrigin-Name: f3dd1fafd4718558de1f06139419a8c560d727f5


Revision tags: version-3.7.12
# 374fdce4 17-Apr-2012 drh <[email protected]>

Improved handling of aggregate subqueries within an aggregate query.

FossilOrigin-Name: 430bb59d798286a86c351de92c429345f016b3f0


Revision tags: 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
# e2f02bac 09-Jan-2009 drh <[email protected]>

Increased test coverage. (CVS 6147)

FossilOrigin-Name: 45bb5703d7ef5e835b43a6fa7ee2a2d96db76939


# 93a960a0 10-Jul-2008 drh <[email protected]>

Remove unused code. Test coverage enhancements. Modify the algorithm used
to select column names for VIEWs of joins so that the constructed column
names omits the underlying table names. (CVS 5386)

Remove unused code. Test coverage enhancements. Modify the algorithm used
to select column names for VIEWs of joins so that the constructed column
names omits the underlying table names. (CVS 5386)

FossilOrigin-Name: 636cd723296a8b1709011fdd99b236ffddf3f1b0

show more ...


# 78d1ef1a 18-Sep-2007 drh <[email protected]>

Add disabled test cases for ticket #2652. We will enable these test cases
after #2652 is fixed. The fix will be difficult and will probably take
a while. On the other hand, correlated aggregate qu

Add disabled test cases for ticket #2652. We will enable these test cases
after #2652 is fixed. The fix will be difficult and will probably take
a while. On the other hand, correlated aggregate queries have never
worked in SQLite and the problem is just now coming to light, so it is
probably not a pressing issue. (CVS 4435)

FossilOrigin-Name: 5c41619e292699c72231cff10e26dfbe9a363a00

show more ...


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

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

FossilOrigin-Name: 3a54a33dcb7e765ee3773397407e8929a8cfe1a9


# 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 ...


# 87abf5c0 25-Aug-2005 drh <[email protected]>

When the left-hand side of an IN operator is constant and the right-hand
side is a SELECT, recognize that the IN operator is not constant.
Ticket #1380. (CVS 2624)

FossilOrigin-Name: fc9e04609b6968f

When the left-hand side of an IN operator is constant and the right-hand
side is a SELECT, recognize that the IN operator is not constant.
Ticket #1380. (CVS 2624)

FossilOrigin-Name: fc9e04609b6968fc5039a6f9f808aac681f4fc41

show more ...


# 7ec764a2 21-Jul-2005 drh <[email protected]>

Add comments to test cases. Improvements to the query plan test variable. (CVS 2555)

FossilOrigin-Name: ef3a157f469d72cbd2f713f997598ddf47f340d2


# fe05af87 21-Jul-2005 drh <[email protected]>

In where.c, split out the code that selects an index into a separate
subroutine. (CVS 2554)

FossilOrigin-Name: c30cbba9ead1b4d07f225b1e8a65d5d5230ea45d


# 15ccce1c 23-May-2005 drh <[email protected]>

Make sure that the use of a double-quoted string literal does not trick
the optimizer into using a correlated subquery when a static
subquery would suffice. (CVS 2477)

FossilOrigin-Name: ef4059e3afa

Make sure that the use of a double-quoted string literal does not trick
the optimizer into using a correlated subquery when a static
subquery would suffice. (CVS 2477)

FossilOrigin-Name: ef4059e3afa1a61a9e59df00cdfedc57d8df9fec

show more ...


# 2b6d46b9 14-Feb-2005 danielk1977 <[email protected]>

Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329)

FossilOrigin-Name: 41d2214b83dd52acdda64a50d0c1ef16009d06d0


# a1cb183d 12-Feb-2005 danielk1977 <[email protected]>

Fix a problem with sub-queries and the flattening optimization. Also handle an extra case of database corruption. (CVS 2324)

FossilOrigin-Name: f7858d8830cdd0f57b8f9bc73068d29a7062b8ac


# 24c8ab80 09-Feb-2005 danielk1977 <[email protected]>

Document SQLITE_DEFAULT_CACHE_SIZE and SQLITE_DEFAULT_TEMP_CACHE_SIZE macros. (CVS 2320)

FossilOrigin-Name: ddcea6f8891b02e64f96591af161feb55c00a72c


# a58fdfb1 08-Feb-2005 danielk1977 <[email protected]>

Fix for correlated subqueries where the parent is an aggregate. Ticket #1105. (CVS 2318)

FossilOrigin-Name: f0d3ca10c5bccf8fca7143028ebb3e604c0e3f20


# 142bdf40 30-Jan-2005 danielk1977 <[email protected]>

Respect collation sequences in views. Ticket #1088. (CVS 2291)

FossilOrigin-Name: 9843c0dd795ceda3c260986f95b101a0cbc7cf64


# b3bce662 29-Jan-2005 danielk1977 <[email protected]>

Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286)

FossilOrigin-Name: b1b50f315873a8614920d1e3af4a07fb29a7ff6a


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

Improve test coverage for minimum feature builds. (CVS 2254)

FossilOrigin-Name: 9c4d0e13e8c5f3fc4d7fd8f495898372293f7fad


# 801845fb 21-Jan-2005 drh <[email protected]>

Add a new test file for subqueries. (CVS 2250)

FossilOrigin-Name: de8ee3a29e1aafcfa05841cb44da0a05f0579596