Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins using file test/rollback.test version 06680159
|
2020-06-06
| ||
| 20:48 | Merge multiple changes from trunk to address concerns with window-function parse-tree rewriting. (Leaf check-in: 05418b2a user: drh tags: branch-3.32) | |
| 19:54 | Fix a possible ASAN violation inside of debug-only code following an OOM. (Leaf check-in: 0e021887 user: drh tags: trunk) | |
| 19:35 | When determining if the subquery inserted by the window-function rewriter is an aggregate query, aggregate functions that are in parameters to another window function do not count. Fix for ticket [1f6f353b684fc708] (check-in: 8583c348 user: drh tags: trunk) | |
| 18:45 | Clearly distinguish between window functions and scalar functions in the debugging TreeView output. (check-in: 15babdcb user: drh tags: trunk) | |
| 18:34 | In the query flattener, defer deleting content until after associated Parse object is destroyed, in case some of the deleted expressions have been collected for use by sAggInfo. (check-in: 03b32be4 user: drh tags: trunk) | |
| 14:58 | Remove an incorrect assert() added earlier today. (check-in: 3926ff17 user: drh tags: trunk) | |
| 14:44 | When rewriting the parse-tree for window functions, ensure that the inserted subqueries have an accurate SF_Aggregate bit set. This change also coincidentally fixes ticket [0899cf62f597d7e7], even thought that was not the issue we were working on at the time. (check-in: 2cddb24e user: drh tags: trunk) | |
| 14:29 | Fix an assert() failure that could occur if an ORDER BY expression attached to a compound query contains a subquery that (a) is itself a compound query, (b) uses window functions and (c) has an ORDER BY clause that includes another sub-query. (check-in: c96914ea user: dan tags: trunk) | |
| 13:29 | Avoid no-op calls to sqlite3SelectPrep() when processing sqlite3Select() for subqueries. This simplifies the ".selecttrace" debugging output. (check-in: 3de19ee2 user: drh tags: trunk) | |
|
2020-06-05
| ||
| 21:36 | Improved tracing of window function parse tree rewrites. (check-in: 7e8060cf user: drh tags: trunk) | |
| 18:17 | Assign a fake name to the ephemeral subquery tables that are created when making parse-tree changes for window functions. (check-in: c4072267 user: drh tags: trunk) | |
| 15:56 | Do parse-tree transformations required for window functions prior to running aggregate function analysis. Fix for ticket [c8d3b9f0a750a529]. (check-in: 79eff1d0 user: drh tags: branch-3.32) | |
| 15:40 | New test case for fuzzdata8.db. (check-in: 2870d117 user: drh tags: trunk) | |
| 15:26 | Do parse-tree transformations required for window functions prior to running aggregate function analysis. Fix for ticket [c8d3b9f0a750a529]. (check-in: 0b42a227 user: drh tags: trunk) | |
| 14:53 | Ensure that the "push-down" optimization does not push constraints down into compound queries if any of the component queries uses window functions. (Closed-Leaf check-in: 2011e832 user: dan tags: early-winfunc-rewrite) | |
| 14:25 | ALWAYS() and NEVER() macros added due to unreachable branches arising from the previous check-in. (check-in: 13ffedab user: drh tags: early-winfunc-rewrite) | |
| 14:10 | Move the parse tree rewrite for window functions earlier in the process, before sqlite3ExprAnalyzeAggregates() has run. Add new assert()s to verify that aggregate analysis always remains valid until the end of SELECT processing. (check-in: fe702aa0 user: drh tags: early-winfunc-rewrite) | |
| 04:01 | In the debugging treeview output, change the name of "SELECT-expr" expression nodes to be "subquery-expr", so as to not confuse them with actual SELECT nodes. (check-in: c1c8937a user: drh tags: trunk) | |
| 00:54 | Always use ?...? to indicate optional arguments in the output of ".help" in the CLI. Change ".mode column" so that it automatically activates ".headers on" if headers have not been previously turned on or off. (check-in: 2827c0a1 user: drh tags: trunk) | |
|
2020-06-04
| ||
| 18:05 | Add support for "box" mode in the CLI: Like "table" except that it uses unicode box-drawing characters instead of ascii-art. (check-in: 6da784c9 user: drh tags: trunk) | |
| 16:54 | Improved display of ".mode table" output for empty result sets. (check-in: 7efabd68 user: drh tags: trunk) | |
| 16:34 | Use __has_extension(c_atomic) instead of __has_feature(c_atomic) to detect support for atomic load and store operations with clang. (check-in: 36225579 user: dan tags: trunk) | |
| 16:07 | Use AtomicStore() to set values in the wal-index hash table. (check-in: 1ab30c75 user: dan tags: trunk) | |
| 12:58 | Version 3.32.2 (check-in: ec02243e user: drh tags: release, branch-3.32, version-3.32.2) | |
| 02:50 | Work around a bug in clang-11.0.0. See forum post 3c2bf8042ec46195 for further info. (check-in: 3c2bf804 user: drh tags: trunk) | |
|
2020-06-03
| ||
| 22:57 | Fix for ticket [810dc8038872e212]. (check-in: 9cfefef5 user: drh tags: branch-3.32) | |
| 22:47 | Version number to 3.32.2 (check-in: 4454b27f user: drh tags: branch-3.32) | |
| 19:28 | Fix for ticket [810dc8038872e212]. Thank to user "Maxulite" for tracking down the problem! (check-in: 89af93d7 user: drh tags: trunk) | |
| 15:59 | Simplification to the interrupt handling logic in sqlite3VdbeExec() saves a few bytes of code space. (check-in: 43e0e59b user: drh tags: trunk) | |
| 03:00 | Improve the query planner so that it is better able to find full index scan plan when there is an INDEXED BY clause. (check-in: d901837f user: drh tags: trunk) | |
|
2020-05-30
| ||
| 15:34 | Draw the dashes below the headers in "explain" mode in the CLI. (check-in: c6b7833a user: drh tags: trunk) | |
| 00:30 | Improved VDBE comments on the ANALYZE code generator. This change also fixes a harmless use of an uninitialized integer variable as an input to the %d format on a VDBE comment. (check-in: 1cb248a3 user: drh tags: trunk) | |
|
2020-05-29
| ||
| 21:06 | Enhancements to the incremental build support for MSVC. (check-in: 2e25d915 user: mistachkin tags: trunk) | |
| 20:16 | Remove a stray "&" character in the CLI, detected by a clang warning. (check-in: 5865d2f2 user: drh tags: trunk) | |
| 19:45 | Add the "shelltest" target to the MSVC makefile as well. (check-in: 9924c045 user: drh tags: trunk) | |
| 19:39 | Fix the ".import" command of the CLI to clean up better after errors. Add the new "shelltest" makefile target on unix platforms. (check-in: 50d4ddf1 user: drh tags: trunk) | |
| 19:17 | Improvements to help text for the CLI. (check-in: 6a01e4c4 user: drh tags: trunk) | |
| 19:03 | Fix a memory leak in the CLI when an unknown or unrecognized argument is given to the ".dump" command. (check-in: 71bfbbcc user: drh tags: trunk) | |
| 16:15 | Improvements to columnar output in the CLI. Columns automatically expand to contain the largest row. (check-in: 4e1db8e9 user: drh tags: trunk) | |
| 14:38 | Space to hold the ".width" of columns in the CLI is now obtained from malloc() and hence is not limited in the number of columns supported. (check-in: 445ed5da user: drh tags: trunk) | |
| 12:31 | Incremental improvements to tabular output modes in the CLI. The "markdown" and "table" modes no have headers turned on by default. (check-in: af28bff9 user: drh tags: trunk) | |
| 11:07 | Expand upon a comment in os_unix.c. No changes to code. (check-in: 77933dc4 user: dan tags: trunk) | |
| 00:21 | In the json output mode of the CLI, do correct quoting of escape characters. Also, show BLOBs as JSON strings, possibly with embedded \u0000 bytes. (check-in: 0278147a user: drh tags: trunk) | |
|
2020-05-28
| ||
| 23:49 | Progress toward adding new output modes to the CLI: json, table, and markdown. (check-in: 14f55faf user: drh tags: trunk) | |
| 20:37 | Enhance the ".quote" mode in the shell so that it honors .separator. (check-in: b5e33ed5 user: drh tags: trunk) | |
| 00:45 | When the sqlite_stat1 data is missing for some indexes of a table but is present for the table itself or for other indexes in the same table, then do not let the estimated number of rows in that table get too small, as doing so can deceive the query planner into ignoring a perfectly good index. (check-in: 98d42620 user: drh tags: trunk) | |
|
2020-05-27
| ||
| 12:44 | Small performance improvement and size reduction in the expression code generator. (check-in: eeb53e21 user: drh tags: trunk) | |
| 00:02 | Change a datatype from i16 to int to appease Converity and help eliminate a false-positive. (check-in: 5b560ec4 user: drh tags: trunk) | |
|
2020-05-26
| ||
| 20:33 | Fix the cksumvfs extension so that it will not register itself more than once. (check-in: d5cdd571 user: drh tags: trunk) | |
| 20:31 | Performance optimization in the transfer of error messages from statements to connections. (check-in: 0e898f4f user: drh tags: trunk) | |
| 11:23 | Increase the version number to 3.33.0 to begin the next release cycle. (check-in: 790badb3 user: drh tags: trunk) | |
| 11:10 | Changes to sqlite3SelectNew() to work around a false-positive warning from GCC-10. The code is very slightly larger and slower as a result. (check-in: 04e1edd8 user: drh tags: trunk) | |
| 10:54 | Innocuous changes to help Coverity avoid false-positives. (check-in: 4ec8a5a2 user: drh tags: trunk) | |
|
2020-05-25
| ||
| 18:18 | Merge version 3.32.1 into the begin-concurrent-pnu-wal2 branch. (Leaf check-in: 0f9464c5 user: drh tags: begin-concurrent-pnu-wal2) | |
| 18:09 | Merge version 3.32.1 into the wal2 branch. (Leaf check-in: 5c183757 user: drh tags: wal2) | |
| 18:03 | Merge versoin 3.32.1 into the begin-concurrent-pnu branch. (Leaf check-in: e8d79d2b user: drh tags: begin-concurrent-pnu) | |
| 17:27 | Merge version 3.32.1 into the begin-concurrent branch. (Leaf check-in: 5e08e360 user: drh tags: begin-concurrent) | |
| 16:34 | Update the reuse-schema branch to version 3.32.1 (Leaf check-in: ecf8dece user: drh tags: reuse-schema) | |
| 16:19 | Version 3.32.1 (check-in: 0c1fcf47 user: drh tags: trunk, release, version-3.32.1) | |
| 15:41 | Extra assert() statements in the printf() logic. (check-in: b1b182be user: drh tags: trunk) | |
| 15:19 | Defensive code that tries to prevent a recurrence of problems like the one described in ticket [7a5279a25c57adf1] (check-in: 572105de user: drh tags: trunk) | |
| 12:49 | Fix minor compile issues with optional extensions. (check-in: 3261ee9e user: drh tags: trunk) | |
| 12:02 | Make sure variable declarations are at start of scope even when SQLITE_ENABLE_SNAPSHOT is used. (check-in: a77ceaf6 user: drh tags: trunk) | |
| 01:31 | Attempt to work around a false-positive warning in the CGo compiler. (Closed-Leaf check-in: d4bf60f4 user: drh tags: cgo-warning-workaround) | |
|
2020-05-24
| ||
| 12:36 | Version number to 3.32.1. (check-in: 56e5063c user: drh tags: trunk) | |
| 03:38 | When rewriting a query for window functions, if the rewrite changes the depth of TK_AGG_FUNCTION nodes, be sure to adjust the Expr.op2 field appropriately. Fix for ticket [7a5279a25c57adf1] (check-in: ad7bb70a user: drh tags: trunk) | |
| 03:01 | Move some utility Walker callbacks into the walker.c source file, as they seem to belong there better. (check-in: dac43823 user: drh tags: trunk) | |
| 02:05 | Improvements to parse-tree tracing logic. No changes in deliverable code. (check-in: f7e5a68a user: drh tags: trunk) | |
| 00:30 | Minor fix to a comment. No code changes. (check-in: efdbb2b4 user: drh tags: trunk) | |
|
2020-05-23
| ||
| 19:58 | Limit the "precision" of floating-point to text conversions in the printf() function to 100,000,000. Fix for ticket [23439ea582241138]. (check-in: d08d3405 user: drh tags: trunk) | |
| 17:56 | Improved bytecode comment. (check-in: 9224f154 user: drh tags: trunk) | |
|
2020-05-22
| ||
| 18:41 | Merge version 3.32.0 into the reuse-schema branch. (check-in: 31706878 user: drh tags: reuse-schema) | |
| 18:35 | Merge version 3.32.0 into the begin-concurrent-pnu-wal2 branch. (check-in: 3cb29606 user: drh tags: begin-concurrent-pnu-wal2) | |
| 18:28 | Merge version 3.32.0 into the wal2 branch. (check-in: 1cb46a74 user: drh tags: wal2) | |
| 18:17 | Merge the 3.32.0 release into the begin-concurrent-pnu branch. (check-in: 79663e66 user: drh tags: begin-concurrent-pnu) | |
| 18:09 | Merge the 3.32.0 release into the begin-concurrent branch. (check-in: 79ad4ea2 user: drh tags: begin-concurrent) | |
| 17:46 | Version 3.32.0 (check-in: 5998789c user: drh tags: trunk, release, version-3.32.0) | |
|
2020-05-21
| ||
| 20:38 | Change a NEVER macro into a NO_TEST comment, as the conditional is reachable, but only when compiling for Windows 32-bit. (check-in: ce36b6d1 user: drh tags: trunk) | |
| 19:13 | Avoid another potential OOB read in sqlite3expert.c. (check-in: 0ccea800 user: dan tags: trunk) | |
|
2020-05-20
| ||
| 15:02 | Back out the change from [7fab1393c2b22b1f] that tries to convert invalid surrogate characters in UTF16 into the replacement character 0xfffd, as we find that this breaks some software. (check-in: 4218c7b7 user: drh tags: trunk) | |
|
2020-05-19
| ||
| 15:51 | Add compiler hints to disable TSAN for the routines that access the -shm file header in WAL mode using a double-read with memory barrier. (check-in: 3117c1b5 user: drh tags: trunk) | |
| 15:40 | In os_win.c, avoid calling sqlite3_uri_boolean() on anything other than a main-db filename. (check-in: cb0a18e6 user: dan tags: trunk) | |
| 12:29 | User-suggested improvement to the README.txt for the ICU extension. (check-in: 1d1293c2 user: drh tags: trunk) | |
| 12:27 | In wal.c, improved comments on concurrency issues. More use of AtomicLoad() and AtomicStore(). (check-in: 4bf566fe user: drh tags: trunk) | |
|
2020-05-18
| ||
| 19:55 | Merge latest trunk changes into this branch. (check-in: 5dc355cc user: dan tags: begin-concurrent-pnu-wal2) | |
| 19:11 | Bring the reuse-schema branch up to date with the latest trunk changes. (check-in: d8ea0cb6 user: drh tags: reuse-schema) | |
| 18:02 | Add vdbevtab.lo to build of libsqlite3.lib in Makefile.msc. (check-in: f64d054b user: dan tags: trunk) | |
| 17:18 | Merge latest trunk changes into this branch. (check-in: 16b1eca9 user: dan tags: wal2) | |
| 16:19 | Merge recent changes from trunk. (check-in: c69f030b user: drh tags: begin-concurrent-pnu) | |
| 15:41 | Merge latest trunk changes into this branch. (check-in: 9e4a7b3e user: dan tags: begin-concurrent) | |
|
2020-05-17
| ||
| 13:47 | Avoid harmless UB in memcpy() in the JSON extension. (check-in: 69e149f7 user: drh tags: trunk) | |
| 00:26 | Use the sqlite3Realloc() interface internally, rather than the public sqlite3_realloc64() equivalent, to avoid unnecessary calls to sqlite3_initialize(). (check-in: 1313557b user: drh tags: trunk) | |
|
2020-05-16
| ||
| 21:01 | Performance optimization for the sqlite3FindTable() subroutine. (check-in: 55910b9a user: drh tags: trunk) | |
| 19:00 | Merge trunk enhancements in the reuse-schema branch. (Actual date of this check-in is 2020-05-18.) (check-in: 5af4abe9 user: drh tags: reuse-schema) | |
| 18:01 | The OP_RealAffinity opcode is not necessary after reading values from a virtual table (such as rtree). It is harmless, but it does use CPU cycles. Might as well leave it off. (check-in: dc18d893 user: drh tags: trunk) | |
| 17:26 | Fix a use-after-free bug in the fts3 snippet() function. (check-in: 0d69f76f user: dan tags: trunk) | |
| 16:23 | Extra memory barrier during initialization. (check-in: 043a7e14 user: drh tags: trunk) | |
| 15:18 | Add sqlite3BeginBenignMalloc() and EndBenignMalloc() calls to debugging function sqlite3VdbePrintOp(). (check-in: 6f857d0e user: dan tags: trunk) | |
|
2020-05-15
| ||
| 18:48 | Update code in sqlite3expert.c to account for the fact that "-- TRIGGER xyz" VM comments are now omitted for some builds. (check-in: 7cf93dc5 user: dan tags: trunk) | |
| 16:19 | Fix another build problem for SQLITE_OMIT_VIRTUALTABLE builds. (check-in: 5e1eb0fa user: dan tags: trunk) | |
| 16:05 | Fix a documentation typo. No changes to code. (check-in: 758353c7 user: drh tags: trunk) | |
| 15:03 | Adjust some requirement marks. No changes to code. (check-in: 7285ae2c user: drh tags: trunk) | |
| 13:52 | Update test file e_fkey.test to account for the fact that new columns with REFERENCE clauses and non-NULL default values may now be added using ALTER TABLE if the table is empty. (check-in: 4087fce9 user: dan tags: trunk) | |
| 11:36 | Fix SQLITE_OMIT_VIRTUALTABLE testfixture builds. (check-in: 3d9780c5 user: dan tags: trunk) | |
| 11:26 | Test script changes to account for the fact that the "p5" column in the EXPLAIN output is now an integer, not a text values containing a 2-digit hex value. (check-in: 102126d8 user: dan tags: trunk) | |
| 01:18 | Enhancements to long-path support in the Win32 VFS. (check-in: 0119d96d user: mistachkin tags: trunk) | |
| 01:13 | Move some new test cases from fts3snippet.test into fts3snippet2.test. (check-in: fa203999 user: drh tags: trunk) | |
| 01:02 | Add the SQLITE_ENABLE_FTS3_PARENTHESIS option to fuzzcheck. Add a new test case that uses that option. (check-in: c49a33db user: drh tags: trunk) | |
|
2020-05-14
| ||
| 23:59 | Fix a null pointer deference that can occur on a strange matchinfo() query. (check-in: a4dd1489 user: drh tags: trunk) | |
| 21:16 | Do not allow a virtual table to be renamed into the name of one of its shadows. (check-in: eca0ba2c user: drh tags: trunk) | |
|
2020-05-13
| ||
| 18:03 | Implement the IIF(x,y,z) SQL function that is short-hand for "CASE WHEN x THEN y ELSE z END". For compatibility with SQL Server. (check-in: fce173cd user: drh tags: trunk) | |
| 17:26 | Remove unused constant SQLITE_FUNC_COALESCE. (check-in: a116b20f user: drh tags: trunk) | |
| 13:33 | Use AtomicStore() and AtomicLoad() in a few more places to avoid a theoretically undefined behaviour. This is not actually problem on any known hardware. (check-in: fda57d4d user: dan tags: trunk) | |
|
2020-05-11
| ||
| 11:11 | New test case in test/fuzzdata8.db. (check-in: fa112301 user: drh tags: trunk) | |
| 10:55 | Fix a problem handling constant integer expressions with collation sequences in PARTITION BY clauses. (check-in: 155e6649 user: dan tags: trunk) | |
|
2020-05-08
| ||
| 19:02 | Release some restrictions on columns added by ALTER TABLE so that they only apply if the table contains one or more rows. (check-in: 3a16c0ce user: drh tags: trunk) | |
| 18:22 | Fix the count-optimization so that it honors the NOT INDEXED clause. (check-in: 0d23a0b2 user: drh tags: trunk) | |
| 15:28 | New test cases added to test/fuzzdata8.db. (check-in: 3fce9711 user: drh tags: trunk) | |
| 10:44 | Do not retry on a failed realloc() unless SQLITE_ENABLE_MEMORY_MANAGEMENT is available, meaning that the retry has some possibility of success. (check-in: e9a8f910 user: drh tags: trunk) | |
|
2020-05-07
| ||
| 19:55 | Fix a failing assert() in fts3 triggered by a corrupt database. (check-in: cb299a09 user: dan tags: trunk) | |
| 14:39 | Changes to avoid deadlock in SQLITE_ENABLE_SETLK_TIMEOUT builds. (check-in: 652e4b23 user: dan tags: trunk) | |
| 14:26 | Fix an error that could occur if the first transaction executed by a connection configured to use blocking locks is a write-transaction for which the WRITER lock cannot be obtained. (Closed-Leaf check-in: 49e4dc72 user: dan tags: setlk-deadlock-changes) | |
| 14:05 | Merge trunk changes into this branch. (check-in: ac4ee696 user: dan tags: setlk-deadlock-changes) | |
| 01:56 | Fix the handling of reserve-bytes so that the maximum value of 255 can be used. (check-in: 99749d4f user: drh tags: trunk) | |
|
2020-05-06
| ||
| 21:25 | Avoid leaking a file-handle in test file walsetlk.test. (check-in: 3cfc675e user: dan tags: setlk-deadlock-changes) | |
| 21:24 | Fix an assert() failure that could follow an IO error. (check-in: e89c8642 user: dan tags: setlk-deadlock-changes) | |
| 20:55 | Fix harmless compiler warnings. (check-in: 92dc5913 user: drh tags: setlk-deadlock-changes) | |
| 20:45 | Fix a problem preventing building without SQLITE_ENABLE_SETLK_TIMEOUT defined. (check-in: 98eb54c6 user: dan tags: setlk-deadlock-changes) | |
| 20:27 | Add error code SQLITE_BUSY_TIMEOUT, used internally by the OS layer to indicate that a call to xShmLock() has failed due to timeout of a blocking lock. (check-in: f3ef9c7c user: dan tags: setlk-deadlock-changes) | |
| 19:22 | Fix compiler warnings in non-SQLITE_ENABLE_SETLK_TIMEOUT builds. (check-in: 22de99ef user: dan tags: setlk-deadlock-changes) | |
| 19:14 | Block on the WRITER lock when attempting to run recovery. (check-in: 105d6c9b user: dan tags: setlk-deadlock-changes) | |
| 18:46 | Provide the SQLITE_DEFAULT_LEGACY_ALTER_TABLE compile-time option. (Leaf check-in: b2325a6e user: drh tags: branch-3.28) | |
| 18:43 | Provide the SQLITE_DEFAULT_LEGACY_ALTER_TABLE compile-time option. (check-in: 63e659d9 user: drh tags: trunk) | |
| 17:18 | Add tests for running recovery when opening a write transaction or performing a checkpoint with blocking locks enabled. Fix some failing assert() statements. (check-in: d096ea3f user: dan tags: setlk-deadlock-changes) | |
| 15:07 | Merge latest trunk changes into this branch. (check-in: a3727dba user: dan tags: setlk-deadlock-changes) | |
|
2020-05-05
| ||
| 20:30 | Unless upgrading an existing read transaction, have ENABLE_SETLK_TIMEOUT builds attempt to use a blocking lock when opening a write transaction on a wal mode database. (check-in: d6f819a9 user: dan tags: setlk-deadlock-changes) | |
| 19:54 | The only known path to a corruption detection branch was cut off by the previous commit implementing earlier index corruption. So make the branch NEVER. Maybe a fuzzer will find a new path. (check-in: 9a84d8eb user: drh tags: trunk) | |
| 18:42 | Earlier detection of index corruption caused by missing index entries. (check-in: f339f31f user: drh tags: trunk) | |
| 13:41 | Fix a compiler warning in cksumvfs.c. (check-in: 68033bca user: drh tags: trunk) | |
|
2020-05-04
| ||
| 19:52 | Fix harmless compiler warnings. (check-in: 8eee591d user: drh tags: trunk) | |
| 19:42 | Changes to avoid deadlock in SQLITE_ENABLE_SETLK_TIMEOUT builds. (check-in: 553423c2 user: dan tags: setlk-deadlock-changes) | |
| 19:04 | Minor change to the sqlite_stmt virtual table, for test coverage. (check-in: 838987b2 user: drh tags: trunk) | |
| 17:15 | Simplify the initialization of built-in extensions. (check-in: 729f2397 user: drh tags: trunk) | |
| 11:47 | Ensure that the master-journal name is in a form suitable to be passed into sqlite3_uri_parameter(). (check-in: d1ba026d user: drh tags: trunk) | |
|
2020-05-02
| ||
| 04:08 | Add the SQLITE_FCNTL_CKPT_START file-control and use it to optimize the cksumvfs extension. (check-in: efdecb13 user: drh tags: trunk) | |
| 03:46 | Add support for PRAGMA analyze_limit and approximate analysis. (check-in: 81254752 user: drh tags: trunk) | |
| 03:29 | Add a missing VdbeCoverage() macro. (Closed-Leaf check-in: 77a55c39 user: drh tags: approximate-analyze) | |
| 00:31 | Merge the bytecode and tables_used table-valued functions. Requires -DSQLITE_ENABLE_BYTECODE_VTAB at compile-time. (check-in: d09bcce3 user: drh tags: trunk) | |
| 00:01 | Corner-case changes to the bytecode virtual table for testability and correctness. (Closed-Leaf check-in: baa720e4 user: drh tags: bytecode-function) | |
|
2020-05-01
| ||
| 18:58 | Merge recent enhancements from trunk. (check-in: 96dfc71e user: drh tags: bytecode-function) | |
| 18:43 | Fix problems with UPDATE...FROM statements that modify rowid or primary-key values. (Leaf check-in: 623ab585 user: dan tags: update-from) | |
| 18:37 | Add the SQLITE_FCNTL_CKPT_START file-control. Use it to optimize the cksumvfs extension. (Closed-Leaf check-in: b40f5aa3 user: drh tags: ckpt-start-fcntl) | |
| 15:04 | Merge recent trunk enhancements. (check-in: 2100b2c8 user: drh tags: approximate-analyze) | |
| 13:45 | Clarification to the sqlite3_uri() family of interfaces. Documentation enhancement only - no changes to code. (check-in: 853703cd user: drh tags: trunk) | |
| 13:32 | Update documentation for sqlite3_close_v2() for clarity. No functional changes. (check-in: 80498b69 user: drh tags: trunk) | |
| 11:31 | Add the new SQLITE_IOERR_DATA result code and use it in cksumvfs. Also enhance cksumvfs to emit an sqlite3_log() message whenever it finds an invalid checksum. (check-in: a094e8bf user: drh tags: trunk) | |
|
2020-04-30
| ||
| 18:28 | Add OOM tests for the new code on this branch. (check-in: e4a18601 user: dan tags: update-from) | |
| 15:49 | Report an error if an UPDATE...FROM statement has an ORDER BY but no LIMIT clause. Add tests for multi-column primary keys. (check-in: ffcdb668 user: dan tags: update-from) | |
|
2020-04-29
| ||
| 20:11 | Fix problems with using LIMIT and FROM clauses as part of single UPDATE statement. (check-in: b717dc3c user: dan tags: update-from) | |
| 17:41 | Fix various bugs in new feature on this branch. (check-in: 823ba94e user: dan tags: update-from) | |
| 01:09 | Do not allow page_size changes on an active cksumvfs database. (check-in: 2c17cdce user: drh tags: trunk) | |
|
2020-04-28
| ||
| 23:09 | Fix incorrect error message when something goes wrong with the sqlite3_dbpage() table-valued function in the .dbinfo command of the CLI. (check-in: 0dcf0024 user: drh tags: trunk) | |
| 20:47 | Add the cksumvfs extension. (check-in: 237c10f9 user: drh tags: trunk) | |
| 14:01 | Use AtomicStore() when setting the mem0.nearlyFull boolean to avoid harmless TSAN warnings and to forestall doubts about threadsafety. (check-in: ce980af6 user: drh tags: trunk) | |
| 11:45 | Use an AtomicLoad() macro in sqlite3HeapNearlyFull(). (check-in: 7556bc63 user: drh tags: trunk) | |
|
2020-04-27
| ||
| 20:55 | Allow a FROM clause in UPDATE statements. (check-in: f353a1a6 user: dan tags: update-from) | |
|
2020-04-26
| ||
| 22:04 | Yet another attempt to enhance sqlite3_load_extension() so that it works with Window-style pathnames using a backslash separator character. (check-in: b73d9a7d user: drh tags: trunk) | |
| 14:33 | Fix an issue with check-in [bc3bf7c6681a96bc] when compiling on Windows. (check-in: 57b16d8c user: drh tags: trunk) | |
|
2020-04-25
| ||
| 21:05 | Fix the sqlite3_load_extension() interface so that it tolerates backslashes in place of forward-slashes in pathnames on Windows. (check-in: bc3bf7c6 user: drh tags: trunk) | |
| 15:01 | Ensure affinity is not discarded from a view column if the view appears on the rhs of a LEFT JOIN. Fix for [45f4bf4e]. (check-in: ac31edd3 user: dan tags: trunk) | |
|
2020-04-24
| ||
| 18:20 | The new sqlite3_database_file_object() interface requires that the pager never invoke xOpen with SQLITE_OPEN_MAIN_JOURNAL unless it is using a pointer to the journal name found in the Pager structure itself. Make this the case when processing a master-journal. (check-in: b4987a5c user: drh tags: trunk) | |
| 17:55 | New test case for ticket [1dcb4d44964846ad]. (check-in: 9e9f1e96 user: drh tags: trunk) | |
|
2020-04-23
| ||
| 20:45 | Fix an uninitialized variable in the newly enhanced ".output" command of the CLI. See forum post 5978955ac1 (check-in: 65c6c26b user: drh tags: trunk) | |
|
2020-04-22
| ||
| 13:49 | Fix an off-by-one error in the "calculated" page count output from the sqlite3_analyzer utility for databases that are more than 1GB in size. (check-in: 8789368b user: drh tags: trunk) | |
| 11:11 | Fix an integer overflow in fts3 causing a usan error. (check-in: e256f852 user: dan tags: trunk) | |
| 00:50 | Clarify the comment on the sqlite3BtreeGetRequestedReserve() routine. No changes to code. (check-in: 52a6acca user: drh tags: trunk) | |
|
2020-04-21
| ||
| 20:19 | Add the sqlite3_database_file_object() interface. (check-in: f534ebea user: drh tags: trunk) | |
| 19:27 | Add the sqlite3_database_file_object() interface to sqlite3ext.h. (Closed-Leaf check-in: 3cabe06b user: drh tags: sqlite3_database_file_object) | |
| 01:06 | Experimental API: sqlite3_database_file_object(). (check-in: ae697b15 user: drh tags: sqlite3_database_file_object) | |
|
2020-04-20
| ||
| 17:35 | Do not use O_NOFOLLOW when opening a directory just to call fsync() on that directory. (check-in: 2fc80ef1 user: drh tags: trunk) | |
| 16:21 | Enhance the ".filectrl" command in the CLI to support the --schema option. (check-in: 698d40db user: drh tags: trunk) | |
| 15:18 | The SQLITE_TESTCTRL_RESERVE operator is removed. In its place is the more general SQLITE_FCNTL_RESERVE_BYTES which is an API and which can operator on more than just the main schema. (check-in: abc1aad7 user: drh tags: trunk) | |
| 14:05 | Remove an obsolete comment. No changes to code. (check-in: 4135cb02 user: drh tags: trunk) | |
|
2020-04-18
| ||
| 14:12 | Add the --bom option to the ".excel", ".once", and ".output" commands of the CLI. Also fix the "--all" option on ".help" so that it works with two dashes in addition to just one. (check-in: d5b0def9 user: drh tags: trunk) | |
|
2020-04-17
| ||
| 23:46 | Fix the ".excel" command and the ".open -x" and ".open -e" command so that they work better when running from an in-memory database and on Windows and when running from a script. (check-in: 07752164 user: drh tags: trunk) | |
|
2020-04-16
| ||
| 15:56 | Merge accidentally created fork. (check-in: cb772b7a user: dan tags: trunk) | |
| 11:35 | Improve corruption detection in fts3 shadow tables earlier in order to prevent an assert() from failing. (check-in: a9ec8c8f user: dan tags: trunk) | |
|
2020-04-15
| ||
| 17:39 | Clarification of the byte-order determination for UTF16 inputs to routines like sqlite3_bind_text16() and sqlite3_result_text16() and others that accept UTF16 input strings. (check-in: a42fdcf5 user: drh tags: trunk) | |
|
2020-04-14
| ||
| 15:53 | Build the UINT collating sequence extension into the CLI. (check-in: 2b8c6b03 user: drh tags: trunk) | |
| 15:48 | Add the UINT collating sequence extension. The implementation is copied out of the "natsort" branch. (check-in: 6f46c6e3 user: drh tags: trunk) | |
| 15:35 | Change the name from NATSORT to UINT. Provide an OMIT compile-time option. (Leaf check-in: cc56cbdb user: drh tags: natsort) | |
| 15:24 | Merge trunk enhancements. (check-in: f1c284dd user: drh tags: natsort) | |
|
2020-04-09
| ||
| 19:00 | Merge recent trunk changes into begin-concurrent-pnu-wal2. (check-in: 6c11b67b user: drh tags: begin-concurrent-pnu-wal2) | |
| 18:51 | Merge recent trunk changes into the apple-osx branch. (Leaf check-in: d6fda470 user: drh tags: apple-osx) | |
| 18:46 | Merge recent trunk enhancements into the wal2 branch. (check-in: 6fb87062 user: drh tags: wal2) | |
| 18:44 | Merge recent trunk enhancements into the begin-concurrent-pnu branch. (check-in: cedd138c user: drh tags: begin-concurrent-pnu) | |
| 18:29 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: 92f71a88 user: drh tags: begin-concurrent) | |
| 15:31 | When compiling the shell for WinRT, avoid using Win32 APIs that are unavailable. (check-in: 85d3dc8c user: mistachkin tags: trunk) | |
| 15:07 | Merge recent trunk enhancements into the bytecode-function branch. (check-in: 7e6576ec user: drh tags: bytecode-function) | |
| 15:01 | Merge trunk enhancements into the approximate-analyze branch. (check-in: 17901ea6 user: drh tags: approximate-analyze) | |