Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/delete.test
2023-03-16
| ||
10:17 | [2686e1c98d] 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: 12216) | |
2023-03-15
| ||
17:58 | [f66581a229] part of check-in [73f0036f04] Disallow the one-pass optimization for DELETE if the WHERE clause contains a subquery. Fix for the problem reported by forum post e61252062c9d286d. This fix is more restrictive than necessary. It could be relaxed if the subquery does not involve the table that is the subject of the DELETE. (check-in: [73f0036f04] user: drh branch: trunk, size: 12115) | |
2021-06-03
| ||
18:51 | [438c14fdf2] part of check-in [820ae3b117] Fix the truncate optimization so that PRAGMA count_changes and changes() return correct values even for a WITHOUT ROWID table. Forum post 07dedbf9a1. (check-in: [820ae3b117] user: drh branch: trunk, size: 11331) | |
2018-04-19
| ||
11:45 | [31832b0c45] 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: 11331) | |
2016-08-26
| ||
12:00 | [acc38fca8e] part of check-in [7090147903] Fix a problem in internal function sqlite3OpenTableAndIndices causing an operand of an unrelated VM instruction to be overwritten. Fix for [ef360601]. (check-in: [7090147903] user: dan branch: trunk, size: 10804) | |
2015-09-12
| ||
19:26 | [e1bcdf8926] part of check-in [eaeb2b80f6] Experimental change to use a single-pass approach for DELETE statements on non-virtual tables that do not fire triggers or require foriegn-key processing. (check-in: [eaeb2b80f6] user: dan branch: onepass-delete, size: 10496) | |
2011-08-02
| ||
00:57 | [a065b05d2e] part of check-in [9007586fda] Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. (check-in: [9007586fda] user: mistachkin branch: winopen-retry-logic, size: 10497) | |
2009-06-05
| ||
17:09 | [f7629d9eb2] part of check-in [1fef16ec2b] Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) (check-in: [1fef16ec2b] user: drh branch: trunk, size: 10518) | |
2009-04-07
| ||
09:16 | [2b33a09235] part of check-in [cdad29b582] Have OP_IdxRowid handle the case where the index entry it is reading from is deleted. (CVS 6461) (check-in: [cdad29b582] user: danielk1977 branch: trunk, size: 10578) | |
2009-04-06
| ||
17:50 | [6a872ca2ce] part of check-in [def3a01691] Test cases and minor code changes to increase coverage of btree.c. (CVS 6456) (check-in: [def3a01691] user: danielk1977 branch: trunk, size: 8915) | |
2008-04-19
| ||
20:53 | [f171c10113] part of check-in [e29b870ed0] Add some tests for journal_mode=off. Need to come up with a way of handling rollback attempts when there is no journal. (CVS 5034) (check-in: [e29b870ed0] user: drh branch: trunk, size: 8417) | |
2007-10-05
| ||
15:53 | [57533e88e8] part of check-in [a51946e66b] Changes to a couple of test scripts to handle the tcl 8.5 version of (file attributes -readonly) on mac. (CVS 4472) (check-in: [a51946e66b] user: danielk1977 branch: trunk, size: 8382) | |
2006-01-03
| ||
00:33 | [525a6953bc] part of check-in [70b228575e] The sqlite TCL command no longer returns the hex address of the sqlite3* structure. Instead there is a new command in testfixture to find that information. (CVS 2852) (check-in: [70b228575e] user: drh branch: trunk, size: 8109) | |
2005-10-05
| ||
11:35 | [e08ffb452f] part of check-in [533a85eee2] Fix an assert or memory leak that occurs when trying to EXPLAIN a statement other than a SELECT that outputs results. Examples of such statements include PRAGMA integrity_check or INSERT/DELETE/UPDATE with PRAGMA count_changes=ON. (CVS 2743) (check-in: [533a85eee2] user: drh branch: trunk, size: 8079) | |
2005-05-27
| ||
09:41 | [33e1670049] part of check-in [3ac4a212bd] Minor changes to help build and test SSE. (CVS 2487) (check-in: [3ac4a212bd] user: danielk1977 branch: trunk, size: 8009) | |
2004-11-04
| ||
04:42 | [fc29491f6a] part of check-in [c33b3a6137] All tests pass even if OMIT_TRIGGER is defined. (CVS 2053) (check-in: [c33b3a6137] user: drh branch: trunk, size: 7990) | |
2004-07-15
| ||
20:08 | [ec0b455f2d] part of check-in [c01f13267f] Added tests for sqlite3_changes after a DELETE. (CVS 1798) (check-in: [c01f13267f] user: drh branch: trunk, size: 7821) | |
2004-06-19
| ||
00:16 | [4f0c86e2be] part of check-in [d705d051be] Change the name of the TCL command from "sqlite" to "sqlite3" so that both SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) (check-in: [d705d051be] user: drh branch: trunk, size: 7639) | |
2004-06-10
| ||
05:59 | [ac14bd6df5] part of check-in [71e98d0d08] Misc fixes for test cases failing due to the new locking model. (CVS 1561) (check-in: [71e98d0d08] user: danielk1977 branch: trunk, size: 7646) | |
2004-05-27
| ||
17:22 | [ddb1d4e172] part of check-in [287f86731c] Remove the COPY command. (CVS 1477) (check-in: [287f86731c] user: drh branch: trunk, size: 7391) | |
2003-06-15
| ||
23:42 | [92256384f1] 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: 7394) | |
2003-05-04
| ||
20:42 | [1586a00574] part of check-in [fda637f453] Added tests trying (unsuccessfully) to reproduce ticket #304. (CVS 957) (check-in: [fda637f453] user: drh branch: trunk, size: 7230) | |
2002-07-19
| ||
18:52 | [5821a95a66] part of check-in [612df00401] Fix an assertion failure that occurs when attempting to delete all rows of a table while the "count_changes" pragma is turned on. Up the version number to 2.6.1. (CVS 690) (check-in: [612df00401] user: drh branch: trunk, size: 6397) | |
2001-10-15
| ||
00:44 | [c904a62129] 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: 5457) | |
2001-09-16
| ||
00:13 | [5ebb114582] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 4578) | |
2001-03-20
| ||
22:05 | [50b9b1f06c] part of check-in [daea156e24] Enhancements to the DELETE command (CVS 194) (check-in: [daea156e24] user: drh branch: trunk, size: 5121) | |
12:55 | [e3e082a9dc] part of check-in [e48b9f24fa] Open windows files in binary mode. (CVS 193) (check-in: [e48b9f24fa] user: drh branch: trunk, size: 3741) | |
2000-06-21
| ||
13:59 | [402ee3ccb6] part of check-in [e1bf96a467] :-) (CVS 104) (check-in: [e1bf96a467] user: drh branch: trunk, size: 2662) | |
2000-06-08
| ||
15:10 | [30edd2c748] part of check-in [61c381e7e6] :-) (CVS 81) (check-in: [61c381e7e6] user: drh branch: trunk, size: 2661) | |
2000-06-03
| ||
19:19 | [30451333f8] part of check-in [729d6586b8] :-) (CVS 47) (check-in: [729d6586b8] user: drh branch: trunk, size: 2659) | |
18:06 | [9b2515aa62] part of check-in [27c0678623] added default values (CVS 46) (check-in: [27c0678623] user: drh branch: trunk, size: 2305) | |
2000-05-30
| ||
03:12 | [814d53e3b0] part of check-in [20f2811fc1] :-) (CVS 12) (check-in: [20f2811fc1] user: drh branch: trunk, size: 1508) | |
00:51 | Added: [bfa5a1d39b] part of check-in [9818723ee1] :-) (CVS 11) (check-in: [9818723ee1] user: drh branch: trunk, size: 1510) | |