Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/update.test
|
2019-12-29
| ||
| 22:08 | Do not allow triggers that run as part of REPLACE conflict resolution during an UPDATE to modify the the table being updated. Otherwise, those triggers might delete content out from under the update operation, leading to all kinds of problems. Ticket [314cc133e5ada126] file: [e906ca7c] check-in: [db4b7e1d] user: drh branch: trunk, size: 22281 | |
| 00:52 | Add the OP_FinishSeek opcode which completes an OP_DeferredSeek if the seek has not already completed. Also add the sqlite3WhereUsesDeferredSeek() interface to the query planner. The UPDATE implementation adds an OP_FinishSeek before running the final OP_Insert if one is needed. Ticket [ec8abb025e78f40c] and also an assertion fault reported by Yongheng. file: [40aa53ed] check-in: [21ef6e99] user: drh branch: trunk, size: 21290 | |
|
2019-12-23
| ||
| 02:18 | Enhance the sqlite3VdbeMemAboutToChange() shallow-copy validation mechanism by adding the new OP_ReleaseReg opcode to tell MemAboutToChange() that a range of registers is no longer needed so that the source register can be freely changed. This is a change to debugging and test builds only and does not impact release builds. Fix for ticket [c62c5e58524b204d] and [5ad2aa6921faa1ee]. The previous fix to ticket [5ad2aa6921faa1ee] is backed out by this change since this change is a better fix. file: [6fdd76fd] check-in: [36fdeb4f] user: drh branch: trunk, size: 20808 | |
|
2019-12-22
| ||
| 20:29 | Make a hard copy of strings in constraint checks prior to applying OP_RealAffinity, to avoid problems with a pointer accounting assert. This change is not strictly necessary - the correct answer is obtained without it and no UB occurs - however the pointer accounting asserts are useful to prevent other problems so it is a simple matter to bring this piece into compliance. Ticket [5ad2aa6921faa1ee] file: [127fc037] check-in: [89a9dad6] user: drh branch: trunk, size: 20491 | |
|
2019-12-09
| ||
| 14:34 | Fix a gramfuzz find. If a partial index that does not reference any column of its table is used by an UPDATE statement in one-pass mode, then avoid the use of OP_DeferredSeek since the seek might not be resolved prior to the OP_Delete and OP_Insert that implement the UPDATE. file: [6a1193fb] check-in: [e3398c5f] user: drh branch: trunk, size: 19930 | |
|
2018-04-19
| ||
| 13:52 | Fix a problem in the new upsert implemention, discovered by OSSFuzz. file: [1148de8d] check-in: [b6d5ea59] user: drh branch: trunk, size: 19396 | |
| 11:45 | Fix the table name aliasing on INSERT so that it occurs before the column list rather than afterwards, just as it does for PostgreSQL. Add table name aliasing to UPDATE and DELETE. file: [17f93464] check-in: [861a2e2a] user: drh branch: trunk, size: 19004 | |
|
2014-10-29
| ||
| 00:58 | In the OP_Column opcode, when extracting a field that is past the end of a short record (because the row was originally inserted prior to ALTER TABLE ADD COLUMN) then make sure the output register is fully NULL and does not contain leftover flags (such as MEM_Ephem) from its previous use. Fix for ticket [43107840f1c02]. file: [6c68446b] check-in: [24780f8d] user: drh branch: trunk, size: 18683 | |
|
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: [1b6c488a] check-in: [54b22192] user: drh branch: omit-rowid, size: 18112 | |
|
2008-04-10
| ||
| 18:44 | Enhancements to the change counter tests. Ticket #3013. (CVS 4986) file: [8bc86fd7] check-in: [1aaed6a4] user: drh branch: trunk, size: 18091 | |
|
2008-01-16
| ||
| 18:20 | Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) file: [24c1dcc0] check-in: [3a289b6d] user: danielk1977 branch: trunk, size: 17887 | |
|
2005-01-21
| ||
| 03:12 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [7669ca78] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 17896 | |
|
2005-01-15
| ||
| 00:40 | Improved test coverage for update.c. (CVS 2214) file: [5d9b7451] check-in: [3ef95d5f] user: drh branch: trunk, size: 17841 | |
|
2004-02-10
| ||
| 13:41 | Perform updates in search order. Ticket #602. (CVS 1221) file: [b29bd906] check-in: [cf1cec74] user: drh branch: trunk, size: 17163 | |
|
2003-08-05
| ||
| 13:13 | Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) file: [2ef5a665] check-in: [086aa1c9] user: drh branch: trunk, size: 15697 | |
|
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: [3ddb0ece] check-in: [c9734c27] user: drh branch: trunk, size: 15704 | |
|
2003-02-15
| ||
| 23:09 | Fix the pager so that correct rollbacks occur when synchronous is turned off. This check-in also included unrelated documentation updates. (CVS 866) file: [198360df] check-in: [3ef0ad8a] user: drh branch: trunk, size: 15675 | |
|
2003-01-29
| ||
| 18:46 | Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) file: [e7b224f4] check-in: [ccc82f1a] user: drh branch: trunk, size: 15641 | |
|
2002-07-16
| ||
| 17:22 | Fix for ticket #105: Fix the UPDATE command so that it works properly with indexed tables when there is a subquery in the WHERE clause. Add tests to verify correct operation. (CVS 680) file: [7ffb062d] check-in: [bbca16f8] user: drh branch: trunk, size: 15610 | |
|
2002-05-21
| ||
| 12:56 | Fix for ticket #45: Allow an UPDATE statement to change the INTEGER PRIMARY KEY to itself without triggering a constraint error. (CVS 573) file: [a0aa0bf8] check-in: [592da134] user: drh branch: trunk, size: 15288 | |
|
2001-11-09
| ||
| 22:41 | Minor bugs fixed. (CVS 307) file: [3cf1ca05] check-in: [6e7e7dbf] user: drh branch: trunk, size: 13832 | |
|
2001-10-15
| ||
| 00:44 | Added support for the COUNT_CHANGES pragma in order to help out the ODBC driver. Fixed a but on count(*) when applied to empty tables. (CVS 289) file: [8cf76467] check-in: [747bf1b3] user: drh branch: trunk, size: 13770 | |
|
2001-09-16
| ||
| 00:13 | Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [b320ea22] check-in: [4e926efe] user: drh branch: trunk, size: 13322 | |
|
2001-02-19
| ||
| 18:24 | fix the UPDATE bug (CVS 185) file: [72c0c933] check-in: [99aae9aa] user: drh branch: trunk, size: 13865 | |
|
2000-06-21
| ||
| 13:59 | :-) (CVS 104) file: [62f6ce99] check-in: [e1bf96a4] user: drh branch: trunk, size: 4338 | |
|
2000-06-19
| ||
| 19:09 | :-) (CVS 102) file: [0f763adc] check-in: [8cce4d27] user: drh branch: trunk, size: 4332 | |
|
2000-06-08
| ||
| 16:26 | :-) (CVS 82) file: [b3f45984] check-in: [33355b2d] user: drh branch: trunk, size: 4332 | |
|
2000-05-30
| ||
| 03:12 | :-) (CVS 12) file: [69459302] check-in: [20f2811f] user: drh branch: trunk, size: 3743 Added | |