aboutsummaryrefslogtreecommitdiff
path: root/src/insert.c
Commit message (Collapse)AuthorAge
...
* | Merge the latest enhancements from trunk.drh2015-11-19
|\| | | | | FossilOrigin-Name: 7d6cfc79e7e5534ebacd980479917bc528a638f7
| * Fix a problem with VACUUM and __hidden__ columns.dan2015-11-19
| | | | | | FossilOrigin-Name: 13995756ad8b80568aa2f74387788a8cab1123ef
| * Fix problems with INSERT INTO ... SELECT ... statements that write to tables ↵dan2015-11-19
| | | | | | | | | | with __hidden__ columns. FossilOrigin-Name: 59bd0ec7d4327852ee8c0206b2c59d0a12484db8
| * Create the new TK_ASTERISK token to represent the "*" in "SELECT *". Formerlydrh2015-11-19
| | | | | | | | | | | | that operator was TK_ALL, which was also used for UNION ALL. Less confusion if they operator symbols are distinct. FossilOrigin-Name: 201ac6d449431dadc6b29faecd68b559bd64bc9f
| * Only support the magic "__hidden__" column name prefix interpretation whendrh2015-11-19
| | | | | | | | | | compiled with SQLITE_ENABLE_HIDDEN_COLUMNS. FossilOrigin-Name: 5490646b2eb74ea8bd5ab2690f69b9c707a0165f
| * Get the __hidden__ column mechanism working on views with INSTEAD OF triggers.drh2015-11-18
| | | | | | FossilOrigin-Name: 20c1e9ce75cc0b5f7456379f35a4fe24edd98088
| * If a table column name begins with "__hidden__" then do not include thatdrh2015-11-18
| | | | | | | | | | | | | | column in "*" expansions in SELECT statements, nor fill in that column in an INSERT INTO that omits the column list. <b>This branch is a proof-of-concept only and is not intended to ever be merged into trunk.</b> FossilOrigin-Name: 2dbffb3a3b20dba7d7d86c8ad2e34633f616c78a
* | Merge all the latest enhancements from trunk.drh2015-10-30
|\| | | | | FossilOrigin-Name: 395a153ff7b3c7a72f3d02b6fe76d72383f4e480
| * Modifications to pass a flag to internal routine sqlite3BtreeCursor() when a ↵dan2015-10-22
| | | | | | | | | | cursor that is used solely for deleting b-tree entries, or for obtaining the components of keys to delete from other b-trees, is opened. FossilOrigin-Name: cdc92919e600007cae5eb61223684f48a65babc0
| * Add the OP_IntCopy opcode - an optimized version of OP_SCopy that only worksdrh2015-10-15
| | | | | | | | | | for integer values. FossilOrigin-Name: 3a2f73a4924860fde8ee41ad646e7a02d29ad9d5
* | Pull in the latest 3.9.0 tweaks from trunk.drh2015-10-10
|\| | | | | FossilOrigin-Name: ed174ccf0ae615647ba026fed649d26dc9a98640
| * Compiler warning fixes: Rename some local variables from "j1" to avoid adrh2015-10-10
| | | | | | | | | | | | name collision with the j1() bessel function in the math library. Omit a dummy initializer that gcc 4.6.3 does not like. FossilOrigin-Name: 9ddef84d432813f3ece8012047d08441caa3315d
* | Merge recent enhancements from trunk, and especially the fix fordrh2015-09-30
|\| | | | | | | | | ticket [1b266395d6bc10]. FossilOrigin-Name: b2face9aa95ade96a5666c70b6b31064c1ad0977
| * Use symbolic names XN_ROWID and XN_EXPR in place of the (-1) and (-2)drh2015-09-29
| | | | | | | | | | | | | | magic numbers in Index.aiColumn[]. Add asserts to help verify that Index.aiColumn[] is always used correctly. Fix one place in FK processing where Index.aiColumn[] was not being used correctly. FossilOrigin-Name: 7d272aa62cd4cbbf4b5d04e3b918de27671e8301
| * Create the sqlite3IsToplevel(Parse*) interface to check to see if a top-leveldrh2015-09-29
| | | | | | | | | | VDBE is being coded (versus a trigger) and use that interface. FossilOrigin-Name: 59662cd2b65255a30e1a420331c07c51b644621a
* | Merge the latest trunk enhancements with this branch.dan2015-09-15
|\| | | | | FossilOrigin-Name: b7469c44be77358e02892a3abc696f7caa0dcd3b
| * Reformat some code to make it easier to merge with sessions. No logic changes.drh2015-09-15
| | | | | | FossilOrigin-Name: eade355fafec558fc13dc4b08ca0b07713a2cd84
| * Use symbolic names ONEPASS_OFF, ONEPASS_SINGLE, and ONEPASS_MULTI for thedrh2015-09-14
| | | | | | | | | | various modes of the one-pass optimization. FossilOrigin-Name: 16e56bdadef903c6439a487f2683388aeeb0c625
| * Experimental change to use a single-pass approach for DELETE statements on ↵dan2015-09-12
| | | | | | | | | | non-virtual tables that do not fire triggers or require foriegn-key processing. FossilOrigin-Name: eaeb2b80f6f8f83679c8323a81bb39570ec946fe
* | Merge the latest trunk enhancements.drh2015-09-14
|\| | | | | FossilOrigin-Name: 22ce9218fb2bb56cc5dd4e32077a16f669250d5f
| * Merge enhancements from trunk.drh2015-09-03
| |\ | | | | | | FossilOrigin-Name: 1ab10cbf27245961b40eda1ce70f35646f0a9966
| * | Activate the ability to use expressions in indexes in a query. There are somedrh2015-08-27
| | | | | | | | | | | | | | | test failures, but mostly this seems to work. FossilOrigin-Name: 42f93f582eccd8a778189aa6c113874f995ab751
| * | Merge enhancements from trunk.drh2015-08-26
| |\ \ | | | | | | | | FossilOrigin-Name: ec6ddb3d481d005c304a26c948c9c808586750e9
| * \ \ Merge trunk enhancements.drh2015-08-25
| |\ \ \ | | | | | | | | | | FossilOrigin-Name: e8b02902c48f3668dcff7b1767347ac7ef3c971e
| * | | | Add code to maintain indexes with expression arguments across DELETE, INSERT,drh2015-08-25
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | and UPDATE statements. Legacy tests pass, but the new code paths are still largely untested. The query planner currently makes no effort to use expression indexes. FossilOrigin-Name: efaabdb71626bdc03768e87e186c72f6f3da75b2
* | | | | Merge recent trunk enhancements.drh2015-09-03
|\ \ \ \ \ | | |_|_|/ | |/| | | FossilOrigin-Name: 6a513c05850949900f396c7a61accb97cc6d2af5
| * | | | Add the sqlite3VdbeLoadString() and sqlite3VdbeMultiLoad() routines to helpdrh2015-09-03
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | with code generation, especially on PRAGMAs. Rename sqlite3VdbeAddGoto() to just sqlite3VdbeGoto(). FossilOrigin-Name: 847387ec8e6fef283899578fb232b2c23b00ee5b
| * | | | Add the sqlite3VdbeAddGoto(v,i) routine as a shorthand fordrh2015-09-02
| | |_|/ | |/| | | | | | | | | | | | | | sqlite3VdbeAddOp2(v,OP_Goto,0,i). FossilOrigin-Name: be78f413df1b0d874b44a866ef6bf17543d7e8a2
* | | | Merge recent enhancements from trunk.drh2015-09-01
|\| | | | | | | | | | | FossilOrigin-Name: cb77236673e30af1e8749d984dedecc8f901b255
| * | | Move sqlite3IndexColumnAffinity() inside of SQLITE_ENABLE_STAT3_OR_STAT4.drh2015-08-25
| | |/ | |/| | | | FossilOrigin-Name: b3732a4e1b42a86675d89766cb8089914e2fab9a
| * | Use the sqlite3IndexColumnAffinity() routine to quickly and correctly find thedrh2015-08-25
| |/ | | | | | | | | affinity of an index column. FossilOrigin-Name: 1ee089a72d789002a0a377347fc51e08ab32fb14
| * Remove some redundant code: Call sqlite3ResolveExprListNames() rather thandrh2015-08-24
| | | | | | | | | | calling sqlite3ResolveExprNames() in a loop - in two places. FossilOrigin-Name: bdaf66465b6b1bdad10c08d9527b98e7000a41e4
* | Merge recent trunk enhancements, include table-valued functions.drh2015-08-20
|\| | | | | FossilOrigin-Name: e9196d566690de0e9815f8cd85be7844322b5a79
| * Fix the xfer optimization for WITHOUT ROWID tables so that it correctlydrh2015-07-28
| | | | | | | | | | updates the change count returned by sqlite3_changes(). FossilOrigin-Name: eff43715d1a3a9ce3fe5da194dbb76ec0c06e13c
* | Merge recent trunk enhancements and fixes.drh2015-06-11
|\| | | | | FossilOrigin-Name: c39cb0e2571f58c87053de009e2c135d71b2c3af
| * When generating code for partial indexes, be sure not to modify thedrh2015-06-11
| | | | | | | | | | index condition expression in the schema. FossilOrigin-Name: e63d01c69c3e50f49ee3022a519c4f3e91f00520
| * Rename SQLITE_AFF_NONE to SQLITE_AFF_BLOB.drh2015-06-02
| | | | | | FossilOrigin-Name: bce3f04186cd2d69414a5a98b5b77dc8f060554a
* | Merge enhancements from trunk, including the new sqlite3_value_dup() API anddrh2015-05-22
|\| | | | | | | | | | | the addition of the apSqlParam field in the sqlite3_rtree_query_info object of R-Tree. FossilOrigin-Name: cdc0ca6fb36e787b981fb544a27c6df838f85704
| * Fix two faulty assert statements discovered by fuzzing.drh2015-05-22
| | | | | | FossilOrigin-Name: 799817bfb2bc95963c0e0d70063c4cb15c94ef74
* | Merge the latest trunk enhancements and fixes into the sessions branch.drh2015-04-23
|\| | | | | FossilOrigin-Name: 4e5f17d189eb0578a544c21fc150f9e2ee3428e3
| * Merge updates from trunk.mistachkin2015-04-19
| |\ | | | | | | FossilOrigin-Name: 59d1a3bb6050a812c4eb0d25ac53327081b9efed
| * | Fix harmless compiler warnings seen with MSVC 2015.mistachkin2015-04-19
| | | | | | | | | FossilOrigin-Name: d05becd873a03a366843a34e7f4c732dd8f88c86
* | | Merge all recent trunk enhancements and fixes into the sessions branch.drh2015-04-20
|\ \ \ | | |/ | |/| FossilOrigin-Name: b8ef1cdee307441e8d97b4bfc21f8547692eea9f
| * | Fix a broken assert() and comparison for INSERT INTO ... SELECT when thedrh2015-04-19
| | | | | | | | | | | | | | | SELECT uses an unknown collating sequence. FossilOrigin-Name: e73ac0cbac257d2d2b28e51423e30d7449b6c7b5
| * | Bring comments on the INSERT code generator up-to-date. Fix the INSERT codedrh2015-04-19
| |/ | | | | | | | | | | generator so that it correctly handles inserts from a SELECT into a virtual table with non-terminal hidden columns. FossilOrigin-Name: 4ac81fac6c6302c042be3df493a41630b733fff0
* | Merge all recent trunk fixes and enhancements into the sessions branch.drh2015-04-15
|\| | | | | FossilOrigin-Name: e65e65f9bc9b4bf5c9dd6e3a77a0d5f03c40e006
| * Remove an unreachable branch from the VACUUM logic.drh2015-04-13
| | | | | | FossilOrigin-Name: 65ace4b062d9454a296c5a1aa7ea7316b1507ad4
* | Merge all recent trunk enhancements into the sessions branch.drh2015-04-12
|\| | | | | FossilOrigin-Name: 5f14f34f072921e229bc20a5185c0cdb3f464c04
| * When vacuuming an index that uses no collations other than BINARY, assume ↵dan2015-04-01
| | | | | | | | | | that the order of index entries will not be changed by the VACUUM. FossilOrigin-Name: e403460b96814ac8cb976d58b27939b3bd3c61f9
* | Merge all recent trunk changes into the sessions branch.drh2014-09-21
|\| | | | | FossilOrigin-Name: 6406b77f2c447751a2fbb16f01c61cdcfd6af59e