SQLite

All files named ”test/conflict.test”
Login

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

History for test/conflict.test

2025-04-10
10:18
[3307ffdf98] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 23933)
2023-01-17
13:33
[b705cddf02] part of check-in [92b6a9cd0f] Add test cases to confirm that the schema parsing quirk in which an ON CONFLICT clause is accepted and ignored on table CHECK constraints but raises an error on column CHECK constraints. We want to continue supporting this harmless quirk to avoid breaking legacy applications and databases that accidentally use it. (check-in: [92b6a9cd0f] user: drh branch: trunk, size: 23937)
2020-08-27
18:36
[ac0667090f] 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: 22725)
2019-12-15
02:49
[58857e2533] part of check-in [1e3918ca2f] 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: [1e3918ca2f] user: drh branch: trunk, size: 22724)
2018-12-22
01:13
[c7cc007e2a] part of check-in [db8d1d12f5] 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: [db8d1d12f5] user: drh branch: trunk, size: 22102)
2016-03-04
14:23
[029faa2d81] part of check-in [5b2fe5219a] Update test cases to taken deferred statement-journal opening into account. (check-in: [5b2fe5219a] user: drh branch: memjournal-exp, size: 21819)
2013-11-05
13:33
[841bcf7cab] 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: 21722)
2013-02-09
15:37
[0b3922d230] part of check-in [3f67437536] 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: [3f67437536] user: drh branch: constraint-error-codes, size: 21328)
2010-09-20
14:55
[cabc41f761] part of check-in [ba8ca9c9e2] Changes to test scripts to work with SQLITE_TEMP_STORE=2. (check-in: [ba8ca9c9e2] user: dan branch: trunk, size: 21093)
2010-08-03
13:08
[f2f2b29507] part of check-in [4e157b7747] Fix the REPLACE conflict resolution so that it falls back to ABORT when a CHECK constraint fails. Ticket [c38baa3d969eab794]. (check-in: [4e157b7747] user: drh branch: trunk, size: 21093)
2009-04-30
09:10
[0ed68b11f2] part of check-in [38f8c5a14c] 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: [38f8c5a14c] user: danielk1977 branch: trunk, size: 20677)
2008-01-21
16:22
[bb29b052c6] part of check-in [720bc20a11] Miscellaneous test coverage improvements. (CVS 4734) (check-in: [720bc20a11] user: drh branch: trunk, size: 20671)
2007-08-21
14:27
[79b5214ef7] part of check-in [3fb97a63ef] Delay opening temporary pager files until they are first written. (CVS 4260) (check-in: [3fb97a63ef] user: danielk1977 branch: trunk, size: 20036)
2007-04-06
21:42
[ac40064d46] part of check-in [3471a2269f] Changes to test scripts to support alternative configurations. (CVS 3824) (check-in: [3471a2269f] user: drh branch: trunk, size: 19885)
2007-01-03
23:37
[8a59399f61] part of check-in [70a862702d] 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: [70a862702d] user: drh branch: trunk, size: 19705)
2006-01-17
09:35
[16533a9267] part of check-in [3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33dcb] user: danielk1977 branch: trunk, size: 19685)
2005-09-25
01:13
[bc7b81670a] part of check-in [6d780ca6cf] Make sure the default storage for virtual tables is the disk not memory while running conflict.test. Ticket #1453. (CVS 2737) (check-in: [6d780ca6cf] user: drh branch: trunk, size: 19629)
2005-09-01
03:07
[774e10709f] part of check-in [09db0a2424] 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: [09db0a2424] user: drh branch: trunk, size: 19592)
2005-06-07
02:12
[3e7beba8c2] part of check-in [914d6e6549] Add tests to make sure statement journals are only opened when necessary. (CVS 2500) (check-in: [914d6e6549] user: drh branch: trunk, size: 19592)
2005-03-20
19:10
[3c4ef04707] part of check-in [f0a39cee78] Tentative fix for ticket #1171. More research and testing needed. (CVS 2402) (check-in: [f0a39cee78] user: drh branch: trunk, size: 20646)
2004-06-21
06:50
[c5b849b01c] part of check-in [ae2f4a0943] Update sqlite3_changes() to match the documentation and add sqlite3_total_changes(). (CVS 1645) (check-in: [ae2f4a0943] user: danielk1977 branch: trunk, size: 17410)
2004-05-31
08:55
[45ce1e44ea] part of check-in [9029274b61] Remove the <ON CONFLICT> clause from BEGIN (CVS 1501) (check-in: [9029274b61] user: danielk1977 branch: trunk, size: 17291)
08:26
[2cdd9a7468] part of check-in [b8ed812c92] Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) (check-in: [b8ed812c92] user: danielk1977 branch: trunk, size: 20253)
2003-08-05
13:13
[0911bb2f07] part of check-in [086aa1c992] Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) (check-in: [086aa1c992] user: drh branch: trunk, size: 20218)
2003-06-15
23:42
[0a66a573b8] part of check-in [c9734c2707] 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: [c9734c2707] user: drh branch: trunk, size: 20296)
2003-05-16
02:30
[70d38ff29b] part of check-in [0f92736d1f] 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: [0f92736d1f] user: drh branch: trunk, size: 20265)
2003-02-26
13:52
[80cf3780c8] part of check-in [66158843df] Fix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement that fails. Ticket #249. (CVS 1730) (check-in: [66158843df] user: drh branch: trunk, size: 19420)
2003-01-29
18:46
[d7d9dbea99] part of check-in [ccc82f1ab4] Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) (check-in: [ccc82f1ab4] user: drh branch: trunk, size: 19416)
2002-08-18
20:28
[0173a12a25] part of check-in [df51cb166b] 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: [df51cb166b] user: drh branch: trunk, size: 19270)
2002-06-28
12:18
[4518cc3c1c] part of check-in [96515b813e] 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: [96515b813e] user: drh branch: trunk, size: 19198)
2002-06-25
13:16
[93ac51097a] part of check-in [52eba4de30] Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file in addition to the main database file. (CVS 642) (check-in: [52eba4de30] user: drh branch: trunk, size: 15724)
2002-04-12
10:08
[5149646703] part of check-in [6e71493b9d] 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: [6e71493b9d] user: drh branch: trunk, size: 15799)
2002-04-09
03:28
[3383ac08da] part of check-in [bb83642e9a] Fix for bug #11: Output the correct row count when and INSERT does an IGNORE action. (CVS 524) (check-in: [bb83642e9a] user: drh branch: trunk, size: 15402)
03:15
[cbefdd1acf] part of check-in [f46acfc3b8] 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: [f46acfc3b8] user: drh branch: trunk, size: 14704)
2002-02-19
13:39
[c794c6c8f6] part of check-in [c6e9048e66] Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) (check-in: [c6e9048e66] user: drh branch: trunk, size: 13804)
2002-02-03
19:06
[7c7dbfdfae] part of check-in [20ea737536] Fix a serious bug in INSERT when the source is a SELECT. (CVS 366) (check-in: [20ea737536] user: drh branch: trunk, size: 13801)
03:34
[5515d5dcbb] part of check-in [95d1f8389d] The VACUUM command now does a database sanity check. (CVS 364) (check-in: [95d1f8389d] user: drh branch: trunk, size: 13699)
00:56
[dd1b380595] part of check-in [0115518f8e] Five-algorithm conflict resolution appears to be working. (CVS 363) (check-in: [0115518f8e] user: drh branch: trunk, size: 13674)
2002-01-31
15:54
[70d40d77bb] part of check-in [d0e7cf4a83] 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: [d0e7cf4a83] user: drh branch: trunk, size: 6370)
2002-01-30
16:17
[685725a37e] part of check-in [cf1538d71c] Added ON CONFLICT support to COPY. Updates to documentation. Bug fixes. (CVS 359) (check-in: [cf1538d71c] user: drh branch: trunk, size: 6466)
04:32
[66ac8bec8e] part of check-in [9bbddb8e01] Better testing of the ON CONFLICT logic. (CVS 358) (check-in: [9bbddb8e01] user: drh branch: trunk, size: 6465)
00:54
Added: [b1115520b3] part of check-in [8229b5f6a3] More bug fixes in the ON CONFLICT enhancement. (CVS 357) (check-in: [8229b5f6a3] user: drh branch: trunk, size: 3504)