/ File History
Login

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

History of test/insert.test

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