/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/conflict.test

2018-12-22
01:13
Do not all REPLACE to sneak a NULL value into a NOT NULL column. Detect that situation and ABORT instead. Fix for ticket [e6f1f2e34dceeb1ed61531c7e98]. file: [c7cc007e] check-in: [db8d1d12] user: drh branch: trunk, size: 22102
2016-03-04
14:23
Update test cases to taken deferred statement-journal opening into account. file: [029faa2d] check-in: [5b2fe521] user: drh branch: memjournal-exp, size: 21819
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: [841bcf7c] check-in: [54b22192] user: drh branch: omit-rowid, size: 21722
2013-02-09
15:37
Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the extended constraint error codes in alphabetical order. Add many test cases for the extended constraint error codes. file: [0b3922d2] check-in: [3f674375] user: drh branch: constraint-error-codes, size: 21328
2010-09-20
14:55
Changes to test scripts to work with SQLITE_TEMP_STORE=2. file: [cabc41f7] check-in: [ba8ca9c9] user: dan branch: trunk, size: 21093
2010-08-03
13:08
Fix the REPLACE conflict resolution so that it falls back to ABORT when a CHECK constraint fails. Ticket [c38baa3d969eab794]. file: [f2f2b295] check-in: [4e157b77] user: drh branch: trunk, size: 21093
2009-04-30
09:10
When SQLite is configured to use in-memory temp files (either by setting SQLITE_TEMP_STORE during compilation or using the temp_store pragma at run time), store statement/savepoint journals in memory also. Ticket #3825. (CVS 6575) file: [0ed68b11] check-in: [38f8c5a1] user: danielk1977 branch: trunk, size: 20677
2008-01-21
16:22
Miscellaneous test coverage improvements. (CVS 4734) file: [bb29b052] check-in: [720bc20a] user: drh branch: trunk, size: 20671
2007-08-21
14:27
Delay opening temporary pager files until they are first written. (CVS 4260) file: [79b5214e] check-in: [3fb97a63] user: danielk1977 branch: trunk, size: 20036
2007-04-06
21:42
Changes to test scripts to support alternative configurations. (CVS 3824) file: [ac40064d] check-in: [3471a226] user: drh branch: trunk, size: 19885
2007-01-03
23:37
Clean up memory leaks and uninitialized variables detected by valgrind. Identify all tests where we deliberately derefence freed memory by adding a "-misuse" tag. (CVS 3550) file: [8a59399f] check-in: [70a86270] user: drh branch: trunk, size: 19705
2006-01-17
09:35
Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [16533a92] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 19685
2005-09-25
01:13
Make sure the default storage for virtual tables is the disk not memory while running conflict.test. Ticket #1453. (CVS 2737) file: [bc7b8167] check-in: [6d780ca6] user: drh branch: trunk, size: 19629
2005-09-01
03:07
Sorting is now done using a sorting index rather than loading the entire result set into memory and doing a merge sort. The old merge sort technique was a carry-over from SQLite version 1. The new method uses a bounded amount of memory and scales to much larger result sets. There are still errors: some 39 regression tests fail. (CVS 2653) file: [774e1070] check-in: [09db0a24] user: drh branch: trunk, size: 19592
2005-06-07
02:12
Add tests to make sure statement journals are only opened when necessary. (CVS 2500) file: [3e7beba8] check-in: [914d6e65] user: drh branch: trunk, size: 19592
2005-03-20
19:10
Tentative fix for ticket #1171. More research and testing needed. (CVS 2402) file: [3c4ef047] check-in: [f0a39cee] user: drh branch: trunk, size: 20646
2004-06-21
06:50
Update sqlite3_changes() to match the documentation and add sqlite3_total_changes(). (CVS 1645) file: [c5b849b0] check-in: [ae2f4a09] user: danielk1977 branch: trunk, size: 17410
2004-05-31
08:55
Remove the <ON CONFLICT> clause from BEGIN (CVS 1501) file: [45ce1e44] check-in: [9029274b] user: danielk1977 branch: trunk, size: 17291
08:26
Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) file: [2cdd9a74] check-in: [b8ed812c] user: danielk1977 branch: trunk, size: 20253
2003-08-05
13:13
Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) file: [0911bb2f] check-in: [086aa1c9] user: drh branch: trunk, size: 20218
2003-06-15
23:42
Enhance the "PRAGMA integrity_check" command to verify that all indices are correctly constructed. New calls to integrity_check are made in the test suite. These changes are intended to prevent any future problems such as seen in ticket #334. (CVS 1024) file: [0a66a573] check-in: [c9734c27] user: drh branch: trunk, size: 20296
2003-05-16
02:30
Make sure the ON CONFLICT clause on a BEGIN overrides the conflict resolution specified by an index. This fixes a bug reported on the newsgroup. (CVS 975) file: [70d38ff2] check-in: [0f92736d] user: drh branch: trunk, size: 20265
2003-02-26
13:52
Fix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement that fails. Ticket #249. (CVS 1730) file: [80cf3780] check-in: [66158843] user: drh branch: trunk, size: 19420
2003-01-29
18:46
Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) file: [d7d9dbea] check-in: [ccc82f1a] user: drh branch: trunk, size: 19416
2002-08-18
20:28
Fix for ticket #110: return an error if trying to start a transaction within a transaction or when attempting to commit or rollback outside of a transaction. (CVS 721) file: [0173a12a] check-in: [df51cb16] user: drh branch: trunk, size: 19270
2002-06-28
12:18
Additional test cases added. The following bug fixed: A segfault was occurring if a VIEW consisted of a join with a USING clause. (CVS 651) file: [4518cc3c] check-in: [96515b81] user: drh branch: trunk, size: 19198
2002-06-25
13:16
Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file in addition to the main database file. (CVS 642) file: [93ac5109] check-in: [52eba4de] user: drh branch: trunk, size: 15724
2002-04-12
10:08
Fix for bug #15: Add the sqlite_changes() API function for retrieving the number of rows that changed in the previous operation. (CVS 526) file: [51496467] check-in: [6e71493b] user: drh branch: trunk, size: 15799
2002-04-09
03:28
Fix for bug #11: Output the correct row count when and INSERT does an IGNORE action. (CVS 524) file: [3383ac08] check-in: [bb83642e] user: drh branch: trunk, size: 15402
03:15
Fix for bug #10: Pop the stack by the right amount on an IGNORE so that the stack does not grow without bound. (CVS 523) file: [cbefdd1a] check-in: [f46acfc3] user: drh branch: trunk, size: 14704
2002-02-19
13:39
Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) file: [c794c6c8] check-in: [c6e9048e] user: drh branch: trunk, size: 13804
2002-02-03
19:06
Fix a serious bug in INSERT when the source is a SELECT. (CVS 366) file: [7c7dbfdf] check-in: [20ea7375] user: drh branch: trunk, size: 13801
03:34
The VACUUM command now does a database sanity check. (CVS 364) file: [5515d5dc] check-in: [95d1f838] user: drh branch: trunk, size: 13699
00:56
Five-algorithm conflict resolution appears to be working. (CVS 363) file: [dd1b3805] check-in: [0115518f] user: drh branch: trunk, size: 13674
2002-01-31
15:54
Change to five conflict resolution algorithms: ROLLBACK, ABORT, FAIL, IGNORE, and REPLACE. This checkin is code only. Documentation and tests are still needed. Also, ABORT is not fully implemented. (CVS 360) file: [70d40d77] check-in: [d0e7cf4a] user: drh branch: trunk, size: 6370
2002-01-30
16:17
Added ON CONFLICT support to COPY. Updates to documentation. Bug fixes. (CVS 359) file: [685725a3] check-in: [cf1538d7] user: drh branch: trunk, size: 6466
04:32
Better testing of the ON CONFLICT logic. (CVS 358) file: [66ac8bec] check-in: [9bbddb8e] user: drh branch: trunk, size: 6465
00:54
More bug fixes in the ON CONFLICT enhancement. (CVS 357) file: [b1115520] check-in: [8229b5f6] user: drh branch: trunk, size: 3504 Added