Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
59 check-ins using file src/btree.c version 7271a120
|
2020-03-30
| ||
| 11:17 | Fix "GCC_VESRION" typo in wal.c. (check-in: fbd93787 user: dan tags: trunk) | |
|
2020-03-28
| ||
| 19:02 | Enhancements to the SQLITE_ENABLE_SETLK_TIMEOUT compile-time option to avoid rare deadlocks on recovery. (check-in: 06885e9a user: drh tags: trunk) | |
| 12:01 | MSVC does not allow constant expressions as initializers for constants with /fp:strict. (check-in: 076658e5 user: drh tags: trunk) | |
|
2020-03-27
| ||
| 17:23 | Modifications to the way blocking locks are used in SQLITE_ENABLE_SETLK_TIMEOUT builds so that multiple processes or threads may not deadlock when operating on a single database. (Closed-Leaf check-in: c516027d user: dan tags: setlk-deadlock-fix) | |
|
2020-03-26
| ||
| 16:48 | Add the tables_used() table-valued function as a variation on bytecode(). (check-in: 6283c677 user: drh tags: bytecode-function) | |
| 15:28 | Merge updates from trunk. (check-in: d7db0910 user: drh tags: bytecode-function) | |
| 00:29 | Reinstate the optimization that converts "x IN (y)" into "x==y". (check-in: 27936e68 user: drh tags: trunk) | |
|
2020-03-25
| ||
| 20:31 | For the LIKE pattern in the .dump command of the CLI, accept backslash as an escape character. (check-in: 029ceea6 user: drh tags: trunk) | |
| 12:50 | Enhance the ".dump" command in the CLI so that it accepts multiple LIKE pattern arguments and shows the union of all matching tables. (check-in: 45fba3d7 user: drh tags: trunk) | |
|
2020-03-24
| ||
| 18:41 | Optimize the "subprog IS NULL" constraint. (check-in: ca8c5f02 user: drh tags: bytecode-function) | |
| 17:52 | Fix a memory leak. (check-in: c9f3405e user: drh tags: bytecode-function) | |
| 13:27 | Provide content for the bytecode.subprog column. (check-in: df893364 user: drh tags: bytecode-function) | |
|
2020-03-23
| ||
| 23:17 | Fix the build so that it works even without SQLITE_ENABLE_EXPLAIN_COMMENTS. (check-in: 5896cbf4 user: drh tags: bytecode-function) | |
| 20:58 | The bytecode() function now runs and sometimes works, but it untested and there are known problems. (check-in: 6819b86e user: drh tags: bytecode-function) | |
| 19:14 | Further simplification and modularization of the EXPLAIN logic. (check-in: aee1c12f user: drh tags: bytecode-function) | |
| 17:24 | Begin breaking appear the sqlite3VdbeList() routine into subroutines that can be reused by the bytecode() table. (check-in: 2c4dd79f user: drh tags: bytecode-function) | |
| 15:49 | Infrastructure for the bytecode() table-valued function. The function itself is not yet implemented. (check-in: 2795f0d6 user: drh tags: bytecode-function) | |
|
2020-03-21
| ||
| 23:10 | Fix to the recomputation of the colUsed field added by check-in [a9bb71ba708ba722]. This fixes ticket [5829597ac43811e3]. (check-in: 5d14a1c4 user: drh tags: trunk) | |
| 22:03 | Enhance the treeview system to show the SrcList_item.colUsed field for FROM clause elements. (check-in: 8a5c539b user: drh tags: trunk) | |
| 20:58 | Simplify some of the code modified by the previous commit. (check-in: 04abadb5 user: dan tags: trunk) | |
| 15:41 | Ensure that "main" can always be used to refer to the main database, even if it has been renamed using SQLITE_DBCONFIG_MAINDBNAME. (check-in: 682b426f user: dan tags: trunk) | |
| 15:10 | Consolidate some code on this branch. (Closed-Leaf check-in: a85c63da user: dan tags: main-alias-fix) | |
| 15:07 | Change a bitfield in sqlite3_stmt into an unsigned character, for slightly smaller code and better performance. (check-in: 0d4d3c64 user: drh tags: trunk) | |
| 14:22 | Performance optimization in sqlite3VdbeMakeReady(). (check-in: aa92f9b9 user: drh tags: trunk) | |
| 14:05 | Merge updates from trunk. (Leaf check-in: 2383aa2c user: drh tags: explain-improvements) | |
| 03:40 | Back out the sqlite3_stmt_mode() and EXPLAIN TABLES enhancements, but keep the other miscellaneous improvements to EXPLAIN that were implemented while adding the above: Turn magic numbers into symbolic constants. Add the sqlite3MemPrint() interface accessible to the debugger. Improve the performance and reduce the code size. (check-in: 62aece66 user: drh tags: explain-improvements) | |
| 00:05 | Recompute the set of columns used for each table when the table is involved in query flattening. (check-in: a9bb71ba user: drh tags: trunk) | |
|
2020-03-20
| ||
| 20:54 | Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias. (check-in: 75c85ca3 user: dan tags: main-alias-fix) | |
| 20:18 | Avoid an undefined integer overflow in fts3 by detecting data structure corruption earlier. (check-in: 86e98ddc user: dan tags: trunk) | |
| 20:00 | Add the EXPLAIN TABLES syntax that uses SQLITE_STMTMODE_TABLELIST. Seems to work, but not well-tested. (Leaf check-in: e7343ce7 user: drh tags: sqlite3_stmt_mode) | |
| 17:49 | Further simplification of the EXPLAIN logic. Fix the test errors from the previous check-in. (check-in: 5eaba9af user: drh tags: sqlite3_stmt_mode) | |
| 16:13 | Revamp the EXPLAIN infrastructure to facilitate sqlite3_stmt_mode(). The currently code mostly works, but there are test failures. This is an incremental check-in. (check-in: e9e17e21 user: drh tags: sqlite3_stmt_mode) | |
|
2020-03-19
| ||
| 21:17 | Initial code for a proposed new sqlite3_stmt_mode() API. This is an incomplete snapshot of a work-in-progress. (check-in: 3cf7537b user: drh tags: sqlite3_stmt_mode) | |
| 18:13 | Change the ESCAPE clause on the LIKE operator to override wildcard characters, in order to match the behavior of PosgreSQL. (check-in: 11e0844f user: drh tags: trunk) | |
| 17:27 | Fix an integer overflow problem with the dbstat virtual table that comes up when trying to analyze a corrupt database. (check-in: 1d64f4a8 user: drh tags: trunk) | |
| 15:57 | Fix a typo in a comment. No changes to code. (check-in: 3a51919a user: drh tags: trunk) | |
|
2020-03-17
| ||
| 13:07 | Improved bytecode comments for the ANALYZE command. (check-in: c38ea413 user: drh tags: approximate-analyze) | |
| 12:37 | Merge changes from trunk. (check-in: 93d71026 user: drh tags: approximate-analyze) | |
|
2020-03-16
| ||
| 18:52 | Fix handling of window functions in aggregate queries that have no GROUP BY clause. Also remove a faulty assert causing the error reported in [618156e3]. (check-in: 38e3dd38 user: dan tags: trunk) | |
| 03:07 | At the end of the right-hand table loop of a LEFT JOIN that uses an IN operator in the ON clause, put the OP_IfNoHope operator after the OP_IfNotOpen operator, not before, to avoid a (harmless) uninitialized register reference. Ticket [82b588d342d515d1] (check-in: 8b437b47 user: drh tags: trunk) | |
|
2020-03-12
| ||
| 17:54 | Remove stray comment characters at the end of an #ifdef that were accidently left in the previous check-in. (check-in: ea914bec user: drh tags: trunk) | |
| 17:28 | Fix comments and strengthen assert() statements associated with the OPFLAG_SEEKEQ and BTREE_SEEK_EQ flags. (check-in: 23174921 user: drh tags: trunk) | |
|
2020-03-11
| ||
| 20:03 | Merge enhancements from trunk. (check-in: 4945a662 user: drh tags: approximate-analyze) | |
| 19:56 | Do not factor out constant functions into the initialization section of a prepared statement, because even though they are constant, they can still throw exceptions. Instead, put such functions in an OP_Once block. This fixes ticket [3c9eadd2a6ba0aa5] and causes COALESCE() and CASE...END to be short-circuit. (check-in: c5f96a08 user: drh tags: trunk) | |
| 19:41 | Rename sqlite3ExprCodeAtInit() to sqlite3ExprCodeRunJustOnce(). Other changes to make the new code cleaner. Test cases added. (Closed-Leaf check-in: d7f18489 user: drh tags: do-not-factor-functions) | |
| 17:58 | Do not factor out constant functions into the initialization section at the end of the prepared statement, be cause if they throw an exception, it will abort the statement even if the function is never called. Better to put constant functions in an OP_Once block. (check-in: 97a18a5c user: drh tags: do-not-factor-functions) | |
| 02:04 | This variant to the fix for ticket [e0c2ad1aa8a9c691] uses fewer CPU cycles. (check-in: fb5a8a9e user: drh tags: trunk) | |
|
2020-03-10
| ||
| 22:55 | Merge updates from trunk. (check-in: e05f743f user: drh tags: approximate-analyze) | |
| 19:24 | Enhanced detection logic for preventing the use of static schema expressions by code generating routines. (check-in: 5f60b527 user: drh tags: trunk) | |
| 18:55 | Further changes to ensure that expressions held in table and index definitions do not get passed down into code generator logic where they might be modified. (check-in: f45f5de0 user: drh tags: trunk) | |
| 13:35 | Make a copy of the expression that defines a value of a generated column before sending it to the code generator routines. (check-in: 03d201c0 user: drh tags: trunk) | |
| 11:50 | Apply the correct affinity transformations when pulling values off of the sorter index used for GROUP BY. Ticket [e0c2ad1aa8a9c691] (check-in: 101f7dea user: drh tags: trunk) | |
| 02:57 | The sqlite3ExprCodeFactorable() routine should make a copy of non-factorable expressions, as they might be coming from a DEFAULT or generated column in a table constraint. (check-in: a2d6f108 user: drh tags: trunk) | |
| 01:24 | Background work for experiments trying to enhance ANALYZE so that it runs off of samples of the entire index and does not need to read the entire index. (check-in: 29d1cc5c user: drh tags: approximate-analyze) | |
|
2020-03-09
| ||
| 18:26 | Cleaner separation of the STAT4-specific logic in the implementation of ANALYZE. (check-in: 3df07e5a user: drh tags: trunk) | |
| 15:39 | Enhancements to the ".import" command of the CLI. (check-in: cab1834c user: drh tags: trunk) | |
| 03:21 | Fix typos in RowSet. (check-in: 86465c08 user: pdr tags: trunk) | |
| 01:02 | Fix typos in the Lemon documentation. (check-in: 35f1f151 user: drh tags: trunk) | |
|
2020-03-08
| ||
| 13:33 | Avoid a redundant NULL check (check-in: 25dc53f6 user: pdr tags: trunk) | |