SQLite

All files named ”test/check.test”
Login

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

History for test/check.test

2025-05-06
17:56
[3a7972ccba] part of check-in [6eb2939a60] Add test cases for the NOT NULL/IS NULL optimization in CHECK constraints fix. (check-in: [6eb2939a60] user: dan branch: trunk, size: 14828)
2022-01-16
19:11
[56e4ed457e] part of check-in [4883776669] Fix test cases so that they all still work even with -DSQLITE_DQS=0. (check-in: [4883776669] user: drh branch: trunk, size: 14059)
2020-08-27
18:36
[4a2a91ed67] part of check-in [5ce34a955b] Include the original text of the CHECK constraint in the error message for anonymous CHECK constraints. (check-in: [5ce34a955b] user: drh branch: trunk, size: 13871)
2020-02-01
21:03
[9776af795b] part of check-in [1d4f86201d] On an INSERT or UPDATE, perform affinity conversions on new data prior to running CHECK constraints. Ticket [86ba67afafded936]. (check-in: [1d4f86201d] user: drh branch: trunk, size: 13601)
2019-12-24
01:53
[b21a76546c] part of check-in [401c9d30e0] Allow comparison operators of a register against itself. Ticket [188f912b51cd802a], (check-in: [401c9d30e0] user: drh branch: trunk, size: 13631)
2019-10-30
18:50
[25c6035302] part of check-in [2978b65ebe] Always disallow the use of non-deterministic functions in CHECK constraints, even date/time functions that use the 'now' or similar keywords. Provide improved error messages when this requirement is not met. Ticket [830277d9db6c3ba1] (check-in: [2978b65ebe] user: drh branch: trunk, size: 11596)
2019-09-02
00:58
[4b57ecbbb3] part of check-in [0658c16e31] When computing an expression value for an index-on-expression or a CHECK constraint and the expressions uses a REAL table column, but the value of that column is an integer (in other words, when it is using the store-real-as-integer optimization) be sure to promote the value to real before evaluating the expression. Ticket [57af00b6642ecd68]. (check-in: [0658c16e31] user: drh branch: trunk, size: 11581)
2019-07-17
14:34
[e6527bed2b] part of check-in [7ef7b23cbb] 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]. (check-in: [7ef7b23cbb] user: dan branch: trunk, size: 11024)
2019-05-20
17:14
[dcc952a127] part of check-in [1685610ef8] 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]. (check-in: [1685610ef8] user: dan branch: trunk, size: 10402)
2017-03-20
14:44
[33a698e8c6] part of check-in [8822eb5d79] Fix the check.test script so that it works on Windows. (check-in: [8822eb5d79] user: drh branch: trunk, size: 10338)
2017-03-17
03:21
[fb823c1aee] part of check-in [019dd3d5ba] 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. (check-in: [019dd3d5ba] user: drh branch: trunk, size: 10328)
2017-02-22
14:15
[92b23a91fb] part of check-in [549bae0856] Enhance "PRAGMA integrity_check" so that it verifies CHECK constraints. (check-in: [549bae0856] user: drh branch: integrity-check-improvements, size: 10118)
2016-02-10
18:24
[85a84bfc4b] part of check-in [7782cb1dd5] Fix to previous check-in: Make sure CHECK constraints involving the ROWID are not ignored when the ROWID changes. (check-in: [7782cb1dd5] user: drh branch: trunk, size: 9997)
2013-11-05
13:33
[5831ddb6f2] 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: 9397)
2013-08-02
14:18
[1e9be446eb] part of check-in [2e8c845eb5] Silently ignore database name qualifiers in CHECK constraints and in partial index WHERE clauses. (check-in: [2e8c845eb5] user: drh branch: partial-indices, size: 9226)
2013-01-07
13:26
[2eb9361113] part of check-in [0a1207c895] 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. (check-in: [0a1207c895] user: dan branch: mistake, size: 9007)
2012-05-07
19:21
[193f47ed43] part of check-in [a1c014d8a8] 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] (check-in: [a1c014d8a8] user: drh branch: trunk, size: 7940)
2012-03-07
19:13
[06795c188b] part of check-in [9a0f90d9de] If a CHECK constraint is named, report that name on the error message when the constraint fails. (check-in: [9a0f90d9de] user: drh branch: named-check-constraints, size: 6903)
2009-12-31
19:48
[db2b29d557] part of check-in [97f8a886b6] Minor changes to test scripts to support various SQLITE_OMIT options. (check-in: [97f8a886b6] user: shaneh branch: trunk, size: 6842)
2009-06-05
17:09
[b897cd3cc8] part of check-in [1fef16ec2b] Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) (check-in: [1fef16ec2b] user: drh branch: trunk, size: 6841)
2009-03-24
15:08
[4f245970b4] part of check-in [ea74d8dc62] Changes to insure that lookaside memory allocations are never used to hold schema content. Ticket #3743. (CVS 6377) (check-in: [ea74d8dc62] user: drh branch: trunk, size: 6852)
2007-07-23
19:39
[024ed39960] part of check-in [b213614abf] The REPLACE conflict resolution falls back to FAIL when on a CHECK constraint violation. Ticket #2525. (CVS 4178) (check-in: [b213614abf] user: drh branch: trunk, size: 6813)
2006-06-20
11:01
[e5ea0c1a06] part of check-in [c6ea353bd9] Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) (check-in: [c6ea353bd9] user: danielk1977 branch: trunk, size: 6429)
2006-03-15
16:26
[46c658566c] part of check-in [c0d20fa97f] Fix CHECK constraints to use alternative conflict resolution. Ticket #1717. (CVS 3137) (check-in: [c0d20fa97f] user: drh branch: trunk, size: 6397)
2006-01-17
09:35
[55ad950d7a] part of check-in [3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33dcb] user: danielk1977 branch: trunk, size: 5500)
2006-01-14
08:02
[686df5fd9f] part of check-in [8e79a0c24a] Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) (check-in: [8e79a0c24a] user: danielk1977 branch: trunk, size: 5469)
2005-11-14
22:29
[8154b8ac0c] part of check-in [ce06c123d0] Create separate affinities for INTEGER and REAL. (CVS 2766) (check-in: [ce06c123d0] user: drh branch: trunk, size: 5421)
2005-11-03
12:33
[65fa90003d] part of check-in [bb94ef64b2] Prohibit parameters in CHECK constraint expressions. (CVS 2758) (check-in: [bb94ef64b2] user: drh branch: trunk, size: 5399)
02:15
[6d9891a9c2] part of check-in [be83bfee02] Add the ignore_check_constraints pragma. VACUUM works even on a database that contains table entries that violate check constraints. (CVS 2757) (check-in: [be83bfee02] user: drh branch: trunk, size: 5111)
02:03
[c591a20fcb] part of check-in [db27afc4cd] Disallow subqueries in CHECK constraints. (CVS 2756) (check-in: [db27afc4cd] user: drh branch: trunk, size: 4786)
01:22
[d7f0850650] part of check-in [55b314a22c] CHECK constraints that evaluate to NULL pass. (CVS 2755) (check-in: [55b314a22c] user: drh branch: trunk, size: 3023)
00:41
Added: [073a4b5427] part of check-in [2313d912ba] First cut at supporting CHECK constraints. Everything appears to work, but much more testing is needed as well as documentation. (CVS 2754) (check-in: [2313d912ba] user: drh branch: trunk, size: 2998)