History log of /sqlite-3.40.0/test/e_fkey.test (Results 1 – 25 of 40)
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
# 4d7f335e 21-Jan-2022 drh <>

Update evidence marks for the latest changes to the documentation.

FossilOrigin-Name: 19247e919fab9748cae561cb12c4c3c106064390a37e32e724d9a9066cfaff8e


Revision tags: version-3.37.2, version-3.37.1, version-3.37.0
# 2841abed 05-Nov-2021 dan <Dan Kennedy>

Fix a couple of problems with test scripts and SQLITE_OMIT_ALTERTABLE builds.

FossilOrigin-Name: 3ab5414d337536acad5675a3f1ca10e1ca925f0e7182def604b8b7a8fb53bf5a


Revision tags: 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
# 0ca23aa4 12-Mar-2021 drh <>

Fix broken requirement marks.

FossilOrigin-Name: 98d67152849e062c6de45b0e526daffc3d6cb29d563d40664a8d7140119a30b2


Revision tags: patch, version-3.34.1, version-3.34.0, version-3.33.0
# d43c0cbe 08-Aug-2020 drh <[email protected]>

Update requirement marks due to wording improvements in the documentation.

FossilOrigin-Name: bf875a1c7fcb2b41a4d3bd741bb358a635b869d0b6fc9d24385cd5779686d78c


Revision tags: version-3.32.3, version-3.32.2, version-3.32.1, version-3.32.0
# 2629adc7 15-May-2020 dan <[email protected]>

Update test file e_fkey.test to account for the fact that new columns with REFERENCE clauses and non-NULL default values may now be added using ALTER TABLE if the table is empty.

FossilOrigin-Name:

Update test file e_fkey.test to account for the fact that new columns with REFERENCE clauses and non-NULL default values may now be added using ALTER TABLE if the table is empty.

FossilOrigin-Name: 4087fce97252beda2456164afe9508f952fc9fe4be68ad0e9b330569a78e42f2

show more ...


Revision tags: 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
# 8e2d4ad3 17-Nov-2018 dan <[email protected]>

Fix a problem in test script e_fkey.test.

FossilOrigin-Name: acfd0a05a8957728c1f0eb936f4121ce26f291f20dd583bd57ce2bb271617d3f


Revision tags: version-3.25.3, version-3.25.2, version-3.25.1, version-3.25.0, version-3.24.0
# d3e17ffb 29-May-2018 dan <[email protected]>

Fix some test script issues caused by recent EXPLAIN QUERY PLAN enhancements.

FossilOrigin-Name: f808e22831c33bfe3d0dd44e209f64d527c23ca7c72be7c694736535afee1317


Revision tags: 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
# 923260c8 14-Jul-2017 drh <[email protected]>

Minor updates to requirements marks and documention. No changes to code.

FossilOrigin-Name: 8f6dd5e2907d6df230fcbceadd226496bcc35a33c117da58215f7d333c1cc7b8


Revision tags: 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
# fb04a36c 21-Sep-2016 drh <[email protected]>

Fix obsolete requirements marks. Add new tests for VACUUM of attached
databases.

FossilOrigin-Name: 2b44f9aa7d4e2089dacd6bfcf526dae9309b7af3


Revision tags: 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
# 1f8bb4b0 26-Apr-2014 drh <[email protected]>

Update requirements marks to fix typos in the requirements text.
No changes to code.

FossilOrigin-Name: f5a263658187250044afc1a74000e6f6962733ca


Revision tags: 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
# afcf9bd8 23-Jan-2014 dan <[email protected]>

Modifications to test files to omit any tests that intentionally access out-of-bounds locations in clang -fsanitize=address builds.

FossilOrigin-Name: f4a701d55f5c4e1e62ed64b779ad4fff89dd31b7


Revision tags: 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
# 5822d6fe 10-Jun-2013 drh <[email protected]>

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the
wherecosttest tool. Other fixes to logarithm cost.

FossilOrigin-Name: aa580e368e3c398b8377b80342dfdd906324c248


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
# 9148defa 17-Dec-2012 drh <[email protected]>

Enhance the error message for "foreign key mismatch" to include the names of
the child and parent tables. Begin adding test cases for
PRAGMA foreign_key_check. Make sure PRAGMA foreign_key_check g

Enhance the error message for "foreign key mismatch" to include the names of
the child and parent tables. Begin adding test cases for
PRAGMA foreign_key_check. Make sure PRAGMA foreign_key_check gets all
necessary table locks.

FossilOrigin-Name: 0f9963526c299757ff95c153fb05a67cddb6af28

show more ...


Revision tags: 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
# 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


Revision tags: 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
# 4bc39fa1 13-Nov-2010 dan <[email protected]>

Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans.

FossilOrigin-Name: 6611b76b0296875fb99

Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans.

FossilOrigin-Name: 6611b76b0296875fb9903b25dfaa783a9c12eaa1

show more ...


# 47eb16d4 11-Nov-2010 dan <[email protected]>

Modifications to test cases to account for new EXPLAIN QUERY PLAN output.

FossilOrigin-Name: 30904ef8412348464e893e9e1551ef22cad24a3e


Revision tags: experimental, version-3.7.2
# 9ede952a 31-Dec-2009 drh <[email protected]>

Change evidence marks to track requirement number changes in the foreign-key
documentation.

FossilOrigin-Name: 6b4fcd81e775ff4c5d7bc454378555cf73cf5772


# bf3e3a06 21-Dec-2009 dan <[email protected]>

Change many comments in e_fkey.test to include the full text of the corresponding statement in foreignkeys.html.

FossilOrigin-Name: 4b489ecb250ea0e80d5bf8806f07259e1107f8ad


# 27298ffd 16-Dec-2009 dan <[email protected]>

Modify some comments in e_fkey.test. No changes to code or tests.

FossilOrigin-Name: 1ba4f412325fc2ce552ad7feecf93891f7f95059


# 8e9f6aed 28-Nov-2009 dan <[email protected]>

Add a test case for creating an FTS3 table with no module arguments or opening/closing brackets in the CREATE VIRTUAL TABLE statement.

FossilOrigin-Name: a9cba7ea0a06efa7a63a3069b219cc30fb127e98


# c473b48b 27-Nov-2009 dan <[email protected]>

Change the test numbers in e_fkey.test so that they are in order.

FossilOrigin-Name: ca73be44cc2dab5edc48292c467adc8362ddf645


12