History log of /sqlite-3.40.0/test/intpkey.test (Results 1 – 25 of 34)
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
# 8210233c 20-Mar-2021 drh <>

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

FossilOrigin-Name: 50fbd532602d2c316813046ed6be8be2991c281eb5f295c4c28520a0de73862c


Revision tags: 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
# 3eead270 07-May-2016 drh <[email protected]>

Fix typo in the intpkey-17.2 test.

FossilOrigin-Name: a45fda657d987f5c923d141584841a6c62dfb504


# f09c4823 06-May-2016 drh <[email protected]>

Simplification to the logic used to decide between OP_Seek and OP_NotExists.
Use OP_NotExists for both DELETE and UPDATE.

FossilOrigin-Name: 3a695263183303e3f64eb2320752d0fdef53eaf2


# bcf6884a 06-May-2016 drh <[email protected]>

In the WHERE generator, when building code for a DELETE operation, make sure
that seeks to the main table are not deferred.
This is a better fix for the [16c9801ceba49] bug than the previous.

Fossil

In the WHERE generator, when building code for a DELETE operation, make sure
that seeks to the main table are not deferred.
This is a better fix for the [16c9801ceba49] bug than the previous.

FossilOrigin-Name: 150dd09ebd7b17234a79e1811a0fae8b0a7a40d5

show more ...


# 70077d17 06-May-2016 drh <[email protected]>

Do not scan indexes that have the integer primary key as their left-most
column. This fixes the crash of ticket [16c9801ceba] but it seems like
the wrong fix. More investigation needed.

FossilOrig

Do not scan indexes that have the integer primary key as their left-most
column. This fixes the crash of ticket [16c9801ceba] but it seems like
the wrong fix. More investigation needed.

FossilOrigin-Name: 50312273ffaf1bd4bfdc73865fa0b19166968429

show more ...


Revision tags: version-3.12.2
# a6dddd9b 18-Apr-2016 drh <[email protected]>

Remove quotes from identifiers used as datatype names in a CREATE TABLE
statement. Fix for ticket [7d7525cb01b68]

FossilOrigin-Name: eba27d4d17a76884292667d570d542e580ee3e77


Revision tags: version-3.12.1, version-3.9.3, version-3.12.0
# 892ffcc7 16-Mar-2016 drh <[email protected]>

Fix the query planner so that it is able to use the integer primary key
from an index as part of a multi-column constraint.

FossilOrigin-Name: 96ea9909429f0b3b4a67002e8340ae3f7dc0b73f


Revision tags: 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, version-3.8.2
# f9c8ce3c 05-Nov-2013 drh <[email protected]>

Standardize the error messages generated by constraint failures to a format
of "$TYPE constraint failed: $DETAIL". This involves many changes to the
expected output of test cases.

FossilOrigin-Name

Standardize the error messages generated by constraint failures to a format
of "$TYPE constraint failed: $DETAIL". This involves many changes to the
expected output of test cases.

FossilOrigin-Name: 54b221929744b1bcdbcc2030fef2e510618afd41

show more ...


Revision tags: version-3.8.1, 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, version-3.7.16, version-3.7.15.2, version-3.7.15.1, version-3.7.15, version-3.7.14.1
# 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, 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
# 21de2e75 29-Nov-2007 danielk1977 <[email protected]>

When using an index to scan a database table, read column data from the index in preference to the table. This increases the likelihood that the table will not be required at all. (CVS 4580)

FossilO

When using an index to scan a database table, read column data from the index in preference to the table. This increases the likelihood that the table will not be required at all. (CVS 4580)

FossilOrigin-Name: 061608c72ac0a96eacf3b64d638235e4739f96ba

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


# f4f8fd51 31-Mar-2005 drh <[email protected]>

Make sure integer primary keys larger than 2^31 are handled
properly. Ticket #1188. (CVS 2436)

FossilOrigin-Name: 1d04c2ab299430959b8a193d4679cbc4c0be31a4


# 3fdf8266 22-Feb-2005 danielk1977 <[email protected]>

Fix bug reported on the mailing list for WHERE clauses like (rowid<'2'). (CVS 2357)

FossilOrigin-Name: b323f0f2832ac5d225d880db6f56314d2f766a25


# a71aa001 03-Nov-2004 drh <[email protected]>

More work on optionally removing unused features at compile-time. (CVS 2049)

FossilOrigin-Name: a82980fd70285820c64b42393ef85a9e21addc5d


# b45bb9f1 18-Oct-2004 drh <[email protected]>

Fix typos in the names of some regression tests. Ticket #962. (CVS 2023)

FossilOrigin-Name: 77542beb31349b85bdf404c46980da346dde3266


# 9d213ef0 30-Jun-2004 drh <[email protected]>

Improve test coverage of util.c (CVS 1773)

FossilOrigin-Name: 68ac32213766c5e83de54373b90030a458538017


# 54bbdf4f 30-Jun-2004 drh <[email protected]>

Some extra tests for the OP_MustBeInt opcode. (CVS 1769)

FossilOrigin-Name: b9d5858ca171e11afaeb9712efa0fc1a0e79102b


# d8123366 12-Jun-2004 danielk1977 <[email protected]>

(1) Modifications to the user-function interface and (2) Internal changes
to automatically created indices. (CVS 1575)

FossilOrigin-Name: 5903f53828b5d282b33e27813417e4317c9ecf0b


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

Remove the COPY command. (CVS 1477)

FossilOrigin-Name: 287f86731c71401dbac098e08357367b4f8e5a43


# ed717fe3 15-Jun-2003 drh <[email protected]>

Enhance the "PRAGMA integrity_check" command to verify that all indices are
correctly constructed. New calls to integrity_check are made in the test
suite. These changes are intended to prevent any

Enhance the "PRAGMA integrity_check" command to verify that all indices are
correctly constructed. New calls to integrity_check are made in the test
suite. These changes are intended to prevent any future problems such
as seen in ticket #334. (CVS 1024)

FossilOrigin-Name: c9734c27074d2039a1896a8c6965c08d03711b13

show more ...


# 9468c7f4 07-Mar-2003 drh <[email protected]>

Do not allow an empty string to be inserted into an INTEGER PRIMARY KEY. (CVS 877)

FossilOrigin-Name: 2aba40bea5fc1c4aef8cfd4c790d40808821ca14


# 483750ba 29-Jan-2003 drh <[email protected]>

Better error messages on constraint violations. Additional tests and bug fixes
for the callback-free API. (CVS 854)

FossilOrigin-Name: ccc82f1ab4539a60ee5cc2625743c5389f9ccd8e


# 3d037a91 15-Aug-2002 drh <[email protected]>

Fixes and test improvements resulting from code coverage testing. (CVS 716)

FossilOrigin-Name: 66a0f6a8e25e3eeed78eba4b63b097f921c79d99


# 27a32783 19-Jun-2002 drh <[email protected]>

Fix for ticket #75: Autoincrement INTEGER PRIMARY KEY fields on an INSERT
even if the data is coming from a SELECT statement. (CVS 630)

FossilOrigin-Name: d599f75b659809a6e5eee09b0e9e6e90bde5af1e


12