aboutsummaryrefslogtreecommitdiff
path: root/test/insert.test
Commit message (Collapse)AuthorAge
* Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
| | | FossilOrigin-Name: 20acd630b91609725794ce84f9eda01d5f3c898407f0948264830851d25ccaa6
* Add missing VdbeCoverage() macro. Fix an off-by-one error in partial indexdrh2019-10-26
| | | | | handling. New test cases. Ticket [c1e19e12046d23fe] FossilOrigin-Name: 41cc8e3dab998f7efc898d18837ca7fdac94ea3f89954990c5231456bf725fee
* If replace triggers are run during uniqueness checking, then rerun alldrh2019-10-26
| | | | | | uniqueness checks a second time using the ABORT algorithm. Fix for ticket [c1e19e12046d23fe] FossilOrigin-Name: fbac0c65d8464b126d385262d176864add55452ec9e3d5eb76ffee06e820cb9c
* If an AFTER DELETE trigger fires when a conflict row is deleted by REPLACEdrh2019-10-16
| | | | | | | conflict resolution, make sure the conflict really has been resolved and that the trigger did not recreate the row before continuing. Ticket [a8a4847a2d96f5de] FossilOrigin-Name: eea1e7aa57e74c4329003f4550168e2aed9e33d2301a3ba84b10781a9cebbc1b
* Make sure the btree cursor overflow cache is cleared when overwritingdrh2019-08-12
| | | | | a cell in sqlite3BtreeInsert(). Ticket [3cf9bb227e9a5d32] FossilOrigin-Name: 7dae7b969ed314605a3a2da2cfdce4d81152740f5d3bfbc2a6e311b13ee325a7
* Fix a corner-case for the logic that cause an insert of a NULL into andrh2019-01-17
| | | | | | 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. FossilOrigin-Name: 9a425051e7ba59e797636f5cf32b5f6efafdb21c8d5300e099b8008b829c1439
* Fix the column cache invalidation logic in the code for ROWID uniquenessdrh2018-06-11
| | | | | | constraint checking in the INSERT command. This fixes ticket [c2432ef9089ee73bd]. FossilOrigin-Name: 0b485a571c805a5bc431a231a196ff6034342c6548d92b09c52814dd57c89c75
* Make sure sufficient VDBE registers are allocated for an INSERT...SELECTdrh2014-05-23
| | | | | | when there is an idlist on the insert table that includes an explicit rowid. Ticket [9654505cfda93610585fde5a9bbf2e730c8a8d5] FossilOrigin-Name: 9a2dd18776cc7003752980be0a0920a8799e5f35
* Add a test case for OP_SoftNull.drh2014-02-17
| | | FossilOrigin-Name: f29d194e03d6bcc78bf883b77e591dbccada02f0
* Enhance the code generator for INSERT INTO ... SELECT so that the SELECTdrh2014-02-16
| | | | | | generates output directly in the registers that INSERT INTO will be using, in many cases, and OP_SCopy operations can thus be avoided. FossilOrigin-Name: aa2d8b0e8154dd2f5e2c837dc11ab362b083495b
* Changes to various test scripts so that veryquick.test runs with ↵dan2012-02-13
| | | | | OMIT_COMPOUND_SELECT defined. FossilOrigin-Name: 76bb649ee2633226324130f5898622c348f93769
* Add support for multiple rows of VALUES in an INSERT statement.drh2012-01-28
| | | FossilOrigin-Name: eb3b6a0ceb8bfb9fd59ff5fec420f863a9b5c4e4
* Improvements to coverage testing. (CVS 3810)drh2007-04-05
| | | FossilOrigin-Name: 38af156da83a8469080ddb75a9a286be33ff6bef
* Progress toward CREATE VIRTUAL TABLE. Still not even close to working... ↵drh2006-06-11
| | | | | (CVS 3211) FossilOrigin-Name: 898ec36b4102aaa03979f8f5c510936e57e2ae48
* Test suite fixes for builds that define OMIT symbols. (CVS 2962)danielk19772006-01-17
| | | FossilOrigin-Name: 3a54a33dcb7e765ee3773397407e8929a8cfe1a9
* Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS ↵danielk19772006-01-16
| | | | | 2961) FossilOrigin-Name: c058f483a52c8043178b6329aa5e58bedf0c8277
* Change the name of the OpenTemp opcode to OpenVirtual which is moredrh2005-07-08
| | | | | descriptive of what it does. (CVS 2541) FossilOrigin-Name: 3bb9ce5f20d0a6bc19df31df9b8e82044c3e6004
* Omit a couple of test cases if the library is compiled without subqueries. ↵danielk19772005-05-29
| | | | | (CVS 2488) FossilOrigin-Name: 6bc372978364a1a4bfa14732a818a6bba613b1e3
* Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427)danielk19772005-03-29
| | | FossilOrigin-Name: c41d55443c2dd532147962b87f542fb7d37075fd
* Fix an infinite loop in the code generator for INSERT. Ticket #1140. (CVS 2410)drh2005-03-21
| | | FossilOrigin-Name: 876d09d9145775956913e975c29e81d7553839ac
* Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT ↵danielk19772005-01-21
| | | | | macros) is defined. (CVS 2251) FossilOrigin-Name: bb0254ab14417f0ab40f10f37cb63a60507f070a
* Fix a bug reported on the mailing list concerning a conflict between "INSERT ↵danielk19772005-01-17
| | | | | INTO ... SELECT" statements and the "SELECT max(x) FROM tbl" optimization. (CVS 2227) FossilOrigin-Name: 5a9da62ae303800ded99942aed30eadeb3863da3
* Ensure the test suite can run with either SQLITE_OMIT_AUTOVACUUM or ↵danielk19772004-11-10
| | | | | SQLITE_DEFAULT_AUTOVACUUM=1 defined. (CVS 2087) FossilOrigin-Name: 0747b55882cf218c03b443e1eadec9eb19889554
* Reindex tests added and bugs fixed. (CVS 2075)drh2004-11-07
| | | FossilOrigin-Name: ad433ec2b6bd34e33dfe119668f38fbb978e889d
* Update tests to work even if some features of the library are disabled. (CVS ↵drh2004-11-03
| | | | | 2050) FossilOrigin-Name: b11fc9b3f3a2711f98e7e45724aa1d30081197f3
* Change the name of the TCL command from "sqlite" to "sqlite3" so that bothdrh2004-06-19
| | | | | SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) FossilOrigin-Name: d705d051bed2b92b6c3bbcc75fe5b056633b9c31
* Manifest types in indices. At the moment indices use manifest typing, butdanielk19772004-05-13
| | | | | | some other parts of the SQL engine do not, which can lead to some strange results. (CVS 1368) FossilOrigin-Name: 9f2b6d9d3a07e25fcdb7e8290da7a182a65c37b2
* Fix a bug that was preventing the library from opening existing files. (CVS ↵danielk19772004-05-11
| | | | | 1358) FossilOrigin-Name: ad064bd429602fcac26b377841da90a1a56f5966
* Enhance the "PRAGMA integrity_check" command to verify that all indices aredrh2003-06-15
| | | | | | | 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) FossilOrigin-Name: c9734c27074d2039a1896a8c6965c08d03711b13
* Fix a bug in UPDATE OR REPLACE that was introduced by check-in (999).drh2003-06-04
| | | | | Also clean up some compiler warnings for VC++. (CVS 1005) FossilOrigin-Name: af6f2bdf59fb621ff3e1d061e429f01ebd7d0b42
* Avoid corrupting indices when doing a REPLACE on a table with andrh2003-06-04
| | | | | INTEGER PRIMARY KEY that also has another index. Ticket #334. (CVS 999) FossilOrigin-Name: e813faae0e4086571d13c769f793add7f1f979af
* Use a intermediate table when inserting a TEMP table from a SELECT thatdrh2003-04-03
| | | | | reads from that same TEMP table. Ticket #275. (CVS 895) FossilOrigin-Name: 087d1e83af12b3a9aedd4945f02774a1043b1eb4
* Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file indrh2002-06-25
| | | | | addition to the main database file. (CVS 642) FossilOrigin-Name: 52eba4de301121f254174b74042015bf6069ef11
* Add tests to prevent a recurrance of bug #16. Also: put a hyperlink to the newdrh2002-04-12
| | | | | ticket screen on the main page of the website. (CVS 527) FossilOrigin-Name: cdab6dad323dd1e95ec8b7684a7c4b06c75905e0
* Change the name of the sanity_check PRAGMA to "integrity_check" and makedrh2002-02-19
| | | | | it available on all compiles. (CVS 381) FossilOrigin-Name: c6e9048e66c8d8e2d5f6c62aa724eef3e9d9f572
* Allow general expressions in the VALUES clause of an INSERT statement. (CVS 376)drh2002-02-18
| | | FossilOrigin-Name: ec1f3fae6f8cd8466892cd370e1802e492a76e6e
* Fix a serious bug in INSERT when the source is a SELECT. (CVS 366)drh2002-02-03
| | | FossilOrigin-Name: 20ea737536700b016385c70105a2af8b2bffce2b
* Disclaimed copyright. Preparing for release 2.0. (CVS 250)drh2001-09-16
| | | FossilOrigin-Name: 4e926efe2b59adfec4086eb1d2ba830238facb4c
* Added transaction support (CVS 196)drh2001-04-04
| | | FossilOrigin-Name: 35a8feed0d10e780c477f7440fbe80637fcf9906
* :-) (CVS 1697)drh2000-06-07
| | | FossilOrigin-Name: 5d773b5d4e9c23b81f53afd0cef7bd2300fff329
* added default values (CVS 46)drh2000-06-03
| | | FossilOrigin-Name: 27c0678623de37f3166cb9952989fd03484cdb8d
* :-) (CVS 12)drh2000-05-30
| | | FossilOrigin-Name: 20f2811fc19f937ed03bdb0e9d87a40c75452b17
* :-) (CVS 11)drh2000-05-30
FossilOrigin-Name: 9818723ee127bc535e79f6876546cc027b4999e6
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-19 03:47:17 +0000