Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/check.test
|
2019-10-30
| ||
| 18:50 | 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] file: [25c60353] check-in: [2978b65e] user: drh branch: trunk, size: 11596 | |
|
2019-09-02
| ||
| 00:58 | 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]. file: [4b57ecbb] check-in: [0658c16e] user: drh branch: trunk, size: 11581 | |
|
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 | |