Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
43 check-ins using file tool/lemon.c version 3b5fb488
|
2018-04-20
| ||
| 20:37 | Enhance the "rbu" command line utility a bit. (check-in: 61eb516f user: dan tags: trunk) | |
| 20:09 | Fix a harmless compiler warning. (check-in: d2ab24f5 user: drh tags: trunk) | |
| 19:46 | Avoid the use of statement journals on DELETEs of a single row without triggers or foreign keys. (check-in: 20bf5800 user: drh tags: trunk) | |
| 19:32 | Avoid opening a statement journal on single-row UPDATEs without triggers or FK constraints. (check-in: 2772404b user: drh tags: trunk) | |
| 18:01 | Fix a VDBE comment on upsert. Provide an error message when upsert detects index corruption. (check-in: 279c48f6 user: drh tags: trunk) | |
| 17:50 | Add tests for name resolution in ON CONFLICT clauses. (check-in: cf253584 user: dan tags: trunk) | |
| 17:02 | Avoid unnecessary cursor seeking when performing an UPSERT. (check-in: 693a3dcb user: drh tags: trunk) | |
| 16:49 | Improved VDBE comment on UPSERT code. (Closed-Leaf check-in: 131ed95e user: drh tags: upsert-opt2) | |
| 16:27 | Minor simplification of the previous checkin. (check-in: d1906689 user: drh tags: upsert-opt2) | |
| 15:56 | Avoid unnecessary cursor seeks during upsert processing. (check-in: 7c4b6d54 user: drh tags: upsert-opt2) | |
| 15:34 | Add test cases for UPSERT. And a fix for a "REPLACE INTO ... ON CONFLICT" statement where the new row conflicts with both the IPK and the ON CONFLICT indexes. (check-in: d8eb9f8d user: dan tags: trunk) | |
| 13:18 | Enhance UPSERT so that the UPDATE uses the same set of cursors as the INSERT. (check-in: c37f39d1 user: drh tags: trunk) | |
| 00:40 | Minor simplification of the cursor allocation logic for update. (check-in: fdf71be6 user: drh tags: trunk) | |
|
2018-04-19
| ||
| 23:52 | Fix the handling of "PRAGMA count_changes=ON" with UPSERT. Also improved the implementation of count_changes in other places, without changing the behavior. (check-in: c6f71115 user: drh tags: trunk) | |
| 21:29 | Minor simplification to the upsert logic. (check-in: e657c1d6 user: drh tags: trunk) | |
| 20:18 | Avoid unnecessary OP_Goto instructions on an upsert of a table that only has a single secondary index. (Leaf check-in: 97dd21ab user: drh tags: upsert-opt) | |
| 20:06 | Modify a test case in zipfile2.test to take into account that with some platform/file-system combinations it is possible to fopen() and fread() (but not fwrite()) a directory. (check-in: 893e6089 user: dan tags: trunk) | |
| 16:52 | Add the --upsert option to the wordcount test program. (check-in: ee1e750b user: drh tags: trunk) | |
| 16:14 | Add the ext/misc/templatevtab.c template for virtual tables. This is a work-in-progress as it still needs improvements to the comments in order to be useful as a template. (check-in: 22358fb5 user: drh tags: trunk) | |
| 13:52 | Fix a problem in the new upsert implemention, discovered by OSSFuzz. (check-in: b6d5ea59 user: drh tags: trunk) | |
| 11:45 | Fix the table name aliasing on INSERT so that it occurs before the column list rather than afterwards, just as it does for PostgreSQL. Add table name aliasing to UPDATE and DELETE. (check-in: 861a2e2a user: drh tags: trunk) | |
|
2018-04-18
| ||
| 19:56 | Add the "sorter-reference" optimization, allowing SQLite to be configured so that some required values may be loaded from the database after external sorting occurs for SELECT statements with ORDER BY clauses that are not satisfied by database indexes. (check-in: ef74090a user: dan tags: trunk) | |
| 19:45 | Minor changes to test script upsert4.test. (check-in: 0cb83c84 user: dan tags: trunk) | |
| 18:19 | Fix a test case inside distinct.test. (check-in: 61cb8a39 user: drh tags: trunk) | |
| 18:18 | Improved matching of COLLATE clauses within the ON CONFLICT conflict-target. (check-in: 8f4376e5 user: drh tags: trunk) | |
| 17:56 | Add extra test cases for UPSERT. (check-in: 7ea08d07 user: dan tags: trunk) | |
| 17:52 | Fix a problem in the sqlite3ExprCompare() function that caused two dissimilar expressions to match if they have the same "COLLATE name" at the outer layer. (check-in: fb16348a user: drh tags: trunk) | |
| 16:03 | Add support for PostgreSQL UPSERT syntax and functionality. (check-in: fba24aec user: drh tags: trunk) | |
| 15:33 | Fix the build for SQLITE_OMIT_UPSERT (Closed-Leaf check-in: 32956519 user: drh tags: upsert) | |
| 11:35 | Enhance ALTER TABLE ADD COLUMN to support "DEFAULT true" and "DEFAULT false". (check-in: 594ebc69 user: drh tags: trunk) | |
| 10:44 | Add checks to the CLI that issue a warning if SQLite gets initialized prior to the last sqlite3_config() call. (check-in: 40b11734 user: drh tags: trunk) | |
| 09:16 | Fix a problem in the shell preventing it from working with SQLITE_OMIT_AUTOINIT builds. (check-in: 89209000 user: dan tags: trunk) | |
| 01:34 | Add new testcase() macros and fix a bug that was revealed when trying to cover all the new test cases. (check-in: 266a99f7 user: drh tags: upsert) | |
|
2018-04-17
| ||
| 21:59 | Remove unreachable branches. 100% MC/DC in TH3 now. (check-in: 558865d5 user: drh tags: upsert) | |
| 20:09 | Added a comment on the assert() added to the previous check-in. (check-in: 542547c1 user: drh tags: upsert) | |
| 20:06 | Fixes to the logic for constraint check reordering during upsert. Improved comments on constraint check bytecode. Add an assert that prevents the same label from being resolved more than once. (check-in: 1ddbb0ff user: drh tags: upsert) | |
| 19:29 | During PRAGMA vdbe_addoptrace=ON, show calls to sqlite3VdbeResolveLabel() in the debugging output. (check-in: 9ff07a06 user: drh tags: upsert) | |
| 18:50 | TK_REGISTER expressions nodes are probably not constant. Make sure sqlite3ExprIsConstant() knows this. (check-in: f3d91cad user: drh tags: upsert) | |
| 18:18 | Simplification to the upsert logic. (check-in: f36d07a5 user: drh tags: upsert) | |
| 18:16 | Add some more simple test cases for UPSERT. And a minor fix. (check-in: 27cd3b2f user: dan tags: upsert) | |
| 16:16 | New test cases for upsert. (check-in: 907b5a37 user: drh tags: upsert) | |
|
2018-04-16
| ||
| 14:36 | Merge the Lemon enhancement from trunk, resulting in smaller parser tables. (check-in: 641f4172 user: drh tags: upsert) | |
| 14:31 | Lemon enhancements: (1) Do not allocate space for the 'error' non-terminal if it is not used. (2) Fix an off-by-one problem so that 'unsigned char' can be used for symbol numbers if the number of symbols is 256. (check-in: 3b7801ac user: drh tags: trunk) | |