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 | |