Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 ancestors of [37e19008]
|
2017-08-18
| ||
| 08:29 | Only use indexes on expressions to optimize ORDER BY and GROUP BY if the collation sequence matches. Possible fix for [e20dd54a]. check-in: 37e19008 user: dan tags: trunk | |
|
2017-08-17
| ||
| 20:53 | Use the __builtin_clzll() function of gcc to improve the performance and reduce the size of the sqlite3LogEst() routine. check-in: a42a438c user: drh tags: trunk | |
| 19:23 | Small optimization in the Expr tree walker. check-in: 264a5e1b user: drh tags: trunk | |
| 18:54 | Size optimization in the authorizer error message generation logic. check-in: 0367a4d5 user: drh tags: trunk | |
| 18:23 | In sqlite3ViewGetColumnNames(), return the number of errors, not an error code. check-in: f13682ea user: drh tags: trunk | |
| 18:17 | The RTREE extension should return SQLITE_CORRUPT_VTAB, not just SQLITE_CORRUPT when it encounters incorrectly formatted shadow tables. check-in: 0712f057 user: drh tags: trunk | |
| 14:47 | Remove an unnecessary branch from the [be436a7f4587ce517ddc] fix. check-in: fb6ca99b user: drh tags: trunk | |
| 14:12 | Add test cases for ticket [be436a7f4587ce517] using virtual table modules fts5 and rtree. check-in: 2101b420 user: dan tags: trunk | |
| 02:26 | Defer schema resets when the query planner is running. Proposed fix for ticket [be436a7f4587ce517]. check-in: a7bc7752 user: drh tags: trunk | |
|
2017-08-16
| ||
| 19:20 | Avoid a test for CURTYPE_BTREE in sqlite3VdbeCursorMoveto() in order to reduce the size and improve the performance of OP_Column. check-in: f078deb2 user: drh tags: trunk | |
| 14:16 | Remove an unnecessary local variable from OP_Column, for a small size reduction and performance increase. check-in: 39543903 user: drh tags: trunk | |
| 11:04 | Performance improvement in the OP_Column opcode. check-in: dc98a92f user: drh tags: trunk | |
|
2017-08-15
| ||
| 14:14 | Small size and performance improvement in the OP_Column opcode. check-in: 2cf3f3de user: drh tags: trunk | |
| 03:46 | Btree optimization: New field BtCursor.pPage that points to the current page, saving a single pointer dereference on each access. check-in: 373b71d1 user: drh tags: trunk | |
|
2017-08-14
| ||
| 23:53 | Minor size and performance optimization to sqlite3BtreeCloseCursor(). check-in: 16969338 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: 240d5714 user: drh tags: trunk | |
| 17:03 | Fix harmless indentation error. check-in: 25e92baa user: drh tags: trunk | |
| 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: d0da791b user: drh tags: trunk | |
| 01:33 | Properly dequote column names in tables constructed by an aggregate SELECT. check-in: 7e0d3e9c user: drh tags: trunk | |
|
2017-08-12
| ||
| 18:31 | Add new test file fts5vocab2.test. check-in: 02174842 user: dan tags: trunk | |
| 02:16 | Update the speed-check.sh test script to append log output to the end of the cout-NAME.txt file. check-in: 14d262d6 user: drh tags: trunk | |
| 02:01 | Remove the zBase field from the StrAccum object. Resulting code is slightly smaller and faster. check-in: 6e52fa5f user: drh tags: trunk | |
| 01:09 | Size and performance micro-optimization on sqlite3SrcListIndexedBy(). check-in: 28a5aec1 user: drh tags: trunk | |
|
2017-08-11
| ||
| 18:59 | Fix compiler warnings that arise if the PAGERTRACE macro is turned on. This changes does not affect production builds. check-in: 831156a4 user: drh tags: trunk | |
| 18:55 | Improved comments in the header of the LSM1 vtab module. No code changes. check-in: aa49926d user: drh tags: trunk | |
| 13:51 | New test cases for LSM1. check-in: cb0c49cb user: drh tags: trunk | |
| 12:49 | Convert the LSM1 virtual table to be WITHOUT ROWID and get UPDATE and DELETE operations working on it. check-in: 2164031b user: drh tags: trunk | |
| 03:47 | Simplification to the like optimization logic. Remove unnecessary branches. check-in: 9466d952 user: drh tags: trunk | |
|
2017-08-10
| ||
| 20:43 | Allow WITHOUT ROWID virtual tables to be writable as long as they have exactly one column as their PRIMARY KEY. check-in: c601d128 user: drh tags: trunk | |
| 20:36 | Add the "instance" type to the fts5vocab virtual table module. For direct access to the contents of the fts5 term index. check-in: 34a7bd71 user: dan tags: trunk | |
| 19:12 | Fix a typo in csv01.test introduced by the previous commit. Closed-Leaf check-in: f38ff718 user: dan tags: writable-vtab-without-rowid | |
| 19:10 | Add extra tests to this branch. check-in: b0e3b88a user: dan tags: writable-vtab-without-rowid | |
| 17:53 | Test case for writing to a WITHOUT ROWID virtual table. The TCLVAR virtual table is modified to add a "fullname" column which is the primary key, and to accept update operations against the primary key. check-in: 6997e00c user: drh tags: writable-vtab-without-rowid | |
| 15:19 | Experimental changes that allow a WITHOUT ROWID virtual table to be writable as long as it has only a single-column PRIMARY KEY. check-in: ab9ee4c1 user: drh tags: writable-vtab-without-rowid | |
| 03:27 | Add a first draft of the "vtablog" extensions that implements a generic virtual table useful for experimentation using the command-line shell. check-in: e49279e6 user: drh tags: trunk | |
|
2017-08-09
| ||
| 22:55 | Preserve the error code from xConnect or xCreate methods in virtual table implementations when they are encountered during parsing. check-in: dcdf0913 user: drh tags: trunk | |
| 19:27 | Various bug fixes for the new LSM1 virtual table design. check-in: 94434a25 user: drh tags: trunk | |
| 18:40 | Work toward redesigning the interface to the LSM1 virtual table. check-in: 313df946 user: drh tags: trunk | |
|
2017-08-08
| ||
| 21:40 | The identifier "vsnprintf" appears to be a reserved word in recent versions of XCode, so avoid using it as a structure field. check-in: 795eede3 user: drh tags: trunk | |
| 21:30 | Fix a faulty signed/unsigned character comparison in the LIKE optimization logic. check-in: f4a4b149 user: drh tags: trunk | |
| 20:03 | Enhance the CSV virtual table extension so that it accepts the last row of the CSV file even if the last row omits the closing \n, as long as the last row has a full set of columns. check-in: 537e3be2 user: drh tags: trunk | |
|
2017-08-07
| ||
| 19:12 | Avoid casting a value larger than 2^31 to a (size_t) or (SIZE_T) on systems where it is a 32-bit type. check-in: b26d7a1c user: dan tags: trunk | |
| 19:06 | On Windows, avoid casting a value larger than 2^31 to a (SIZE_T) on systems where it is a 32-bit type. Leaf check-in: f08d63b4 user: mistachkin tags: mmap-size-limit | |
| 18:54 | Fix a problem with handling SQLITE_FCNTL_MMAP_SIZE requests with a negative parameter in os_unix.c. check-in: 4249fcf7 user: dan tags: mmap-size-limit | |
| 18:27 | Update bigmmap.test to account for builds that use "-DSQLITE_MAX_MMAP_SIZE=<integer-constant>LL". check-in: 7c8b6f1c user: dan tags: mmap-size-limit | |
| 18:13 | Avoid casting a value larger than 2^31 to a (size_t) on systems where it is a 32-bit type. check-in: 46c3085d user: dan tags: mmap-size-limit | |
| 17:28 | Fix an out-of-order test number. check-in: 38f30091 user: mistachkin tags: trunk | |
| 17:14 | Add new test file "bigmmap.test". For testing builds with -DSQLITE_MAX_MMAP_SIZE > 2GB. check-in: 17447062 user: dan tags: trunk | |
|
2017-08-05
| ||
| 16:15 | Fix a segfault in swarmvtab that could occur if there was an error in the SQL statement passed to the constructor. Add other test cases. check-in: 6ce8b7ca user: dan tags: trunk | |
| 15:49 | Microoptimization in pcache1.c makes the code slightly smaller and faster. check-in: 422cd9f3 user: drh tags: trunk | |
| 15:30 | Fix memory leak in swarmvtab. check-in: 002a9c7b user: dan tags: trunk | |
|
2017-08-04
| ||
| 20:27 | Add the swarm virtual table to the existing union virtual table module. check-in: 0f6f6f03 user: drh tags: trunk | |
| 20:15 | Add the optional non-found-callback to the swarm-vtab. Closed-Leaf check-in: a94e2f60 user: drh tags: union-vtab | |
| 17:39 | Add further test cases for swarmvtab. And minor code changes. check-in: 0f82d3b9 user: dan tags: union-vtab | |
| 16:16 | Add test cases and associated fixes for swarmvtab. check-in: 7ae20eac user: dan tags: union-vtab | |
| 08:24 | Add SQLITE_API qualifiers to public API functions in header file sqlite3rbu.h. check-in: e11e6eb1 user: dan tags: trunk | |
| 08:23 | Update script tool/mksqlite3c.tcl to avoid duplicating the SQLITE_API qualifier when copying sqlite3rbu.h into the amalgamation. Closed-Leaf check-in: 61ab112f user: dan tags: sqlite3rbu.h-fix | |
|
2017-08-03
| ||
| 20:13 | Modify swarmvtab to use a separate database connection for each database file. check-in: 1f05ad29 user: dan tags: union-vtab | |
| 15:50 | Add SQLITE_API qualifiers to public API functions in header file sqlite3rbu.h. check-in: d8637bad user: dan tags: sqlite3rbu.h-fix | |
| 15:43 | Fix some problems in RBU test cases. Also update RBU source code to better handle the trivial case where an RBU update is applied to a database zero pages in size. check-in: 7676b39b user: dan tags: trunk | |
| 00:29 | Optimization to the comparison opcodes in the byte-code engine. check-in: 654935c7 user: drh tags: trunk | |
|
2017-08-02
| ||
| 22:43 | In the KeyInfo object, refactor the nField and nXField elements into nKeyField and nAllField, which are more useful and run a little faster. check-in: aea5990e user: drh tags: trunk | |
| 19:59 | Enhance the code in unionvtab.c to also provide the "swarmvtab" virtual table module. There are still several problems on this branch. check-in: 03d94388 user: dan tags: union-vtab | |
| 19:04 | Avoid redundant calls to sqlite3ApiExit() in sqlite3_step(). check-in: 527974d4 user: drh tags: trunk | |
| 18:28 | Only attempt to invoke WAL callbacks when a transaction has committed. check-in: bcc6dacb user: drh tags: trunk | |
| 18:27 | Minor optimization on clearCell() check-in: f3c39c29 user: drh tags: trunk | |
| 15:50 | Optimizations associated with error handling in btree cursors. check-in: 49ba54e2 user: drh tags: trunk | |
| 12:38 | Remove unused token codes. check-in: c45078c0 user: drh tags: trunk | |
| 11:36 | Rearrange some of the added token codes for a very slight size decrease and performance increase. check-in: cb3742f5 user: drh tags: trunk | |
| 11:04 | Rearrange integer token values in the parser and logic in the resolveP2Values() routine for a small size reduction and performance increase. check-in: 1cad2926 user: drh tags: trunk | |
| 03:21 | Show which opcodes are jumps in the comments when generating the opcodes.h header file. check-in: eef643a3 user: drh tags: trunk | |
| 03:21 | Add the "%token" control to the lemon parser. Not currently used by SQLite. check-in: a6e4c5ae user: drh tags: trunk | |
| 02:46 | Faster implementation of resolveP2Values(). check-in: 82e46fe0 user: drh tags: trunk | |
|
2017-08-01
| ||
| 20:59 | Slightly smaller and faster by allocating Parser objects on the stack. check-in: 436a89b9 user: drh tags: trunk | |
| 19:53 | Split the OP_Last opcode into OP_Last and OP_SeekEnd. Use OP_SeekEnd to position a cursor prior to appending. Ticket [cb91bf4290c211d]. check-in: 3e02474c user: drh tags: trunk | |
| 14:16 | Take advantage of atomic-write capabilities in the F2FS filesystem when the database is stored on such a filesystem. This is a compile-time option activated using SQLITE_ENABLE_BATCH_ATOMIC_WRITE. check-in: 24190b22 user: drh tags: trunk | |
| 00:20 | Allow ATTACH and DETACH inside of a transaction. check-in: 95e8f316 user: drh tags: trunk | |
|
2017-07-31
| ||
| 19:39 | Recognize 'AMD64' as 'x64' in the TclKit batch tool for MSVC. check-in: 0c77935c user: mistachkin tags: trunk | |
| 19:26 | Sync up the MSVC autoconf makefile. check-in: b3b89f4f user: mistachkin tags: trunk | |
| 17:51 | Fix a windows-compatibility issue in the recently added schema6.test script. check-in: 14e6c302 user: drh tags: trunk | |
| 17:06 | Prevent OSSFuzz from using debugging pragmas that are disabled in default builds and which generate lots of excess output. check-in: cdc6494c user: drh tags: trunk | |
| 16:42 | Move the generation of output column names earlier, to right after name resolution and before query transformations such as flattening. This prevents the names from getting mangled by query transformations, and obviates hacks in the query flattener that attempt to work around the name mangling. The resulting code is smaller and faster and gives more consistent output. Fix to ticket [de3403bf5ae5f72ed]. check-in: ade7ddf1 user: drh tags: trunk | |
|
2017-07-30
| ||
| 19:50 | Add the schema6.test module for demonstrating schemas that generate identical and different content. check-in: ac1da06a user: drh tags: trunk | |
| 18:40 | Correctly handle an "INTEGER PRIMARY KEY UNIQUE" column in a WITHOUT ROWID table. This is a fix for ticket [bc115541132dad136], a problem discovered by OSSFuzz. check-in: 5216bfb7 user: drh tags: trunk | |
|
2017-07-29
| ||
| 17:02 | New test cases for column name generation interacting with the query flattener. Closed-Leaf check-in: 0c38dde4 user: drh tags: early-column-names | |
| 16:01 | Move the generation of output column names earlier, to right after name resolution and before query transformations such as flattening. This prevents the names from getting mangled by query transformations, and obviates hacks in the query flattener that attempt to work around the name mangling. The resulting code is smaller and faster and gives more consistent output. This is an alternative fix to ticket [de3403bf5ae5f72ed]. check-in: 09834279 user: drh tags: early-column-names | |
|
2017-07-28
| ||
| 22:22 | Update Tcl version used by the TclKit batch tool for MSVC. check-in: bcec155e user: mistachkin tags: trunk | |
| 22:13 | Fix harmless compiler warning. check-in: 3286e1a0 user: mistachkin tags: trunk | |
| 20:49 | Disable the writecrash.test module on Windows. Leaf check-in: 4c0520d4 user: drh tags: batch-atomic-write | |
| 18:16 | More precise determination of when an in-memory journal needs to be spilled to disk. check-in: 6a505bdd user: drh tags: batch-atomic-write | |
| 13:18 | Add new extended error codes for the atomic write file-controls. check-in: 94a20047 user: drh tags: batch-atomic-write | |
| 11:05 | Add new test file test/atomic.test. check-in: f9213e48 user: dan tags: batch-atomic-write | |
| 01:53 | Add the SQLITE_ENABLE_BATCH_ATOMIC_WRITE macro to ctime.c check-in: 67bad7fb user: drh tags: batch-atomic-write | |
|
2017-07-27
| ||
| 20:24 | Enhance the like optimization so that it works with an ESCAPE clause. check-in: f5d330f4 user: drh tags: trunk | |
| 19:59 | Increase the version number to 3.21.0 in anticipation for changes to go into the next release. check-in: 0645f25c user: drh tags: trunk | |
| 18:49 | Merge the pointer-passing interface changes from the 3.20 branch. check-in: c63903a4 user: drh tags: trunk | |
| 18:43 | Simplified documentation for the pointer passing interface. check-in: 2dfcd9a8 user: drh tags: branch-3.20 | |
| 18:34 | Do not set device-capabilities flags SEQUENTIAL or SAFE_APPEND for f2fs file-systems. check-in: 4477e60c user: dan tags: batch-atomic-write | |
| 17:45 | Add destructor functions for the pointer argument (NB: not the type string) to the sqlite3_bind_pointer() and sqlite3_result_pointer() interfaces. Use this new capability to resolve a pointer leak in the custom geometry function mechanism of the RTREE extension. check-in: 5a2340b8 user: drh tags: branch-3.20 | |
| 16:42 | In sqlite3_bind_pointer(), invoke the destructor if the bind index is out of range, like sqlite3_bind_blob() does. Closed-Leaf check-in: d6684d2a user: drh tags: pointer-with-destructor | |
| 15:53 | Improved implementation of the destructor on pointer-passing interfaces. check-in: 601ad679 user: drh tags: pointer-with-destructor | |