/ File History
Login

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

History of test/check.test

2019-07-17
14:34
When processing a BETWEEN or CASE expression, avoid transforming a node of the original expression into a TK_REGISTER node. Instead, take a copy and use it instead. Fix for [1be72aab9]. file: [e6527bed] check-in: [7ef7b23c] user: dan branch: trunk, size: 11024
2019-05-20
17:14
Disallow string constants enclosed in double-quotes within new CREATE TABLE and CREATE INDEX statements. It is still possible to enclose column names in double-quotes, and existing database schemas that use double-quotes for strings can still be loaded. This addresses ticket [9b78184b]. file: [dcc952a1] check-in: [1685610e] user: dan branch: trunk, size: 10402
2017-03-20
14:44
Fix the check.test script so that it works on Windows. file: [33a698e8] check-in: [8822eb5d] user: drh branch: trunk, size: 10338
2017-03-17
03:21
Fix a problem in the enhanced PRAGMA integrity_check where it verifies CHECK constraints: Do not be confused by the reuse of the Table.pCheck field by VIEWs with named columns. Problem discovered by OSS-Fuzz. file: [fb823c1a] check-in: [019dd3d5] user: drh branch: trunk, size: 10328
2017-02-22
14:15
Enhance "PRAGMA integrity_check" so that it verifies CHECK constraints. file: [92b23a91] check-in: [549bae08] user: drh branch: integrity-check-improvements, size: 10118
2016-02-10
18:24
Fix to previous check-in: Make sure CHECK constraints involving the ROWID are not ignored when the ROWID changes. file: [85a84bfc] check-in: [7782cb1d] user: drh branch: trunk, size: 9997
2013-11-05
13:33
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. file: [5831ddb6] check-in: [54b22192] user: drh branch: omit-rowid, size: 9397
2013-08-02
14:18
Silently ignore database name qualifiers in CHECK constraints and in partial index WHERE clauses. file: [1e9be446] check-in: [2e8c845e] user: drh branch: partial-indices, size: 9226
2013-01-07
13:26
Do not raise an error if an unknown SQL function is found in a CHECK constraint while parsing the schema of an existing database. This version causes a run-time error when processing STAT3 tables. file: [2eb93611] check-in: [0a1207c8] user: dan branch: mistake, size: 9007
2012-05-07
19:21
Adjust the parser so that certain legacy schema constructs (that are not valid according to the syntax diagram) continue to be accepted, so that older databases that happen to use those constructs are still readable. This fixes an issue introduced by check-in [1b75f301affac6] file: [193f47ed] check-in: [a1c014d8] user: drh branch: trunk, size: 7940
2012-03-07
19:13
If a CHECK constraint is named, report that name on the error message when the constraint fails. file: [06795c18] check-in: [9a0f90d9] user: drh branch: named-check-constraints, size: 6903
2009-12-31
19:48
Minor changes to test scripts to support various SQLITE_OMIT options. file: [db2b29d5] check-in: [97f8a886] user: shaneh branch: trunk, size: 6842
2009-06-05
17:09
Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) file: [b897cd3c] check-in: [1fef16ec] user: drh branch: trunk, size: 6841
2009-03-24
15:08
Changes to insure that lookaside memory allocations are never used to hold schema content. Ticket #3743. (CVS 6377) file: [4f245970] check-in: [ea74d8dc] user: drh branch: trunk, size: 6852
2007-07-23
19:39
The REPLACE conflict resolution falls back to FAIL when on a CHECK constraint violation. Ticket #2525. (CVS 4178) file: [024ed399] check-in: [b213614a] user: drh branch: trunk, size: 6813
2006-06-20
11:01
Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) file: [e5ea0c1a] check-in: [c6ea353b] user: danielk1977 branch: trunk, size: 6429
2006-03-15
16:26
Fix CHECK constraints to use alternative conflict resolution. Ticket #1717. (CVS 3137) file: [46c65856] check-in: [c0d20fa9] user: drh branch: trunk, size: 6397
2006-01-17
09:35
Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [55ad950d] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 5500
2006-01-14
08:02
Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) file: [686df5fd] check-in: [8e79a0c2] user: danielk1977 branch: trunk, size: 5469
2005-11-14
22:29
Create separate affinities for INTEGER and REAL. (CVS 2766) file: [8154b8ac] check-in: [ce06c123] user: drh branch: trunk, size: 5421
2005-11-03
12:33
Prohibit parameters in CHECK constraint expressions. (CVS 2758) file: [65fa9000] check-in: [bb94ef64] user: drh branch: trunk, size: 5399
02:15
Add the ignore_check_constraints pragma. VACUUM works even on a database that contains table entries that violate check constraints. (CVS 2757) file: [6d9891a9] check-in: [be83bfee] user: drh branch: trunk, size: 5111
02:03
Disallow subqueries in CHECK constraints. (CVS 2756) file: [c591a20f] check-in: [db27afc4] user: drh branch: trunk, size: 4786
01:22
CHECK constraints that evaluate to NULL pass. (CVS 2755) file: [d7f08506] check-in: [55b314a2] user: drh branch: trunk, size: 3023
00:41
First cut at supporting CHECK constraints. Everything appears to work, but much more testing is needed as well as documentation. (CVS 2754) file: [073a4b54] check-in: [2313d912] user: drh branch: trunk, size: 2998 Added