SQLite

All files named ”test/e_fkey.test”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/e_fkey.test

2022-01-21
19:26
[feeba6238a] part of check-in [19247e919f] Update evidence marks for the latest changes to the documentation. (check-in: [19247e919f] user: drh branch: trunk, size: 98346)
2021-11-05
10:43
[ee321dbca3] part of check-in [3ab5414d33] Fix a couple of problems with test scripts and SQLITE_OMIT_ALTERTABLE builds. (check-in: [3ab5414d33] user: dan branch: trunk, size: 98345)
2021-03-20
15:11
[351c7b989e] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 98264)
2021-03-12
13:49
[a2907f749c] part of check-in [98d6715284] Fix broken requirement marks. (check-in: [98d6715284] user: drh branch: trunk, size: 98318)
2020-08-08
15:40
[0b458b85f1] part of check-in [bf875a1c7f] Update requirement marks due to wording improvements in the documentation. (check-in: [bf875a1c7f] user: drh branch: trunk, size: 98317)
2020-05-15
13:52
[b497feb7c4] part of check-in [4087fce972] 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. (check-in: [4087fce972] user: dan branch: trunk, size: 98317)
2018-11-17
13:08
[2febb2084a] part of check-in [acfd0a05a8] Fix a problem in test script e_fkey.test. (check-in: [acfd0a05a8] user: dan branch: trunk, size: 98256)
2018-05-29
14:06
[9778696ef9] part of check-in [f808e22831] Fix some test script issues caused by recent EXPLAIN QUERY PLAN enhancements. (check-in: [f808e22831] user: dan branch: trunk, size: 98174)
2017-07-14
13:24
[dcdc6ad26b] part of check-in [8f6dd5e290] Minor updates to requirements marks and documention. No changes to code. (check-in: [8f6dd5e290] user: drh branch: trunk, size: 97989)
2016-09-21
18:18
[54cc0046d2] part of check-in [2b44f9aa7d] Fix obsolete requirements marks. Add new tests for VACUUM of attached databases. (check-in: [2b44f9aa7d] user: drh branch: trunk, size: 97996)
2014-04-26
19:23
[a1783fe1f7] part of check-in [f5a2636581] Update requirements marks to fix typos in the requirements text. No changes to code. (check-in: [f5a2636581] user: drh branch: trunk, size: 97983)
2014-01-23
14:44
[6305973775] part of check-in [f4a701d55f] Modifications to test files to omit any tests that intentionally access out-of-bounds locations in clang -fsanitize=address builds. (check-in: [f4a701d55f] user: dan branch: trunk, size: 98001)
2013-11-05
13:33
[d83a04478b] part of check-in [54b2219297] 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. (check-in: [54b2219297] user: drh branch: omit-rowid, size: 97630)
2013-06-10
23:30
[17cfb40002] part of check-in [aa580e368e] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e368e] user: drh branch: nextgen-query-plan-logcost, size: 97603)
2013-03-21
21:20
[79a985d953] part of check-in [6f6e2d5094] Many spelling fixes in comments. No changes to code. (check-in: [6f6e2d5094] user: mistachkin branch: trunk, size: 97730)
2012-12-17
20:40
[89a2ff734a] part of check-in [0f9963526c] 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. (check-in: [0f9963526c] user: drh branch: foreign-key-check, size: 97733)
2012-09-15
18:45
[a79ab1d321] part of check-in [cfaa7bc128] 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. (check-in: [cfaa7bc128] user: drh branch: fullscan-covering-index, size: 97113)
2012-02-13
10:00
[057eed81a4] part of check-in [76bb649ee2] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649ee2] user: dan branch: trunk, size: 97055)
2011-02-12
14:23
[35a4ec281d] part of check-in [f2a8b5ccfb] Fix the expected output on tests so that it corresponds to the new query planner results. All of veryquick.test is now passing with SQLITE_ENABLE_STAT2. (check-in: [f2a8b5ccfb] user: drh branch: branch-3.7.2, size: 97077)
2010-11-13
16:42
[38039b840a] part of check-in [6611b76b02] 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. (check-in: [6611b76b02] user: dan branch: experimental, size: 97087)
2010-11-11
10:36
[64e6932709] part of check-in [30904ef841] Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: [30904ef841] user: dan branch: experimental, size: 97072)
2009-12-31
15:51
[6721a741c6] part of check-in [6b4fcd81e7] Change evidence marks to track requirement number changes in the foreign-key documentation. (check-in: [6b4fcd81e7] user: drh branch: trunk, size: 96803)
2009-12-21
08:53
[6c64ef13b3] part of check-in [4b489ecb25] Change many comments in e_fkey.test to include the full text of the corresponding statement in foreignkeys.html. (check-in: [4b489ecb25] user: dan branch: trunk, size: 96723)
2009-12-16
14:49
[8bc4246524] part of check-in [1ba4f41232] Modify some comments in e_fkey.test. No changes to code or tests. (check-in: [1ba4f41232] user: dan branch: trunk, size: 89233)
2009-11-28
15:35
[fd1fcf89ba] part of check-in [a9cba7ea0a] Add a test case for creating an FTS3 table with no module arguments or opening/closing brackets in the CREATE VIRTUAL TABLE statement. (check-in: [a9cba7ea0a] user: dan branch: trunk, size: 83857)
2009-11-27
18:31
[f0fbfbcc01] part of check-in [ca73be44cc] Change the test numbers in e_fkey.test so that they are in order. (check-in: [ca73be44cc] user: dan branch: trunk, size: 84173)
2009-10-22
00:20
[af2750eddb] part of check-in [e51af74c3a] Add markings on test evidence for R-30323-21917. (check-in: [e51af74c3a] user: drh branch: trunk, size: 83841)
2009-10-21
13:48
[27a4c2d26c] part of check-in [0441d28e84] Add evidence marks to parse.y. Fix a broken evidence link in e_fkey.tcl. (check-in: [0441d28e84] user: drh branch: trunk, size: 83774)
2009-10-13
10:39
[fb71d3256b] part of check-in [c85e58743a] Add further test cases to e_fkey.test. (check-in: [c85e58743a] user: dan branch: trunk, size: 83774)
2009-10-12
18:57
[9f42822f9c] part of check-in [5633cb2b5b] Add more test cases to e_fkey.test. (check-in: [5633cb2b5b] user: dan branch: trunk, size: 75688)
16:02
[372ed0d546] part of check-in [171c671385] Fix some mappings from e_fkey.test. (check-in: [171c671385] user: dan branch: trunk, size: 67482)
15:25
[f2ad0c2ed6] part of check-in [a2ca9f1a7a] Update e_fkey.test to match the latest version of foreignkeys.html. (check-in: [a2ca9f1a7a] user: dan branch: trunk, size: 67482)
11:27
[b9bf4788af] part of check-in [ffa6207dd7] Extra test cases mapped to statements in foreignkeys.html. (check-in: [ffa6207dd7] user: dan branch: trunk, size: 66548)
08:41
[f9fcab098e] part of check-in [d61cc0e1a1] Add further test cases to e_fkey.test. (check-in: [d61cc0e1a1] user: dan branch: trunk, size: 61425)
2009-10-10
15:49
[4eed4c548d] part of check-in [5ec07feea4] Add tests to e_fkey.test. (check-in: [5ec07feea4] user: dan branch: trunk, size: 49818)
14:29
[543c1a0997] part of check-in [89c548acf4] Update requirement text for sqlite3_open_blob(). Update evidence comment in e_fkey.test to conform to the latest requirement phrasing. (check-in: [89c548acf4] user: drh branch: trunk, size: 37665)
2009-10-09
18:16
[5106b8fb08] part of check-in [e391dfe79d] Add test cases to e_fkey.test. (check-in: [e391dfe79d] user: dan branch: trunk, size: 37574)
2009-10-08
19:02
[9ad5b376c9] part of check-in [a2fb7902c0] Test a couple of the examples in foreignkeys.html. (check-in: [a2fb7902c0] user: dan branch: trunk, size: 19517)
17:42
[87a5d48261] part of check-in [23e0f61a4f] Add test cases to test file "e_fkey.test". (check-in: [23e0f61a4f] user: dan branch: trunk, size: 16663)
11:57
[1fc787e91a] part of check-in [533703d78a] Add tests to test/e_fkey.test. (check-in: [533703d78a] user: dan branch: trunk, size: 10116)
2009-10-07
18:41
Added: [0f52031553] part of check-in [8382867956] Add some tests of statements in foreignkeys.html. (check-in: [8382867956] user: dan branch: trunk, size: 6127)