aboutsummaryrefslogtreecommitdiff
path: root/src/insert.c
Commit message (Collapse)AuthorAge
...
* Trim NULL values off the end of records when the SQLITE_ENABLE_TRIM_NULLSdrh2017-01-25
|\ | | | | | | | | | | compile-time option is used. Increase the size of the P5 operand to 16 bits. Fix a problem with short records in the sessions extension. FossilOrigin-Name: 4801bd59a01dcc11a3eb9e776e7599b36f162d2a
| * Experimental enhancement to automatically trim NULL values from the end ofdrh2017-01-25
|/ | | | | | records, for a reduced disk footprint. This change also involves increasing the P5 operand from 8 to 16 bits. FossilOrigin-Name: 118ded403b95050b74ae2b03919c43d614094a32
* Changes to allow some multi-row UPDATE statements to avoid the two-passdan2017-01-10
| | | | | approach. FossilOrigin-Name: 46db23ccd116ce5b9d949f9293be8a2818411b46
* Modify the OP_RowData opcode so that when P3!=0 it is allowed to hold andrh2017-01-09
| | | | | | ephemeral copy of the content. This avoids unnecessary memcpy() operations in the xfer-optimization and VACUUM. FossilOrigin-Name: 6e106acd74da3baa5c308a76443d2f0a7c904e5e
* Improvements to the iIdxNoSeek optimization of sqlite3GenerateRowDelete()drh2017-01-07
| | | | | | so that it is automatically disabled for BEFORE triggers but works in all other cases. FossilOrigin-Name: 3178ec4c27efc4ff84bcd17ddb17ec50a6ac96b3
* Critical fix to the previous check-in so that it works when there aredrh2017-01-07
| | | | | | BEFORE triggers that move the cursor before the OP_Delete has a chance to be applied. FossilOrigin-Name: db2c0960ffb3b396b20e0441d3edb812254c82bc
* Avoid an unnecessary btree seek while deleting an index entry due to a conflictdrh2017-01-07
| | | | | on a REPLACE operation. FossilOrigin-Name: f0495c5133d0dc04d63521136d6b9ca440792cdf
* Fix some problems with foreign key processing within REPLACE ops on WITHOUTdan2017-01-05
| | | | | ROWID tables with no triggers or auxiliary indexes. FossilOrigin-Name: c1220b1af62629d7fc2178512786d613cd7ea711
* Improved the comment on the block of code the provides the performancedrh2017-01-04
| | | | | | optimization originally added by check-in [925840cfdb]. The original check-in omitted condition 4, which was the cause of bug [30027b613b]. FossilOrigin-Name: c6506b82aa6583ccde5f673c79526d5f3920b67a
* Possible fix for 30027b61. There may still be problems surrounding foreign keydan2017-01-04
| | | | | processing. FossilOrigin-Name: 71ccb1f4c490fdebc7008e884384e7809b849742
* More changes to take advantage of the sqlite3VdbeAppendP4() method.drh2016-12-08
| | | FossilOrigin-Name: 83bc5e40af9b20afeed008bf3e2669b7ac9e2dc8
* Add the sqlite3VdbeAppendP4() method for adding P4 content to the most recentlydrh2016-12-07
| | | | | coded instruction. FossilOrigin-Name: 28883e8f3e92a8015fb5f6c8ae8580833931543d
* Remove the OP_RowKey opcode. Use OP_RowData in its place.drh2016-11-25
| | | FossilOrigin-Name: 6ac7b07a4aff2e1a9031289e3dafdb9ac0071c24
* Remove unnecessary OP_Close opcodes at the end of INSERT operations, resultingdrh2016-11-21
| | | | | in smaller and faster code. FossilOrigin-Name: abeddb6d5a4040e1d0a87a4f32ad79794ba0842b
* Fix harmless compiler warnings.drh2016-11-20
| | | FossilOrigin-Name: b3b7b42d9a4a0e7e2be8b2933328a7bec2f49a81
* Make the VACUUM command about 9% faster by avoiding unnecessary callsdrh2016-11-15
| | | | | to sqlite3BtreeMovetoUnpacked() while copying rowid tables. FossilOrigin-Name: 5ed0bd387699a0f3b477d4f3cfcb460a6a44cb84
* Avoid unnecessary calls to sqlite3ExprCacheAffinityChange() when generatingdrh2016-11-14
| | | | | OP_MakeRecord opcodes that do not change any register affinities. FossilOrigin-Name: e211c579b2f092e3283edd5fb9add7c5183bac35
* Remove obselete and unused logic in the update code generator.drh2016-11-11
| | | | | | Fix the sqlite3BtreeMovetoUnpacked() routine so that it remembers the rowid of the row that it landed on. FossilOrigin-Name: 1a587d72f981cb7064cfd8916a52a83ad9ba6074
* When doing a REPLACE on a WITHOUT ROWID table with no secondary indexes,drh2016-11-10
| | | | | | bypass the OP_NoConflict/OP_Delete sequence and directly overwrite any preexisting row, for a performance increase. FossilOrigin-Name: f7041cbb63b912f9ecad538804b6f2383efbec4e
* Remove C++ style comments. No code changes.drh2016-11-10
| | | FossilOrigin-Name: 42f8aa6231bf4ed74bebdc85aa79d23dc20b3c14
* Add the unpacked key fields to OP_IdxInsert for INSERT and UPDATE statements.drh2016-11-10
| | | FossilOrigin-Name: 67602e40f122cbb6354048a64c5d3a72b2855ec7
* Fix a simple comment typo. No changes to code.drh2016-11-09
| | | FossilOrigin-Name: 51d0aed8d63d0710e4aa8925ff18cf3c45dc9e42
* Enhance the OP_IdxInsert opcode to optionally accept unpacked key material.drh2016-11-09
| | | FossilOrigin-Name: 89d958abbac45f2ca5954080cd9e74ec9a07ebb2
* Avoid superfluous cursor seeks in "INSERT OR REPLACE" statements.dan2016-11-08
| | | FossilOrigin-Name: bec5b6d4d083556d111a89186b4f7b35b5e7cebf
* Make sure the sqlite_sequence table is updated when an optional xferdrh2016-10-03
| | | | | optimization is used. Fix for ticket [7b3328086a5c1]. FossilOrigin-Name: 81e4d4f897553f6fee540a38c3e83ceac5ba9b78
* Fix SQLITE_OMIT_AUTHORIZATION so that it compiles cleanly.drh2016-09-16
| | | FossilOrigin-Name: a3e3b3e1c57178ccd38fc7375ec1de8e8ae45372
* Fix a problem in internal function sqlite3OpenTableAndIndices causing an ↵dan2016-08-26
| | | | | operand of an unrelated VM instruction to be overwritten. Fix for [ef360601]. FossilOrigin-Name: 7090147903337864d54ecfb2cd84a3f823973167
* Add the capability to VACUUM an attached database by specifying the schemadrh2016-08-19
| | | | | | name as an argument to the VACUUM command. Since version 2.0, VACUUM has accepted an argument which was silently ignored. Now it has meaning. FossilOrigin-Name: 29d63059b4d2bb612523ac55ebfef040d054a64f
* Rename the Db.zName field to Db.zDbSName to make it more descriptive and todrh2016-08-18
| | | | | | distinguish it from all of the other "zName" variables scattered throughout the code. FossilOrigin-Name: 92a22f01343a898455fd61c3b8e7d7c954f5b569
* Merge recent enhancements from trunk. Default page size is 4096. Writesdrh2016-03-04
|\ | | | | | | | | to statement journals are avoided. FossilOrigin-Name: 456df3365e2df60e34762f2024bb551538b3f72b
| * Eliminate the need for the Column.zDflt (using Column.pDflt instead) to reducedrh2016-02-27
| | | | | | | | | | the amount of memory needed to hold the schema. FossilOrigin-Name: d8c94a46dfa94930732c2de2aa79675c5087d36e
* | Merge the changes for the 3.11.0 release candidate from trunk.drh2016-02-13
|\| | | | | FossilOrigin-Name: 4d7a802e73ef0352f840bc8d74c560afb7666ff7
| * Add testcase() macros to the CHECK constraint avoidance logic. Avoid creatingdrh2016-02-10
| | | | | | | | | | an unused VDBE label during CHECK constraint code generation. FossilOrigin-Name: 970881befd5da6cc837c474d6e917de0bf029350
| * Fix to previous check-in: Make sure CHECK constraints involving the ROWIDdrh2016-02-10
| | | | | | | | | | are not ignored when the ROWID changes. FossilOrigin-Name: 7782cb1dd5914b867caf5ff2f0f837407abbfd7a
| * Omit unnecessary CHECK constraints in UPDATE statements, when none of thedrh2016-02-10
| | | | | | | | | | columns referenced in the CHECK constraint are modified. FossilOrigin-Name: 02fbdbc782dd98f080bf4482d820f36c0ef3d519
| * Omit NOT NULL checks on unchanging columns in an UPDATE.drh2016-02-10
| | | | | | FossilOrigin-Name: 6a3aaedfb41735996470abbae6d3cd1be1f508b3
* | Merge enhancements and fixes from trunk.drh2016-02-09
|\| | | | | FossilOrigin-Name: f040a5bb62f3473fba6450c97c68f538d1df21ef
| * Make sure every co-routines has its own set of temporary registers and doesdrh2016-02-09
| | | | | | | | | | | | | | not share temporaries, since a co-routine might expect the content of a temporary register to be preserved across an OP_Yield. Proposed fix for ticket [d06a25c84454a]. FossilOrigin-Name: ca72be8618e5d466d6f35819ca8bbd2b84269959
* | Merge enhancements from trunk.drh2016-02-05
|\| | | | | FossilOrigin-Name: a533608cb0de3cbc1e28a794aab99864b8c249f4
| * Add the slightly faster sqlite3DbMallocRawNN(db,n) routine for the majoritydrh2016-02-05
| | | | | | | | | | cases where db is guaranteed to be not NULL. FossilOrigin-Name: 0a802e96ab06e2643834b83671fa8353da1a348d
| * Improvements to the way that OOM errors are processed.drh2016-02-05
| | | | | | FossilOrigin-Name: c3ef03478a5788c855b3aef385d43ae7f494f440
| * Enhance the internal sqlite3VdbeAddOpList() interface to automatically updatedrh2016-02-03
| | | | | | | | | | | | jump destinations. Use this feature to simplify the AUTOINCREMENT code generator. FossilOrigin-Name: ae8b9d2edf1b5aef6108e729754911db7682b6a3
* | Merge all recent enhancements from trunk.drh2016-02-02
|\| | | | | FossilOrigin-Name: f3f9200115caf4b356f90ec97c351d1afbcb9bf6
| * Add assert() statements on the nExtraDelete variable in vdbe.c to try to verifydrh2016-01-27
| | | | | | | | | | | | | | that the FORDELETE and IDXDELETE flags are being generated correctly. Those flags are not currently generated correctly, and so the assert()s trip on this check-in. FossilOrigin-Name: dde1db0dd2e2cf04706117629756c352b178ebb8
* | Merge recent enhancements from trunk.drh2016-01-20
|\| | | | | FossilOrigin-Name: 327af5f644a49b2f41d5456958f9d61a2b704e1c
| * Use sqlite3VdbeAddOp4() rather than a separate sqlite3VdbeChangeP4() call, fordrh2016-01-16
| | | | | | | | | | a slightly smaller and faster binary. FossilOrigin-Name: a4258cd4613c55acacb5c7b61faa3de7eb0759d2
* | Merge the latest enhancements from trunk.drh2016-01-01
|\| | | | | FossilOrigin-Name: c0be246a740c8f33a7c07e1414688364dee56ece
| * Changes to the way that the default BINARY collating sequence is recordeddrh2015-12-30
| | | | | | | | | | | | result in a slightly smaller and slightly faster executable. More work could be done to make this cleaner. FossilOrigin-Name: 2081d75767dc590b4c8457e5f8e5f18ba5f8eaa7
| * Simplification to the xfer-optimization logic.drh2015-12-30
| | | | | | FossilOrigin-Name: f35ba018da843897acca58f70541b940598bc271
| * Ensure that the Expr objects that describe indexed expressions are not modifieddrh2015-12-21
| | | | | | | | | | by code generation. Fix for an assert() problem found by Jon Metzman using AFL. FossilOrigin-Name: 34073ce87d88a02313217023ae92e15939192cd9
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-20 22:45:33 +0000