/ History for test/conflict.test
Login

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

History for test/conflict.test

2019-12-15
02:49
[58857e25] part of check-in [1e3918ca] Ensure that all ON CONFLICT REPLACE indexes are sorted to the end of the list of indexes for a table, even for weird cases where the same UNIQUE constraint occurs twice with the ON CONFLICT REPLACE clause only on the second one. This avoids an out-of-order contraint processing problem that can arise due to the optimization of check-in [469a62ca33081854]. (check-in: [1e3918ca] user: drh branch: trunk, size: 22724)
2018-12-22
01:13
[c7cc007e] part of check-in [db8d1d12] Do not all REPLACE to sneak a NULL value into a NOT NULL column. Detect that situation and ABORT instead. Fix for ticket [e6f1f2e34dceeb1ed61531c7e98]. (check-in: [db8d1d12] user: drh branch: trunk, size: 22102)
2016-03-04
14:23
[029faa2d] part of check-in [5b2fe521] Update test cases to taken deferred statement-journal opening into account. (check-in: [5b2fe521] user: drh branch: memjournal-exp, size: 21819)
2013-11-05
13:33
[841bcf7c] part of check-in [54b22192] 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: [54b22192] user: drh branch: omit-rowid, size: 21722)
2013-02-09
15:37
[0b3922d2] part of check-in [3f674375] 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. (check-in: [3f674375] user: drh branch: constraint-error-codes, size: 21328)
2010-09-20
14:55
[cabc41f7] part of check-in [ba8ca9c9] Changes to test scripts to work with SQLITE_TEMP_STORE=2. (check-in: [ba8ca9c9] user: dan branch: trunk, size: 21093)
2010-08-03
13:08
[f2f2b295] part of check-in [4e157b77] Fix the REPLACE conflict resolution so that it falls back to ABORT when a CHECK constraint fails. Ticket [c38baa3d969eab794]. (check-in: [4e157b77] user: drh branch: trunk, size: 21093)
2009-04-30
09:10
[0ed68b11] part of check-in [38f8c5a1] 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) (check-in: [38f8c5a1] user: danielk1977 branch: trunk, size: 20677)
2008-01-21
16:22
[bb29b052] part of check-in [720bc20a] Miscellaneous test coverage improvements. (CVS 4734) (check-in: [720bc20a] user: drh branch: trunk, size: 20671)
2007-08-21
14:27
[79b5214e] part of check-in [3fb97a63] Delay opening temporary pager files until they are first written. (CVS 4260) (check-in: [3fb97a63] user: danielk1977 branch: trunk, size: 20036)
2007-04-06
21:42
[ac40064d] part of check-in [3471a226] Changes to test scripts to support alternative configurations. (CVS 3824) (check-in: [3471a226] user: drh branch: trunk, size: 19885)
2007-01-03
23:37
[8a59399f] part of check-in [70a86270] 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) (check-in: [70a86270] user: drh branch: trunk, size: 19705)
2006-01-17
09:35
[16533a92] part of check-in [3a54a33d] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 19685)
2005-09-25
01:13
[bc7b8167] part of check-in [6d780ca6] Make sure the default storage for virtual tables is the disk not memory while running conflict.test. Ticket #1453. (CVS 2737) (check-in: [6d780ca6] user: drh branch: trunk, size: 19629)
2005-09-01
03:07
[774e1070] part of check-in [09db0a24] 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) (check-in: [09db0a24] user: drh branch: trunk, size: 19592)
2005-06-07
02:12
[3e7beba8] part of check-in [914d6e65] Add tests to make sure statement journals are only opened when necessary. (CVS 2500) (check-in: [914d6e65] user: drh branch: trunk, size: 19592)
2005-03-20
19:10
[3c4ef047] part of check-in [f0a39cee] Tentative fix for ticket #1171. More research and testing needed. (CVS 2402) (check-in: [f0a39cee] user: drh branch: trunk, size: 20646)
2004-06-21
06:50
[c5b849b0] part of check-in [ae2f4a09] Update sqlite3_changes() to match the documentation and add sqlite3_total_changes(). (CVS 1645) (check-in: [ae2f4a09] user: danielk1977 branch: trunk, size: 17410)
2004-05-31
08:55
[45ce1e44] part of check-in [9029274b] Remove the <ON CONFLICT> clause from BEGIN (CVS 1501) (check-in: [9029274b] user: danielk1977 branch: trunk, size: 17291)
08:26
[2cdd9a74] part of check-in [b8ed812c] Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) (check-in: [b8ed812c] user: danielk1977 branch: trunk, size: 20253)
2003-08-05
13:13
[0911bb2f] part of check-in [086aa1c9] Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) (check-in: [086aa1c9] user: drh branch: trunk, size: 20218)
2003-06-15
23:42
[0a66a573] part of check-in [c9734c27] 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) (check-in: [c9734c27] user: drh branch: trunk, size: 20296)
2003-05-16
02:30
[70d38ff2] part of check-in [0f92736d] 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) (check-in: [0f92736d] user: drh branch: trunk, size: 20265)
2003-02-26
13:52
[80cf3780] part of check-in [66158843] Fix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement that fails. Ticket #249. (CVS 1730) (check-in: [66158843] user: drh branch: trunk, size: 19420)
2003-01-29
18:46
[d7d9dbea] part of check-in [ccc82f1a] Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) (check-in: [ccc82f1a] user: drh branch: trunk, size: 19416)
2002-08-18
20:28
[0173a12a] part of check-in [df51cb16] 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) (check-in: [df51cb16] user: drh branch: trunk, size: 19270)
2002-06-28
12:18
[4518cc3c] part of check-in [96515b81] 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) (check-in: [96515b81] user: drh branch: trunk, size: 19198)
2002-06-25
13:16
[93ac5109] part of check-in [52eba4de] Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file in addition to the main database file. (CVS 642) (check-in: [52eba4de] user: drh branch: trunk, size: 15724)
2002-04-12
10:08
[51496467] part of check-in [6e71493b] Fix for bug #15: Add the sqlite_changes() API function for retrieving the number of rows that changed in the previous operation. (CVS 526) (check-in: [6e71493b] user: drh branch: trunk, size: 15799)
2002-04-09
03:28
[3383ac08] part of check-in [bb83642e] Fix for bug #11: Output the correct row count when and INSERT does an IGNORE action. (CVS 524) (check-in: [bb83642e] user: drh branch: trunk, size: 15402)
03:15
[cbefdd1a] part of check-in [f46acfc3] 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) (check-in: [f46acfc3] user: drh branch: trunk, size: 14704)
2002-02-19
13:39
[c794c6c8] part of check-in [c6e9048e] Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) (check-in: [c6e9048e] user: drh branch: trunk, size: 13804)
2002-02-03
19:06
[7c7dbfdf] part of check-in [20ea7375] Fix a serious bug in INSERT when the source is a SELECT. (CVS 366) (check-in: [20ea7375] user: drh branch: trunk, size: 13801)
03:34
[5515d5dc] part of check-in [95d1f838] The VACUUM command now does a database sanity check. (CVS 364) (check-in: [95d1f838] user: drh branch: trunk, size: 13699)
00:56
[dd1b3805] part of check-in [0115518f] Five-algorithm conflict resolution appears to be working. (CVS 363) (check-in: [0115518f] user: drh branch: trunk, size: 13674)
2002-01-31
15:54
[70d40d77] part of check-in [d0e7cf4a] 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) (check-in: [d0e7cf4a] user: drh branch: trunk, size: 6370)
2002-01-30
16:17
[685725a3] part of check-in [cf1538d7] Added ON CONFLICT support to COPY. Updates to documentation. Bug fixes. (CVS 359) (check-in: [cf1538d7] user: drh branch: trunk, size: 6466)
04:32
[66ac8bec] part of check-in [9bbddb8e] Better testing of the ON CONFLICT logic. (CVS 358) (check-in: [9bbddb8e] user: drh branch: trunk, size: 6465)
00:54
[b1115520] part of check-in [8229b5f6] More bug fixes in the ON CONFLICT enhancement. (CVS 357) (check-in: [8229b5f6] user: drh branch: trunk, size: 3504) Added