SQLite

All files named ”test/insert.test”
Login

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

History for test/insert.test

2025-04-10
10:18
[97cfb30b83] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 17022)
2020-07-29
16:18
[c512f9292e] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 17035)
2019-10-26
01:43
[4e3f0de67a] part of check-in [41cc8e3dab] Add missing VdbeCoverage() macro. Fix an off-by-one error in partial index handling. New test cases. Ticket [c1e19e12046d23fe] (check-in: [41cc8e3dab] user: drh branch: trunk, size: 17034)
00:04
[d15bf96ec2] part of check-in [fbac0c65d8] If replace triggers are run during uniqueness checking, then rerun all uniqueness checks a second time using the ABORT algorithm. Fix for ticket [c1e19e12046d23fe] (check-in: [fbac0c65d8] user: drh branch: trunk, size: 15203)
2019-10-16
14:56
[c0e1b23f63] part of check-in [eea1e7aa57] If an AFTER DELETE trigger fires when a conflict row is deleted by REPLACE conflict resolution, make sure the conflict really has been resolved and that the trigger did not recreate the row before continuing. Ticket [a8a4847a2d96f5de] (check-in: [eea1e7aa57] user: drh branch: trunk, size: 14352)
2019-08-12
18:26
[72004f6a90] part of check-in [7dae7b969e] Make sure the btree cursor overflow cache is cleared when overwriting a cell in sqlite3BtreeInsert(). Ticket [3cf9bb227e9a5d32] (check-in: [7dae7b969e] user: drh branch: trunk, size: 13018)
2019-01-17
04:40
[9773604f8e] part of check-in [9a425051e7] Fix a corner-case for the logic that cause an insert of a NULL into an INTEGER PRIMARY KEY column to be converted into a valid integer key, when the NULL results from a CASE expression that lacks an ELSE clause. (check-in: [9a425051e7] user: drh branch: trunk, size: 12590)
2018-06-11
18:06
[5604b1ff56] part of check-in [0b485a571c] Fix the column cache invalidation logic in the code for ROWID uniqueness constraint checking in the INSERT command. This fixes ticket [c2432ef9089ee73bd]. (check-in: [0b485a571c] user: drh branch: trunk, size: 12365)
2014-05-23
11:48
[38742b5e96] part of check-in [9a2dd18776] Make sure sufficient VDBE registers are allocated for an INSERT...SELECT when there is an idlist on the insert table that includes an explicit rowid. Ticket [e9654505cfda93610585fde5a9bbf2e730c8a8d5] (check-in: [9a2dd18776] user: drh branch: trunk, size: 11878)
2014-02-17
15:40
[acf909b067] part of check-in [f29d194e03] Add a test case for OP_SoftNull. (check-in: [f29d194e03] user: drh branch: insert-optimization, size: 11135)
2014-02-16
01:55
[c120294273] part of check-in [aa2d8b0e81] Enhance the code generator for INSERT INTO ... SELECT so that the SELECT generates output directly in the registers that INSERT INTO will be using, in many cases, and OP_SCopy operations can thus be avoided. (check-in: [aa2d8b0e81] user: drh branch: insert-optimization, size: 10836)
2012-02-13
10:00
[489aa12a02] part of check-in [76bb649ee2] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649ee2] user: dan branch: trunk, size: 10824)
2012-01-28
15:22
[d540650825] part of check-in [eb3b6a0ceb] Add support for multiple rows of VALUES in an INSERT statement. (check-in: [eb3b6a0ceb] user: drh branch: trunk, size: 10777)
2007-04-05
11:25
[aef273dd1c] part of check-in [38af156da8] Improvements to coverage testing. (CVS 3810) (check-in: [38af156da8] user: drh branch: trunk, size: 10443)
2006-06-11
23:41
[42e26d9192] part of check-in [898ec36b41] Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) (check-in: [898ec36b41] user: drh branch: trunk, size: 9758)
2006-01-17
09:35
[b4d43f8e75] part of check-in [3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33dcb] user: danielk1977 branch: trunk, size: 9764)
2006-01-16
16:24
[51ab0b1916] part of check-in [c058f483a5] Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961) (check-in: [c058f483a5] user: danielk1977 branch: trunk, size: 9527)
2005-07-08
17:13
[b0a89e1568] part of check-in [3bb9ce5f20] Change the name of the OpenTemp opcode to OpenVirtual which is more descriptive of what it does. (CVS 2541) (check-in: [3bb9ce5f20] user: drh branch: trunk, size: 9509)
2005-05-29
14:23
[f48889e7ff] part of check-in [6bc3729783] Omit a couple of test cases if the library is compiled without subqueries. (CVS 2488) (check-in: [6bc3729783] user: danielk1977 branch: trunk, size: 9514)
2005-03-29
03:10
[1781f8ec64] part of check-in [c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d55443c] user: danielk1977 branch: trunk, size: 9481)
2005-03-21
01:20
[9a9c5774e4] part of check-in [876d09d914] Fix an infinite loop in the code generator for INSERT. Ticket #1140. (CVS 2410) (check-in: [876d09d914] user: drh branch: trunk, size: 9340)
2005-01-21
03:12
[f39cb23061] 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: 9068)
2005-01-17
08:57
[b18db896ff] part of check-in [5a9da62ae3] Fix a bug reported on the mailing list concerning a conflict between "INSERT INTO ... SELECT" statements and the "SELECT max(x) FROM tbl" optimization. (CVS 2227) (check-in: [5a9da62ae3] user: danielk1977 branch: trunk, size: 8715)
2004-11-10
15:27
[56f9c20c9a] part of check-in [0747b55882] Ensure the test suite can run with either SQLITE_OMIT_AUTOVACUUM or SQLITE_DEFAULT_AUTOVACUUM=1 defined. (CVS 2087) (check-in: [0747b55882] user: danielk1977 branch: trunk, size: 8231)
2004-11-07
13:01
[989bc184e2] part of check-in [ad433ec2b6] Reindex tests added and bugs fixed. (CVS 2075) (check-in: [ad433ec2b6] user: drh branch: trunk, size: 8204)
2004-11-03
16:27
[c571223b49] part of check-in [b11fc9b3f3] Update tests to work even if some features of the library are disabled. (CVS 2050) (check-in: [b11fc9b3f3] user: drh branch: trunk, size: 8056)
2004-06-19
00:16
[ebbab63db4] 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: 7980)
2004-05-13
05:16
[6ec3246596] part of check-in [9f2b6d9d3a] Manifest types in indices. At the moment indices use manifest typing, but some other parts of the SQL engine do not, which can lead to some strange results. (CVS 1368) (check-in: [9f2b6d9d3a] user: danielk1977 branch: trunk, size: 7987)
2004-05-11
09:50
[105e559e02] part of check-in [ad064bd429] Fix a bug that was preventing the library from opening existing files. (CVS 1358) (check-in: [ad064bd429] user: danielk1977 branch: trunk, size: 7817)
2003-06-15
23:42
[a17b7f7017] 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: 7644)
2003-06-04
16:24
[8902df72b3] part of check-in [af6f2bdf59] Fix a bug in UPDATE OR REPLACE that was introduced by check-in (999). Also clean up some compiler warnings for VC++. (CVS 1005) (check-in: [af6f2bdf59] user: drh branch: trunk, size: 7615)
12:23
[e73709f2fe] part of check-in [e813faae0e] Avoid corrupting indices when doing a REPLACE on a table with an INTEGER PRIMARY KEY that also has another index. Ticket #334. (CVS 999) (check-in: [e813faae0e] user: drh branch: trunk, size: 7420)
2003-04-03
01:50
[5697ba098e] part of check-in [087d1e83af] Use a intermediate table when inserting a TEMP table from a SELECT that reads from that same TEMP table. Ticket #275. (CVS 895) (check-in: [087d1e83af] user: drh branch: trunk, size: 7064)
2002-06-25
13:16
[a122afb869] 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: 5836)
2002-04-12
13:11
[58d44c19b3] part of check-in [cdab6dad32] Add tests to prevent a recurrance of bug #16. Also: put a hyperlink to the new ticket screen on the main page of the website. (CVS 527) (check-in: [cdab6dad32] user: drh branch: trunk, size: 5913)
2002-02-19
13:39
[c36d534a4a] 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: 5606)
2002-02-18
13:56
[68c71b2fe6] part of check-in [ec1f3fae6f] Allow general expressions in the VALUES clause of an INSERT statement. (CVS 376) (check-in: [ec1f3fae6f] user: drh branch: trunk, size: 5603)
2002-02-03
19:06
[5e75827fc2] 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: 4924)
2001-09-16
00:13
[a5c122aa72] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 4822)
2001-04-04
11:48
[dbd3bd189e] part of check-in [35a8feed0d] Added transaction support (CVS 196) (check-in: [35a8feed0d] user: drh branch: trunk, size: 5365)
2000-06-07
14:42
[66f4c3bd60] part of check-in [5d773b5d4e] :-) (CVS 1697) (check-in: [5d773b5d4e] user: drh branch: trunk, size: 4685)
2000-06-03
18:06
[b4c186ffa4] part of check-in [27c0678623] added default values (CVS 46) (check-in: [27c0678623] user: drh branch: trunk, size: 4692)
2000-05-30
03:12
[161bc67a41] part of check-in [20f2811fc1] :-) (CVS 12) (check-in: [20f2811fc1] user: drh branch: trunk, size: 3315)
00:51
Added: [e9a927aa60] part of check-in [9818723ee1] :-) (CVS 11) (check-in: [9818723ee1] user: drh branch: trunk, size: 3319)