aboutsummaryrefslogtreecommitdiff
path: root/src/insert.c
Commit message (Collapse)AuthorAge
...
| * Fix the affinity on inserts into the ANALYZE tables. Change the affinitydrh2014-09-19
| | | | | | | | | | | | characters to be upper case, to make the P5 parameter of comparison operators easier to read. FossilOrigin-Name: 3f3ca76aea38d566a574f4403b375bdac32854ed
* | Merge support for large files on Android from trunk.drh2014-09-08
|\| | | | | FossilOrigin-Name: c2885c6bb24cc55178467e57e77bf71df58b3b13
| * Fix typos in comments. No code changes.peter.d.reid2014-09-06
| | | | | | FossilOrigin-Name: e62aab5e9290503869e1f4d5e0fefd2b4dee0a69
* | Merge all recent trunk changes, especially the fix fordrh2014-08-21
|\| | | | | | | | | | | ticket [369d57fb8e5ccdff06f1], but also the skip-scan improvement and performance improvements in the b-tree code. FossilOrigin-Name: 0b9e2c3269695713b538561d999c68097db70f0c
| * Fix a faulty assert() statement. Add comments to clarify the behavior ofdrh2014-08-21
| | | | | | | | | | | | | | the sqlite3OpenTableAndIndices() routine in insert.c. Add test cases to verify that the assert() statement is not firing inappropriately. Ticket [369d57fb8e5ccdff06f1]. FossilOrigin-Name: 7029b3404d3f5f698a496934f3a3f2972051b257
* | Merge the latest 3.8.6 beta changes from trunk.drh2014-08-06
|\| | | | | FossilOrigin-Name: 68a6d5e2f43702c78057ae2f2a7345c981d24e17
| * Refactoring: Change "pIndex->onError!=OE_None" to use a macro:drh2014-07-31
| | | | | | | | | | "IsUniqueIndex(pIndex)". Easier to understand that way. FossilOrigin-Name: e75b26ee357bb3d3c1a539b05d633ebf314726d7
* | Merge trunk changes into the sessions branch.drh2014-05-29
|\| | | | | FossilOrigin-Name: 9f18e78f039ffa89a8806810ad385bdc51bc88ed
| * Change the name of the Index.autoIndex field to Index.idxType and providedrh2014-05-27
| | | | | | | | | | | | symbolic names for the various values of that field rather than using magic numbers. FossilOrigin-Name: d16e575dacc811de0f7b58a0d1cd243678dce6c5
* | Merge recent trunk changes into the sessions branch.drh2014-05-26
|\| | | | | FossilOrigin-Name: a769c7e03e6d4163986d49652687de34d15906a0
| * 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
* | Merge all recent trunk enhancements and fixes into the sessions branch.drh2014-04-28
|\| | | | | FossilOrigin-Name: e158812c34b01ce516d26636a489509bf61d1c27
| * Allow the xfer optimization to proceed if the DEFAULT on the very firstdrh2014-04-26
| | | | | | | | | | | | column of the two tables is different. This is a refinement of the fix for ticket [f67b41381a]. FossilOrigin-Name: 349f483499dd685a8da94923b6bd810a52e5e236
| * Avoid transfering records between tables unless the default values for all ↵dan2014-04-26
| | | | | | | | | | columns are the same. Fix for [f67b41381a]. FossilOrigin-Name: f8c4c495e6de1f124d205383d4bafa46accbff5c
* | Merge the latest 3.8.4 tweaks from trunk.drh2014-03-06
|\| | | | | FossilOrigin-Name: 1ed463d91866182fbc884fb88770717ee5bf33ce
| * Fix some incorrect comments and typos in comments. Add testcase() macrosdrh2014-03-06
| | | | | | | | | | to some of the new record comparison code. FossilOrigin-Name: b83cfe899d84fe9d61540e9984321ca30401638c
* | Merge the performance enhancements of trunk (and some obscure bug fixes)drh2014-03-04
|\| | | | | | | | | into the sessions branch. FossilOrigin-Name: 7f51ad97f0b24c57453d58faf25eee68861faa23
| * Fix a harmless shadowed-variable warning.drh2014-02-20
| | | | | | FossilOrigin-Name: 824029090d1c4c4c608f67dd197961eba29c039d
| * Add the SQLITE_NOTNULL P5 code for comparison operations - really a compositedrh2014-02-19
| | | | | | | | | | | | | | | | of SQLITE_NULLEQ and SQLITE_JUMPIFNULL. This flag indicates that NULL operands are not possible and raises and assert() if NULL operands are seen. Also omit an unnecessary scan of the sqlite_sequence table when writing into an AUTOINCREMENT table. FossilOrigin-Name: d2c047f304848e49864ed8c216b48fd671fa3916
| * Add logic to do test coverage measurements on the VDBE code.drh2014-02-17
| | | | | | FossilOrigin-Name: ce184c7bb16988641d37c908d9b3042456d4be3d
| * Avoid unnecessary calls to applyAffinity() during INSERT and UPDATEdrh2014-02-17
| | | | | | | | | | | | operations, especially for table that have indices and tables for which all columns have affinity "NONE". FossilOrigin-Name: 35b4d6e938164fabaf30b504c54cfd9a69060cee
| * 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
* | Sync the latest trunk changes, and in particular the STAT4 IS NOT NULL fix.drh2014-02-11
|\| | | | | FossilOrigin-Name: b006792695d23980e1923b21915d5c1138ecf29d
| * Change the OP_Trace opcode to OP_Init and give it the ability to jump to thedrh2014-02-08
| | | | | | | | | | | | initialization code at the bottom of the program, thus avoiding the need for an extra OP_Goto. FossilOrigin-Name: 192dea97316144f15f6dd0eabff08a0bf9ef203e
| * Change the OP_InitCoroutine instruction to jump over the co-routinedrh2014-02-07
| | | | | | | | | | implementation. FossilOrigin-Name: a522f364a6b8ca6f69c353b30609a2166f6e94cf
| * Get rid of the OP_Undef and OP_IsUndef opcodes in favor of higher-leveldrh2014-02-07
| | | | | | | | | | OP_InitCoroutine and OP_EndCoroutine. FossilOrigin-Name: 1ec0e9dd4b26d9f597adc8e062317d4866c5a6a6
| * Add the OP_Undef and OP_IsUndef opcodes. With these, use the first registerdrh2014-02-07
| | | | | | | | | | | | in the result register range as the flag to indicate EOF on an INSERT from a SELECT, rather than allocating a separate boolean register for that task. FossilOrigin-Name: 6fb7448550f28a3c93053e125faeaf11de1011d0
* | Bring in all the latest trunk changes, including the Common Tabledrh2014-01-24
|\| | | | | | | | | Expressions implementation. FossilOrigin-Name: 9b43e559195680e558264c4c00d34dc9cf9d9146
| * Avoid spurious "no such table" errors in statements of the form "INSERT INTO ↵dan2014-01-18
| | | | | | | | | | tbl WITH xxx AS (...) SELECT * FROM xxx". FossilOrigin-Name: cccff8a0b427feb05cc8952a765b829e731394fd
| * Add code to handle non-recursive CTEs in the same way as SQL views.dan2014-01-13
| | | | | | FossilOrigin-Name: a26f399ba485e8127c276c5f103ec6c555e11734
| * Allow a VALUES clause to be used any place that a SELECT statement can bedrh2014-01-10
| | | | | | | | | | used. FossilOrigin-Name: c9ea7d199f06a7801ab639e7ac98ebeb98706f24
| * Avoid some unnecessary OP_SCopy operations when inserting into a tabledrh2014-01-03
| | | | | | | | | | with multiple indices. FossilOrigin-Name: 429018b19cb525a4bb0843d20955457b53900d4b
* | Merge the latest trunk changes into the sessions branch.drh2013-12-24
|\| | | | | FossilOrigin-Name: cfd110bf5db2c1993a5e2ca718648bd9c17ee22c
| * Remove an unneeded column-cache flush in aggregate SELECTdrh2013-12-19
| | | | | | | | | | and an unreachable branch in the INSERT logic. FossilOrigin-Name: ffa092e13b3781677b18418cca40e3dd1e388aed
| * Omit one or more pointless instructions that occur in between OP_NoConflictdrh2013-12-19
| | | | | | | | | | and OP_Halt. FossilOrigin-Name: 61e2f3575c4a94f9571c28fb2bd19da84b0edceb
* | Merge in performance enhancements from trunk.drh2013-11-26
|\| | | | | FossilOrigin-Name: fc9ae839569eb28eb734c52d95676c59b2e27494
| * Enhance the DELETE logic so that it can make use of WHERE_ONEPASS_DESIREDdrh2013-11-16
| | | | | | | | | | for rowid tables. FossilOrigin-Name: 8f479a72758ab6fedb171ada612b1963143c32fa
* | Merge in the WITHOUT ROWID changes. A few tests are failing now. They willdrh2013-11-11
|\| | | | | | | | | be fixed in a follow-on check-in. FossilOrigin-Name: 5addd1234ded59ce60fb633b76ac87d483377edd
| * Remove unreachable code, replacing it in most cases with assert() or NEVER()drh2013-11-11
| | | | | | | | | | macros. FossilOrigin-Name: 924d63b283a3d059838114c95d42c6feaf913529
| * Performance improvement: Avoid unnecessary seeks on REPLACE INTO for adrh2013-11-08
| | | | | | | | | | WITHOUT ROWID table. FossilOrigin-Name: fd11afa5f5c853dcac2290444b581a3fe1d4332d
| * Optimize out a NotExists/NotFound opcode that occurs in UPDATE processingdrh2013-11-08
| | | | | | | | | | | | after constraint checks if there is no possiblity that the constraint checking code might have moved the cursor. FossilOrigin-Name: 74e3ee2ee6ea89af2c12dd0bce248467fd0f1310
| * Reference count the KeyInfo object. Cache a copy of an appropriate KeyInfodrh2013-11-06
| | | | | | | | | | for each index in the Index object, and reuse that one copy as much as possible. FossilOrigin-Name: defd5205a7cc3543cdd18f906f568e943b8b3a2c
| * Remove an unused variable.drh2013-11-06
| | | | | | FossilOrigin-Name: e9c1e419b7227d86f2e1882cebf360116cdf1a13
| * Fix conflict handling for the case when the rowid uses REPLACE but otherdrh2013-11-05
| | | | | | | | | | unique constraints use FAIL or IGNORE. FossilOrigin-Name: 573cc27427af297185f11aac8dce88ca31f471ca
| * Unless the destination table is completely empty, disable the xfer ↵dan2013-11-05
| | | | | | | | | | optimization for WITHOUT ROWID tables. FossilOrigin-Name: 3877c9f50582b51817dcf3cd75d836891a34e590
| * Add tests for updates of without-rowid tables that use non-BINARY collation ↵dan2013-11-05
| | | | | | | | | | sequences for the primary key columns. And a minor bugfix to the same. FossilOrigin-Name: 99b1fa4b1664a79eae1dddce2b9a848384cdb1d7
| * Standardize the error messages generated by constraint failures to a formatdrh2013-11-05
| | | | | | | | | | | | of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. FossilOrigin-Name: 54b221929744b1bcdbcc2030fef2e510618afd41
| * Add the conflict2.test script. Fix issues discovered by this script.drh2013-11-05
| | | | | | FossilOrigin-Name: 294ed33756b06375e56c41f1088d42ee48adbdc8
| * Bug fixes in the INSERT constraint checker. Refactor the Rowid handling logicdrh2013-11-04
| | | | | | | | | | for ANALYZE with STAT3/4. FossilOrigin-Name: 1ea43c0f236792a3bc13e1cb330f5ff3402c2851
| * Correctly handle changing counting when inserting and deleting ondrh2013-11-04
| | | | | | | | | | WITHOUT ROWID tables. Add more FOREIGN KEY test cases. FossilOrigin-Name: d072bcd0a8692d590c13c2bf458454c10c12a3e2
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-21 19:00:02 +0000