Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 ancestors of [9afd7a2f]
|
2017-06-15
| ||
| 13:07 | Fix harmless compiler warnings in the shell.c file check-in: 9afd7a2f user: drh tags: trunk | |
| 12:50 | Improvements to the ".tables" command in the command-line shell so that it shows the name of all schemas if the name is anything other than "main". check-in: c7f778b7 user: drh tags: trunk | |
| 12:21 | In the command-line shell, enhance the ".schema" command show that it shows the schema for ATTACH-ed databases in addition to "main". check-in: 48e08628 user: drh tags: trunk | |
| 00:52 | Enhance the sqlite3_analyzer.exe utility so that it computes and shows the number of bytes of metadata on btree pages and per table and index entry. check-in: 43ad41ef user: drh tags: trunk | |
|
2017-06-13
| ||
| 16:52 | Fix sqlite3rbu_close() so that the pzErrmsg parameter may be passed NULL. check-in: c433672d user: dan tags: trunk | |
| 04:31 | Fix the processing of double-negatives in WHERE clause constraints with STAT4. Ticket [cfa2c908f2182] check-in: 35b34bdf user: drh tags: trunk | |
|
2017-06-11
| ||
| 20:17 | Fix an off-by-one error that messes up the display of loop codes in the ".wheretrace" debugging output for queries with more than 62 candidate loops when SQLITE_ENABLE_WHERETRACE is on. check-in: 0bbdaf28 user: drh tags: trunk | |
| 19:51 | When reusing a materialized view, make sure the estimated number of output rows is correctly initialized to avoid confusing the query planner. check-in: 87aceb41 user: drh tags: trunk | |
| 19:40 | Fix the sessiondiff test module so that it does not run if the session extension is not enabled. check-in: 8f92b7a6 user: drh tags: trunk | |
| 18:26 | Fix a potential null-pointer deference following OOM introduced by check-in [e39795d7] (unreleased). check-in: a2f77285 user: drh tags: trunk | |
|
2017-06-09
| ||
| 11:43 | Update the documentation to make it clear that the table name parameter to sqlite3_table_column_metadata() may not be NULL. check-in: 2881ab1e user: drh tags: trunk | |
| 02:27 | Adjust the implementation of the ".selftest" feature of the shell to avoid using the deprecated sqlite3_get_table() interface. check-in: 3168e2c9 user: drh tags: trunk | |
|
2017-06-08
| ||
| 14:35 | Add a testcase() to confirm that an OOM on sqlite3DbStrNDup() is handled correctly in trigger.c. check-in: 343e5599 user: drh tags: trunk | |
| 11:14 | Ensure pointer map entries are always added when a row that does use overflow pages replaces one that does not in an auto-vacuum database. Fix for [fda22108]. check-in: b30dfba8 user: dan tags: trunk | |
|
2017-06-07
| ||
| 22:32 | In SQLITE_DEBUG mode, attempt to log the page number of the database that contained the problem when SQLITE_CORRUPT errors are seen. check-in: e39795d7 user: drh tags: trunk | |
|
2017-06-06
| ||
| 18:20 | Add the SQLITE_DEFAULT_ROWEST compile-time option for changing the estimated number of rows in tables that lack sqlite_stat1 entries. check-in: 234ede26 user: drh tags: trunk | |
|
2017-06-05
| ||
| 19:20 | Fix a subtle bug in the remember UDF of the kvtest.exe utility program. check-in: 9eea3670 user: drh tags: trunk | |
| 16:33 | Fix a bug in test_fs.c that occurs when the first component of a path contains a GLOB or LIKE escape character. check-in: 73c70590 user: dan tags: trunk | |
| 13:28 | For the kvtest utility, add the --vacuum option to "kvtest stat" and also run PRAGMA integrity_check with "kvtest stat". check-in: f3c25df4 user: drh tags: trunk | |
| 12:29 | Fix the column width deduction logic in the command-line shell to account for multi-byte utf8 characters. check-in: ed0842c1 user: drh tags: trunk | |
| 10:31 | Omit some of the fstree tests in vtabH if the PWD contains LIKE wildcards. check-in: ead29f9c user: drh tags: trunk | |
|
2017-06-03
| ||
| 20:09 | Initialize a variable to zero to prevent an (incorrect) compiler warning of it potentially being uninitialized. check-in: 65182ce0 user: drh tags: trunk | |
| 19:16 | Fix the SQLITE_PTR_TO_INT macro so that works on recent versions of LLVM on Macs. check-in: c4089ffb user: drh tags: trunk | |
| 18:27 | Remove unused header file from kvtest. check-in: dd7e043f user: drh tags: trunk | |
| 17:24 | In kvtest, add the ability to work with a hierarchy of files on disk, in addition to having all files in the same directory. check-in: f568f666 user: drh tags: trunk | |
| 15:17 | Add the --nocheckpoint and --multitrans options to kvtest. check-in: 5828633c user: drh tags: trunk | |
|
2017-06-02
| ||
| 23:32 | Add the --fsync flag to kvtest, and document the --nosync flag. check-in: 7fdc78a6 user: drh tags: trunk | |
| 19:31 | Work toward enhancing kvtest to measure write performance. check-in: fc73e7d2 user: drh tags: trunk | |
| 15:44 | Change the name of the OP_Seek opcode into OP_DeferredSeek for better clarity of function. No functional code changes. check-in: ab33d299 user: drh tags: trunk | |
| 13:16 | Fix a typo in the header comment of the "series.c" virtual table extension. check-in: d637feb4 user: drh tags: trunk | |
|
2017-06-01
| ||
| 01:53 | Add a comment to the Lemon documentation regarding the security of the lemon.exe command-line tool. check-in: 4c2458c1 user: drh tags: trunk | |
|
2017-05-31
| ||
| 17:30 | Add the SQLITE_STMTSTATUS_MEMUSED opcode to sqlite3_stmt_status() for finding the heap memory usage by a single prepared statement. check-in: c26cf978 user: drh tags: trunk | |
| 16:21 | Add the SQLITE_STMTSTATUS_MEMUSED option for sqlite3_stmt_status() that reports the amount of heap memory used for a single prepared statement. Closed-Leaf check-in: b57d5104 user: drh tags: stmtstatus-memused | |
| 16:09 | Add the experimental "stmts" virtual table for introspection of prepared statements. check-in: cb4c5c66 user: drh tags: trunk | |
| 13:45 | Avoid allocating excess memory to the KeyInfo objects. check-in: df785943 user: drh tags: trunk | |
| 13:27 | Remove a completely unnecessary memset() from the INSERT code generator. check-in: 7d58836b user: drh tags: trunk | |
| 11:24 | Very small performance increase in sqlite3VdbeSetNumCols(). check-in: 8885b446 user: drh tags: trunk | |
| 03:20 | Reorder fields in the PgHdr object for a performance increase. check-in: 326e63d7 user: drh tags: trunk | |
| 02:58 | Avoid unnecessary memory zeroing during expression list allocation. check-in: de28e651 user: drh tags: trunk | |
| 00:49 | Size and performance optimizations to sqlite3ResolveExprNames(). check-in: af8c0fed user: drh tags: trunk | |
|
2017-05-30
| ||
| 18:34 | Change sqlite3BtreeNext() and sqlite3BtreePrevious() so that they return SQLITE_DONE if they have already reached the end (or beginning) of the table. This gives a performance increase and size reduction. check-in: e972a386 user: drh tags: trunk | |
| 18:14 | Omit a test of codepoint 0x202F (non-break narrow space) from the fts3 ICU tests. Different versions of ICU apparently handle this obscure codepoint slightly differently. check-in: 69ae6889 user: dan tags: trunk | |
|
2017-05-29
| ||
| 22:44 | More efficient error handling and reset in the binding mechanism. check-in: 9a3e3b34 user: drh tags: trunk | |
| 17:59 | Omit unnecessary fstat() calls for determining the database file size, resulting in smaller and faster code. check-in: dd61c736 user: drh tags: trunk | |
| 17:43 | Fix an issue with OPT_FEATURE_FLAGS in configure.ac. check-in: 43ce3bd3 user: drh tags: trunk | |
| 16:45 | Avoid unnecessary fstat() calls to determine the database size when transitioning into a read transaction on a rollback-mode database. Closed-Leaf check-in: 6c3476b5 user: drh tags: io-opt | |
| 14:57 | Avoid unnecessary calls to fstat() to determine the database file size. check-in: c733a1de user: drh tags: io-opt | |
| 14:30 | Fix a typo in a comment. No code changes. check-in: cb29b838 user: drh tags: trunk | |
| 14:26 | Optimizations to the Walker object and its methods to make the code a little smaller and to help it run a little faster. check-in: 6854a34e user: drh tags: trunk | |
| 13:09 | Correctly initialize the iSelectId of FROM clause terms that are a self join of a reused materialized subquery. Without this, the EXPLAIN QUERY PLAN output for the query will identify the subquery using the uninitialized (and arbitrary) iSelectId. check-in: 43c9ae37 user: drh tags: trunk | |
| 03:48 | Improve shell help text for the '.open' command. check-in: 7cc940a9 user: mistachkin tags: trunk | |
|
2017-05-27
| ||
| 22:42 | Smaller and faster vdbeSorterCompareText(). check-in: 542dc4c5 user: drh tags: trunk | |
|
2017-05-25
| ||
| 21:35 | Small performance increase and size decrease in the btreeInitPage() routine. check-in: 6f415833 user: drh tags: trunk | |
| 17:27 | Merge the LEFT JOIN query flattener fixes from 3.19.2. check-in: 6513e4a1 user: drh tags: trunk | |
| 16:50 | Version 3.19.2 check-in: edb4e819 user: drh tags: release, branch-3.19, version-3.19.2 | |
| 11:39 | The SQLITE_EXTRA_IFNULLROW compile-time option causes OP_IfNullRow opcodes to be issued for references to the right-hand side table of *any* flattened join, not just LEFT JOINs. This puts extra stress on the OP_IfNUllRow opcodes for testing purposes. check-in: 1a074c8a user: drh tags: branch-3.19 | |
| 00:28 | The TK_IF_NULL_ROW expression node must be treated as a variable that references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. check-in: b30a364a user: drh tags: branch-3.19 | |
| 00:12 | Increase the version number to 3.19.2 since ticket [7fde638e94287d2] is going to necessitate another patch release. check-in: c315727a user: drh tags: branch-3.19 | |
| 00:08 | The TK_IF_NULL_ROW expression node must be treated as a variable that references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. check-in: 77fc2301 user: drh tags: trunk | |
|
2017-05-24
| ||
| 15:32 | Fix harmless compiler warnings in FTS5. check-in: 57a60e95 user: mistachkin tags: trunk | |
| 13:08 | Version 3.19.1 check-in: f6d7b988 user: drh tags: release, branch-3.19, version-3.19.1 | |
| 04:18 | Fix a problem in STAT4 equality estimation for multi-column indexes introduced by check-in [3e0590dee0e68cc1599]. check-in: cfb0d9e0 user: drh tags: trunk | |
|
2017-05-23
| ||
| 20:00 | Remove the msvc.h header file from the autoconf tarball. check-in: 84996aef user: drh tags: trunk | |
| 19:35 | Do not use strcpy() in the (obsolete) amatch extension. In releasetest.tcl, run Apple tests using -Os instead of -O1 check-in: 4440e420 user: drh tags: trunk | |
| 15:33 | Disable the LEFT JOIN flattening optimization for aggregate queries, as it does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. check-in: 05ada741 user: drh tags: branch-3.19 | |
| 15:21 | Disable the LEFT JOIN flattening optimization for aggregate queries, as it does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. check-in: 44b21e35 user: drh tags: trunk | |
| 12:44 | Ensure that the expression rewriter inside the query flattener decends into the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. check-in: 28d2902d user: drh tags: branch-3.19 | |
| 12:36 | Ensure that the expression rewriter inside the query flattener decends into the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. check-in: 941d8142 user: drh tags: trunk | |
| 01:35 | Change the version number to 3.19.1. check-in: 16656b8f user: drh tags: branch-3.19 | |
| 01:30 | Remove a surplus semicolon, which was harmless on gcc and clang but caused compile-time errors on msvc. This only comes up using the encryption extension. check-in: 4510d55d user: drh tags: branch-3.19 | |
| 01:29 | When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. check-in: 919d36e6 user: drh tags: branch-3.19 | |
| 01:21 | When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. check-in: 92c17850 user: drh tags: trunk | |
| 00:32 | Remove a surplus semicolon, which was harmless on gcc and clang but caused compile-time errors on msvc. This only comes up using the encryption extension. check-in: 987a2b55 user: drh tags: trunk | |
|
2017-05-22
| ||
| 18:09 | Fix incompatibilities between the "sqldiff --changeset" command and the sessions module. Specifically, allow sessions to process changesets containing tables with zero operations on them and have sqldiff output the expected output for tables with multi-column primary keys. check-in: 0bb23c48 user: dan tags: trunk | |
| 18:00 | Add the ".cd" command to the command-line shell. check-in: 5fe28e15 user: drh tags: trunk | |
| 17:39 | Increase the version number to 3.20 for the next release cycle. check-in: ab471f61 user: drh tags: trunk | |
| 14:04 | Merge the last-minute 3.19.0 changes into trunk. check-in: e6ba2a93 user: drh tags: trunk | |
| 13:58 | Version 3.19.0 check-in: 28a94eb2 user: drh tags: release, branch-3.19, version-3.19.0 | |
| 13:06 | Include the "msvc.h" header file in the amalgamation tarball. check-in: 3dd6fe53 user: drh tags: branch-3.19 | |
| 08:04 | Fix a case where NULL was being passed to memcmp() following an OOM. This is probably not a real problem, as the number-of-bytes parameter was passed 0 in this case, but it was causing a santizer complaint. check-in: 3ea2bad2 user: dan tags: trunk | |
| 00:45 | When planning a query using sorting, resolve ties in the solver by selecting loop plans with the smaller unsorted cost. check-in: f261678c user: drh tags: trunk | |
|
2017-05-19
| ||
| 23:04 | Prevent a possible NULL pointer dereference in the OP_Found opcode that can follow an OOM error. Problem found by OSS-Fuzz. check-in: 50ad60de user: drh tags: branch-3.19 | |
| 22:51 | Prevent a possible NULL pointer dereference in the OP_Found opcode that can follow an OOM error. Problem found by OSS-Fuzz. check-in: c2de178f user: drh tags: trunk | |
| 20:55 | Improved comments on one routine in the query planner. Improved diagnostic output for ".wheretrace". No production code changes. check-in: 946b87a5 user: drh tags: trunk | |
| 20:47 | Fix a documentation typo. No changes to code. check-in: 68942a4f user: drh tags: trunk | |
| 20:46 | Branch for the 3.19 release. check-in: f2b829ec user: drh tags: branch-3.19 | |
| 12:32 | Fix some problems in fts5 code detected by -fsanitize=undefined. check-in: 35f72104 user: dan tags: trunk | |
|
2017-05-18
| ||
| 18:17 | Fix a documentation typo. No changes to code. Closed-Leaf check-in: cfa4aa20 user: drh tags: doc-type | |
|
2017-05-16
| ||
| 09:49 | Update the tool/warnings.sh script to automatically use the right options on OpenBSD. check-in: 7940bff3 user: dan tags: trunk | |
|
2017-05-15
| ||
| 15:12 | Fix the build so that it works again with SQLITE_OMIT_SUBQUERY. check-in: bb0d9281 user: drh tags: trunk | |
| 15:05 | Improvements to the omittest.tcl script. check-in: 0f05d7e9 user: drh tags: trunk | |
|
2017-05-12
| ||
| 14:05 | Make sure the 'sqlite3changegroup_*' functions are included in the SQLITE_APICALL handling. check-in: a123cb93 user: mistachkin tags: trunk | |
|
2017-05-11
| ||
| 19:09 | Add another test case for the new authorizer functionality. check-in: 339df63f user: dan tags: trunk | |
| 18:42 | Enhance the json_extract() function to reuse parses of the same JSON when the function appears multiple times in the same query. check-in: 3ba9e7ab user: drh tags: trunk | |
| 18:14 | Do not save the state of an fts5 merge operation mid-way through an input term, even if no previous entry for that term has caused any output. Doing so may corrupt the FTS index. check-in: 9a2de4f0 user: dan tags: trunk | |
| 16:49 | Cache the JSON parse used by json_extract(). Closed-Leaf check-in: 44ca6c2c user: drh tags: auxdata-cache | |
| 15:20 | Negative N values in sqlite3_get_auxdata() and sqlite3_set_auxdata() can be used to access an auxiliary data cache over all functions in a single prepared statement. check-in: ff530675 user: drh tags: auxdata-cache | |
| 13:43 | New requirements marks and documentation for the authorizer. check-in: 3980ea09 user: drh tags: trunk | |
| 12:27 | Improvements to the sqlite3_set_authorizer() documentation. check-in: 47629b19 user: drh tags: trunk | |
| 12:05 | Change the SQLITE_READ authorization call for unreferenced tables to use an empty string for the column name, as this is less likely to impact legacy authorization callbacks that assume column names are always non-NULL. check-in: 4139953a user: drh tags: trunk | |
|
2017-05-10
| ||
| 19:42 | Rename fields of the internal AuxData object to make them unique and easier to search for. check-in: 2be9850c user: drh tags: trunk | |