Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/update.test
2025-04-10
| ||
10:18 | [258dcf26d4] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 24033) | |
2023-08-01
| ||
00:34 | [85d3f46d08] part of check-in [42916af9fc] Restore part of the UPDATE one-pass optimization that was removed by check-in [2c56b984a0bd3be5]: only disable one-pass if the WHERE clause contains a subquery. Allow subqueries in the SET expressions. Fix for performance problem reported by forum post 8ab195fd44e75ed0. (check-in: [42916af9fc] user: drh branch: trunk, size: 24049) | |
2023-03-16
| ||
10:17 | [90772ede84] part of check-in [2c56b984a0] Do not use the one-pass optimization on an UPDATE if there is a subquery in the WHERE clause, since if the subquery is hidden behind a short-circuit operator, the subquery might not be evaluated until after one or more rows have been updated. Fix for the problem reported by forum post 0007d1fdb1. This is the same problem that was fixed by [73f0036f045bf371] only for UPDATE instead of DELETE. (check-in: [2c56b984a0] user: drh branch: trunk, size: 23314) | |
2022-01-16
| ||
19:11 | [eb7f4eb172] part of check-in [4883776669] Fix test cases so that they all still work even with -DSQLITE_DQS=0. (check-in: [4883776669] user: drh branch: trunk, size: 22327) | |
2021-10-01
| ||
20:39 | [ef3ebbafeb] part of check-in [2f7c946c5f] Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE. (check-in: [2f7c946c5f] user: dan branch: trunk, size: 22327) | |
2019-12-29
| ||
22:08 | [e906ca7cb1] part of check-in [db4b7e1dc3] 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] (check-in: [db4b7e1dc3] user: drh branch: trunk, size: 22281) | |
00:52 | [40aa53edd5] part of check-in [21ef6e9933] 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. (check-in: [21ef6e9933] user: drh branch: trunk, size: 21290) | |
2019-12-23
| ||
02:18 | [6fdd76fdf3] part of check-in [36fdeb4f0a] 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. (check-in: [36fdeb4f0a] user: drh branch: trunk, size: 20808) | |
2019-12-22
| ||
20:29 | [127fc03788] part of check-in [89a9dad633] 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] (check-in: [89a9dad633] user: drh branch: trunk, size: 20491) | |
2019-12-09
| ||
14:34 | [6a1193fbcb] part of check-in [e3398c5ffb] 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. (check-in: [e3398c5ffb] user: drh branch: trunk, size: 19930) | |
2018-04-19
| ||
13:52 | [1148de8d91] part of check-in [b6d5ea59fe] Fix a problem in the new upsert implemention, discovered by OSSFuzz. (check-in: [b6d5ea59fe] user: drh branch: trunk, size: 19396) | |
11:45 | [17f93464d3] part of check-in [861a2e2a48] 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. (check-in: [861a2e2a48] user: drh branch: trunk, size: 19004) | |
2014-10-29
| ||
00:58 | [6c68446b8a] part of check-in [24780f8ddc] 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]. (check-in: [24780f8ddc] user: drh branch: trunk, size: 18683) | |
2013-11-05
| ||
13:33 | [1b6c488a8f] 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: 18112) | |
2008-04-10
| ||
18:44 | [8bc86fd7ef] part of check-in [1aaed6a469] Enhancements to the change counter tests. Ticket #3013. (CVS 4986) (check-in: [1aaed6a469] user: drh branch: trunk, size: 18091) | |
2008-01-16
| ||
18:20 | [24c1dcc025] part of check-in [3a289b6d28] Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) (check-in: [3a289b6d28] user: danielk1977 branch: trunk, size: 17887) | |
2005-01-21
| ||
03:12 | [7669ca789d] part of check-in [bb0254ab14] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab14] user: danielk1977 branch: trunk, size: 17896) | |
2005-01-15
| ||
00:40 | [5d9b7451c9] part of check-in [3ef95d5fe9] Improved test coverage for update.c. (CVS 2214) (check-in: [3ef95d5fe9] user: drh branch: trunk, size: 17841) | |
2004-02-10
| ||
13:41 | [b29bd9061a] part of check-in [cf1cec74ae] Perform updates in search order. Ticket #602. (CVS 1221) (check-in: [cf1cec74ae] user: drh branch: trunk, size: 17163) | |
2003-08-05
| ||
13:13 | [2ef5a6655f] 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: 15697) | |
2003-06-15
| ||
23:42 | [3ddb0ece1f] 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: 15704) | |
2003-02-15
| ||
23:09 | [198360dfa1] part of check-in [3ef0ad8a4f] Fix the pager so that correct rollbacks occur when synchronous is turned off. This check-in also included unrelated documentation updates. (CVS 866) (check-in: [3ef0ad8a4f] user: drh branch: trunk, size: 15675) | |
2003-01-29
| ||
18:46 | [e7b224f4ed] 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: 15641) | |
2002-07-16
| ||
17:22 | [7ffb062d58] part of check-in [bbca16f88d] 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) (check-in: [bbca16f88d] user: drh branch: trunk, size: 15610) | |
2002-05-21
| ||
12:56 | [a0aa0bf83e] part of check-in [592da13468] Fix for ticket #45: Allow an UPDATE statement to change the INTEGER PRIMARY KEY to itself without triggering a constraint error. (CVS 573) (check-in: [592da13468] user: drh branch: trunk, size: 15288) | |
2001-11-09
| ||
22:41 | [3cf1ca0565] part of check-in [6e7e7dbf8e] Minor bugs fixed. (CVS 307) (check-in: [6e7e7dbf8e] user: drh branch: trunk, size: 13832) | |
2001-10-15
| ||
00:44 | [8cf76467d4] part of check-in [747bf1b30b] 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) (check-in: [747bf1b30b] user: drh branch: trunk, size: 13770) | |
2001-09-16
| ||
00:13 | [b320ea2289] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 13322) | |
2001-02-19
| ||
18:24 | [72c0c93310] part of check-in [99aae9aaa9] fix the UPDATE bug (CVS 185) (check-in: [99aae9aaa9] user: drh branch: trunk, size: 13865) | |
2000-06-21
| ||
13:59 | [62f6ce99ff] part of check-in [e1bf96a467] :-) (CVS 104) (check-in: [e1bf96a467] user: drh branch: trunk, size: 4338) | |
2000-06-19
| ||
19:09 | [0f763adc3d] part of check-in [8cce4d279d] :-) (CVS 102) (check-in: [8cce4d279d] user: drh branch: trunk, size: 4332) | |
2000-06-08
| ||
16:26 | [b3f45984cd] part of check-in [33355b2d8d] :-) (CVS 82) (check-in: [33355b2d8d] user: drh branch: trunk, size: 4332) | |
2000-05-30
| ||
03:12 | Added: [69459302ea] part of check-in [20f2811fc1] :-) (CVS 12) (check-in: [20f2811fc1] user: drh branch: trunk, size: 3743) | |