Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/insert.test
|
2019-08-12
| ||
| 18:26 | Make sure the btree cursor overflow cache is cleared when overwriting a cell in sqlite3BtreeInsert(). Ticket [3cf9bb227e9a5d32] file: [72004f6a] check-in: [7dae7b96] user: drh branch: trunk, size: 13018 | |
|
2019-01-17
| ||
| 04:40 | 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. file: [9773604f] check-in: [9a425051] user: drh branch: trunk, size: 12590 | |
|
2018-06-11
| ||
| 18:06 | Fix the column cache invalidation logic in the code for ROWID uniqueness constraint checking in the INSERT command. This fixes ticket [c2432ef9089ee73bd]. file: [5604b1ff] check-in: [0b485a57] user: drh branch: trunk, size: 12365 | |
|
2014-05-23
| ||
| 11:48 | 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] file: [38742b5e] check-in: [9a2dd187] user: drh branch: trunk, size: 11878 | |
|
2014-02-17
| ||
| 15:40 | Add a test case for OP_SoftNull. file: [acf909b0] check-in: [f29d194e] user: drh branch: insert-optimization, size: 11135 | |
|
2014-02-16
| ||
| 01:55 | 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. file: [c1202942] check-in: [aa2d8b0e] user: drh branch: insert-optimization, size: 10836 | |
|
2012-02-13
| ||
| 10:00 | Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. file: [489aa12a] check-in: [76bb649e] user: dan branch: trunk, size: 10824 | |
|
2012-01-28
| ||
| 15:22 | Add support for multiple rows of VALUES in an INSERT statement. file: [d5406508] check-in: [eb3b6a0c] user: drh branch: trunk, size: 10777 | |
|
2007-04-05
| ||
| 11:25 | Improvements to coverage testing. (CVS 3810) file: [aef273dd] check-in: [38af156d] user: drh branch: trunk, size: 10443 | |
|
2006-06-11
| ||
| 23:41 | Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) file: [42e26d91] check-in: [898ec36b] user: drh branch: trunk, size: 9758 | |
|
2006-01-17
| ||
| 09:35 | Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [b4d43f8e] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 9764 | |
|
2006-01-16
| ||
| 16:24 | Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961) file: [51ab0b19] check-in: [c058f483] user: danielk1977 branch: trunk, size: 9527 | |
|
2005-07-08
| ||
| 17:13 | Change the name of the OpenTemp opcode to OpenVirtual which is more descriptive of what it does. (CVS 2541) file: [b0a89e15] check-in: [3bb9ce5f] user: drh branch: trunk, size: 9509 | |
|
2005-05-29
| ||
| 14:23 | Omit a couple of test cases if the library is compiled without subqueries. (CVS 2488) file: [f48889e7] check-in: [6bc37297] user: danielk1977 branch: trunk, size: 9514 | |
|
2005-03-29
| ||
| 03:10 | Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [1781f8ec] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 9481 | |
|
2005-03-21
| ||
| 01:20 | Fix an infinite loop in the code generator for INSERT. Ticket #1140. (CVS 2410) file: [9a9c5774] check-in: [876d09d9] user: drh branch: trunk, size: 9340 | |
|
2005-01-21
| ||
| 03:12 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [f39cb230] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 9068 | |
|
2005-01-17
| ||
| 08:57 | 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) file: [b18db896] check-in: [5a9da62a] user: danielk1977 branch: trunk, size: 8715 | |
|
2004-11-10
| ||
| 15:27 | Ensure the test suite can run with either SQLITE_OMIT_AUTOVACUUM or SQLITE_DEFAULT_AUTOVACUUM=1 defined. (CVS 2087) file: [56f9c20c] check-in: [0747b558] user: danielk1977 branch: trunk, size: 8231 | |
|
2004-11-07
| ||
| 13:01 | Reindex tests added and bugs fixed. (CVS 2075) file: [989bc184] check-in: [ad433ec2] user: drh branch: trunk, size: 8204 | |
|
2004-11-03
| ||
| 16:27 | Update tests to work even if some features of the library are disabled. (CVS 2050) file: [c571223b] check-in: [b11fc9b3] user: drh branch: trunk, size: 8056 | |
|
2004-06-19
| ||
| 00:16 | 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) file: [ebbab63d] check-in: [d705d051] user: drh branch: trunk, size: 7980 | |
|
2004-05-13
| ||
| 05:16 | 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) file: [6ec32465] check-in: [9f2b6d9d] user: danielk1977 branch: trunk, size: 7987 | |
|
2004-05-11
| ||
| 09:50 | Fix a bug that was preventing the library from opening existing files. (CVS 1358) file: [105e559e] check-in: [ad064bd4] user: danielk1977 branch: trunk, size: 7817 | |
|
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: [a17b7f70] check-in: [c9734c27] user: drh branch: trunk, size: 7644 | |
|
2003-06-04
| ||
| 16:24 | Fix a bug in UPDATE OR REPLACE that was introduced by check-in (999). Also clean up some compiler warnings for VC++. (CVS 1005) file: [8902df72] check-in: [af6f2bdf] user: drh branch: trunk, size: 7615 | |
| 12:23 | Avoid corrupting indices when doing a REPLACE on a table with an INTEGER PRIMARY KEY that also has another index. Ticket #334. (CVS 999) file: [e73709f2] check-in: [e813faae] user: drh branch: trunk, size: 7420 | |
|
2003-04-03
| ||
| 01:50 | Use a intermediate table when inserting a TEMP table from a SELECT that reads from that same TEMP table. Ticket #275. (CVS 895) file: [5697ba09] check-in: [087d1e83] user: drh branch: trunk, size: 7064 | |
|
2002-06-25
| ||
| 13:16 | Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file in addition to the main database file. (CVS 642) file: [a122afb8] check-in: [52eba4de] user: drh branch: trunk, size: 5836 | |
|
2002-04-12
| ||
| 13:11 | 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) file: [58d44c19] check-in: [cdab6dad] user: drh branch: trunk, size: 5913 | |
|
2002-02-19
| ||
| 13:39 | Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) file: [c36d534a] check-in: [c6e9048e] user: drh branch: trunk, size: 5606 | |
|
2002-02-18
| ||
| 13:56 | Allow general expressions in the VALUES clause of an INSERT statement. (CVS 376) file: [68c71b2f] check-in: [ec1f3fae] user: drh branch: trunk, size: 5603 | |
|
2002-02-03
| ||
| 19:06 | Fix a serious bug in INSERT when the source is a SELECT. (CVS 366) file: [5e75827f] check-in: [20ea7375] user: drh branch: trunk, size: 4924 | |
|
2001-09-16
| ||
| 00:13 | Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [a5c122aa] check-in: [4e926efe] user: drh branch: trunk, size: 4822 | |
|
2001-04-04
| ||
| 11:48 | Added transaction support (CVS 196) file: [dbd3bd18] check-in: [35a8feed] user: drh branch: trunk, size: 5365 | |
|
2000-06-07
| ||
| 14:42 | :-) (CVS 1697) file: [66f4c3bd] check-in: [5d773b5d] user: drh branch: trunk, size: 4685 | |
|
2000-06-03
| ||
| 18:06 | added default values (CVS 46) file: [b4c186ff] check-in: [27c06786] user: drh branch: trunk, size: 4692 | |
|
2000-05-30
| ||
| 03:12 | :-) (CVS 12) file: [161bc67a] check-in: [20f2811f] user: drh branch: trunk, size: 3315 | |
| 00:51 | :-) (CVS 11) file: [e9a927aa] check-in: [9818723e] user: drh branch: trunk, size: 3319 Added | |