/ File History
Login

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

History of test/update.test

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