This Day In History For 2020-08-14
1 Year Ago (more context)
|
2019-08-14
| ||
| 19:55 | • Closed ticket [17db54d744]: Unexpected error in DELETE with existing trigger plus 6 other changes (artifact: dd9f8d3e0e user: dan) | |
| 19:47 | • New ticket [17db54d744]. (artifact: f06e8c9d7b user: mrigger) | |
| 15:17 | Always check for reads past the end of the file on the in-memory journal driver. This used to be an assert(). (check-in: 4d41ca7d6e user: drh tags: trunk) | |
2 Years Ago (more context)
|
2018-08-14
| ||
| 21:05 | Fix a problem when renaming an IPK column that is also part of a child key. (check-in: 6e6a2bfdbb user: dan tags: edit-trigger-wrapper) | |
| 21:03 | Fix a problem when renaming an IPK column that is also part of a child key. (check-in: ad15486022 user: dan tags: alter-table-rename-column) | |
| 20:40 | Merge latest trunk and ALTER TABLE error message improvements into this branch. (check-in: 7a45802daf user: dan tags: edit-trigger-wrapper) | |
| 20:38 | Do not allow ALTER TABLE RENAME COLUMN on a virtual table. (check-in: f6d6b47271 user: drh tags: alter-table-rename-column) | |
| 20:18 | Have ALTER TABLE RENAME edit column references in CREATE VIEW statements. (check-in: db829dc1a2 user: dan tags: edit-trigger-wrapper) | |
| 19:27 | Improved error messages when an ALTER TABLE RENAME COLUMN fails due to a duplicate column name. (check-in: 37d11b8e82 user: drh tags: alter-table-rename-column) | |
| 18:12 | Merge fixes and enhancements from trunk. (check-in: dff0314b7e user: drh tags: alter-table-rename-column) | |
| 16:18 | Fix ALTER TABLE RENAME COLUMN in cases where the column being renamed is an IPK declared with a separate PRIMARY KEY clause - "CREATE TABLE x(y INTEGER, PRIMARY KEY(y))". (check-in: 32ca8418df user: dan tags: alter-table-rename-column) | |
| 15:13 | • Fixed ticket [908f001483]: UPSERT does not work like PostgreSQL plus 3 other changes (artifact: d55756a6af user: drh) | |
| 15:12 | Fix UPSERT so that it checks the target-constraint first and fires the DO UPDATE if that constraint is violated regardless of whether or not other constraints are in violation. This aligns SQLite behavior with what PostgreSQL does. Fix for ticket [908f001483982c43cdb476dfb590a1a]. (check-in: 529fb55e3d user: drh tags: trunk) | |
| 11:06 | • Ticket [908f001483] UPSERT does not work like PostgreSQL status still Open with 6 other changes (artifact: c781e55dac user: drh) | |
| 11:01 | • New ticket [908f001483]. (artifact: 3f51aa1a6a user: drh) | |
3 Years Ago (more context)
|
2017-08-14
| ||
| 23:53 | Minor size and performance optimization to sqlite3BtreeCloseCursor(). (check-in: 1696933884 user: drh tags: trunk) | |
| 18:13 | Change the internal btree routine moveToRoot() to return SQLITE_EMPTY if the table is empty or if it has pgnoRoot==0. This simplifies the callers, making them smaller and faster. The SQLITE_EMPTY result code is intercepted and changed into SQLITE_OK before surfacing in an API. (check-in: 240d57143d user: drh tags: trunk) | |
| 17:03 | Fix harmless indentation error. (check-in: 25e92baaae user: drh tags: trunk) | |
| 14:53 | • Fixed ticket [aa98619ad0]: Assertion fault on an IN operator using a constant index plus 5 other changes (artifact: a39886d07b user: drh) | |
| 14:53 | Sometimes a TK_COLUMN Expr node can have Expr.pTab==0 if it is a reference to an expression column in an index on an expression. Fix for ticket [aa98619ad08ddcab]. (check-in: d0da791ba0 user: drh tags: trunk) | |
| 14:44 | • Closed ticket [8897054d95]: lsm1 does not overwrite values for duplicate keys plus 5 other changes (artifact: 58f8ad3c86 user: drh) | |
| 14:02 | • New ticket [8897054d95]. (artifact: a4e8662c09 user: anonymous) | |
| 12:52 | • New ticket [aa98619ad0] Assertion fault on an IN operator using a constant index. (artifact: ce951f50b2 user: drh) | |
| 07:16 | Remove code for PLL support in wal mode from this branch. (check-in: 8e1b28ed3e user: dan tags: server-process-edition) | |
| 06:55 | Update this branch with latest trunk changes. (check-in: bc2498d60f user: dan tags: server-process-edition) | |
| 01:33 | Properly dequote column names in tables constructed by an aggregate SELECT. (check-in: 7e0d3e9cb0 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2015-08-14
| ||
| 23:57 | Always provide the BTREE_BULKLOAD hint, even when SQLITE_ENABLE_CURSOR_HINTS is not defined, as that hint gives a 4% performance increase. (check-in: 83a844357e user: drh tags: cursor-hints) | |
| 20:08 | Updated testing of cursor-hints. Remove the test_cursorhint.c file and associated logic in the core and do tests based purely on the newly enhanced EXPLAIN output. (check-in: bf383e665a user: drh tags: cursor-hints) | |
| 18:50 | Fix the cursor hint mechanism so that it does the right thing for indexed lookups. (check-in: 581e3d4988 user: drh tags: cursor-hints) | |
| 15:05 | Refactor the sqlite3BtreeCursorHint() interface for improved maintainability. (check-in: fc3fb5cd0d user: drh tags: cursor-hints) | |
| 12:53 | Duplicate the output of releasetest.tcl into releasetest-out.txt (check-in: 5e06a9c186 user: drh tags: trunk) | |
| 01:03 | Fix the CursorHint so that it includes the scan boundary constraints. On the expression text for the CursorHint opcode, show rowid correctly. (check-in: f0d428d13a user: drh tags: cursor-hints) | |
10 Years Ago (more context)
|
2010-08-14
| ||
| 21:21 | Adjustments for better 64K page size handling. (check-in: faf1974e2d user: drh tags: trunk) | |
| 18:32 | Add test case to e_expr.test. (check-in: db9539f2ce user: dan tags: trunk) | |
| 17:12 | Change sqlite3PagerPagecount() to return void, since the return value was always SQLITE_OK and was never used. (check-in: 7dd78eb797 user: drh tags: trunk) | |
| 16:02 | Minor simplifications to btree.c in support of full-coverage testing. (check-in: 364df6c773 user: drh tags: trunk) | |
| 12:42 | Tweaks to comments in pager.c. Fix two compiler warnings. (check-in: 68a49f7fe3 user: drh tags: trunk) | |
| 12:25 | Add test cases to e_expr.test. (check-in: d8bbab78fa user: dan tags: trunk) | |
| 05:04 | Test that it is possible to drop a trigger while there are active statements belonging to the same connection. (check-in: d4ec61e254 user: dan tags: trunk) | |
15 Years Ago (more context)
|
2005-08-14
| ||
| 20:47 | General code cleanup resulting in smaller footprint. (CVS 2595) (check-in: 98338abf9e user: drh tags: trunk) | |
| 17:53 | Split the sqlite3_complete() API out into a separate source file so that in static links where it is not used it will not take up space in the resulting binary. (CVS 2594) (check-in: 62b87751de user: drh tags: trunk) | |
| 01:34 | Declare local-use functions as static. Ticket #1363. (CVS 2593) (check-in: 94efd79088 user: drh tags: trunk) | |
| 01:20 | The case_sensitive_like pragma added. Test cases added for the LIKE optimization. (CVS 2592) (check-in: 72ee21c05e user: drh tags: trunk) | |