Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
669 check-ins using file ext/fts5/test/fts5ad.test version e3dfb150
|
2019-09-03
| ||
| 19:29 | Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. (Leaf check-in: b584fd36 user: dan tags: branch-3.9) | |
| 17:39 | Disable the undocumented rtreenode() SQL function that is only used for testing, except when doing a build that is specifically intended for testing. (check-in: 7b4583f9 user: drh tags: branch-3.9) | |
|
2018-12-19
| ||
| 16:03 | Add interfaces sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer() used to safely move pointer values through SQL without exposing underlying memory address information. Cherrypick from commit [8201f4e1] on branch-3.18. (check-in: 4cb67252 user: dan tags: branch-3.9) | |
| 01:57 | Add extra defenses against strategically corrupt databases to fts3/4. (check-in: 882ef4e3 user: drh tags: branch-3.9) | |
|
2018-02-02
| ||
| 16:46 | Enable the ".wheretrace" and ".selecttrace" options in the shell when configure is run using --enable-debug. This mirrors a similar change that has already occurred on trunk. (Leaf check-in: c4f798b2 user: drh tags: branch-3.9.2) | |
|
2017-07-21
| ||
| 07:45 | Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This changes is a cherry-pick of [f0f49224] with version-specific edits. That check-in was inspired by check-in [72de49f2]. (check-in: 69906880 user: drh tags: branch-3.9.2) | |
|
2016-03-31
| ||
| 21:36 | Version 3.9.3 (check-in: dfbfd34b user: drh tags: release, branch-3.9, version-3.9.3) | |
| 21:16 | Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. (check-in: f1e6bb95 user: drh tags: branch-3.9) | |
|
2016-01-22
| ||
| 14:44 | Fix handling of transitive constraints in schemalint.tcl. (check-in: 44edc1aa user: dan tags: schemalint) | |
| 14:32 | Update the schemalint.tcl script so that the argument to a -select option may be either an SQL statement or the name of a file containing an SQL statement (check-in: d4e37767 user: dan tags: schemalint) | |
|
2016-01-20
| ||
| 15:27 | Version 3.10.2 (Leaf check-in: 17efb420 user: drh tags: release, version-3.10.2, branch-3.10) | |
| 15:20 | Fix a problem in autoconf/configure.ac causing --enable-readline to fail if libedit was not present. (check-in: d4a6425f user: dan tags: branch-3.10) | |
| 15:08 | Fix the build so that it works for SQLITE_OMIT_WAL again. (check-in: d1c15de5 user: drh tags: branch-3.10) | |
| 15:05 | Fix a potential use-after-free problem when compiling with SQLITE_HAS_CODEC. (check-in: b94a3a37 user: drh tags: branch-3.10) | |
| 14:32 | Increase version number to 3.10.2. (check-in: c1f918dc user: drh tags: branch-3.10) | |
| 14:30 | Case folding in the LIKE operator should look at all bits of the character, not just the lower 8 bits. Fix for ticket [80369eddd5c94]. This is a back-out of check-in [0a99a8c4facf] with a testcase added. (check-in: 29dc4a3e user: drh tags: branch-3.10) | |
|
2016-01-14
| ||
| 00:01 | Version 3.10.1 (check-in: 254419c3 user: drh tags: release, version-3.10.1, branch-3.10) | |
|
2016-01-13
| ||
| 18:26 | Version number to 3.10.1. (check-in: 4660da25 user: drh tags: branch-3.10) | |
| 18:21 | Add the SQLITE_FCNTL_JOURNAL_POINTER file control. (check-in: ea9ce228 user: drh tags: branch-3.10) | |
| 18:06 | Add documentation for the SQLITE_FCNTL_JOURNAL_POINTER file-control. (Closed-Leaf check-in: 807c5aee user: drh tags: file-control-journal) | |
| 17:59 | When the block sorting optimization is used in a scalar subquery, be sure to exit the loop as soon as the first valid output row is received. Fix for ticket [cb3aa0641d9a4]. (check-in: 8b4f5080 user: drh tags: branch-3.10) | |
|
2016-01-12
| ||
| 19:37 | Add the ".vfslist" command to the command-line shell. (check-in: 5727562b user: drh tags: trunk) | |
| 14:10 | Fix a harmless use of an uninitialized variable following system errors in the multi-threaded sorter. (check-in: 4bb2c1df user: drh tags: trunk) | |
| 04:08 | Remove an unused field from the MemPage object. (check-in: 5fc0a4c1 user: drh tags: trunk) | |
| 02:28 | Make sure all bytes of the WAL file are initialized even if the checksums are not being computed until commit due to WAL overwrite. (check-in: 1f44a9bd user: drh tags: trunk) | |
| 02:00 | Fix an uninitialized field in the Select object when SELECTTRACE is enabled. (check-in: fc628516 user: drh tags: trunk) | |
| 00:37 | Various #ifdef enhancements for improved VxWorks support. (check-in: 75cd41ff user: drh tags: trunk) | |
|
2016-01-11
| ||
| 22:58 | Performance optimization in the sqlite3VdbeChangeP4() routine of the code generator. (check-in: 28bd8d5f user: drh tags: trunk) | |
| 22:43 | Fix duplicate test number in 'waloverwrite'. (check-in: f5fb8268 user: mistachkin tags: trunk) | |
| 18:05 | Performance optimization on the Column opcode. (check-in: ecc98bef user: drh tags: trunk) | |
| 14:19 | Performance optimization in sqlite3WalkExpr(). (check-in: 2f8bd5fa user: drh tags: trunk) | |
| 13:10 | Merge recent enhancements, and especially the WAL overwrite change, from trunk. (check-in: c4a858b2 user: drh tags: sessions) | |
| 13:03 | Import the version number change to 3.11.0. (check-in: 132772d1 user: drh tags: apple-osx) | |
| 12:52 | Increase the version number to 3.11.0 due to the WAL overwrite enhancement. (check-in: 8e807bfa user: drh tags: trunk) | |
| 12:49 | Merge enhancements from trunk, and in particular the WAL overwrite feature. (check-in: 79125ec9 user: drh tags: apple-osx) | |
| 12:13 | If a single page is written to the wal file more than once, instead of appending the second and subsequent copy to the wal file, overwrite the first. Update: See the important bug fix at [f694e60a]! (check-in: d493d4f1 user: dan tags: trunk) | |
| 08:12 | Add a test case to waloverwrite.test to check that savepoint rollback does not cause a problem. (Closed-Leaf check-in: 87dae56c user: dan tags: wal-overwrite-frames) | |
| 03:48 | Slightly smaller and faster LIKE/GLOB comparison implementation. (check-in: 5dddcc78 user: drh tags: trunk) | |
| 00:52 | Improved testability. (check-in: e83d3a2a user: drh tags: wal-overwrite-frames) | |
|
2016-01-09
| ||
| 23:55 | All WAL frame overwrites even if there are active savepoints. This is safe because a ROLLBACK TO will cause all reverted pages to be rewritten to the WAL file prior to COMMIT. (check-in: 99b31a6b user: drh tags: wal-overwrite-frames) | |
| 18:57 | If it is known that checksums will be recalculated on transaction commit, skip calculating checksums when appending frames to the wal file. When recalculating checksums, recalculate them starting with the first overwritten frame - not the first frame in the transaction. (check-in: 16b34f25 user: dan tags: wal-overwrite-frames) | |
| 16:39 | If a single page is written to the wal file more than once, have each subsequent copy overwrite the original frame. (check-in: 5d113aef user: dan tags: wal-overwrite-frames) | |
|
2016-01-08
| ||
| 22:31 | Typo fix in the previous commit. (check-in: 52c16603 user: drh tags: trunk) | |
| 22:18 | More #ifdef fixes for the unix VFS. (check-in: 122c111e user: drh tags: trunk) | |
| 19:34 | Fix the build for SQLITE_OMIT_SHARED_CACHE, which was broken, possibly by check-in [2d96aeba]. (check-in: 3392f8fa user: drh tags: trunk) | |
| 19:17 | Fix a problem with #ifdefs on the system calls in the unix VFS that causes problems when compiling with SQLITE_OMIT_WAL. (check-in: ceceea4c user: drh tags: trunk) | |
| 17:28 | Remove an obsolete #ifdef related to iOS support. (check-in: e9a51d2a user: drh tags: trunk) | |
| 12:46 | Reduce the number of calls to memset() in sqlite3DbMallocZero(). (check-in: cede2bf8 user: drh tags: trunk) | |
| 08:35 | Fix test file vtabH.test so that it works with SQLITE_ENABLE_ICU builds. (check-in: 19c1f448 user: dan tags: trunk) | |
| 02:27 | Add the experimental SQLITE_FCNTL_JOURNAL_POINTER file control for obtaining the sqlite3_file pointer associated with a rollback journal or WAL file. (check-in: a02ace9a user: drh tags: file-control-journal) | |
|
2016-01-07
| ||
| 21:12 | Omit performance tracking from the memsys5 memory allocator if neither SQLITE_DEBUG nor SQLITE_TEST are defined. (check-in: af5c7714 user: drh tags: trunk) | |
| 17:19 | Fix to cause BtShared.db to be set correctly on shared-cache connections in SQLITE_THREADSAFE=0 builds. Added assert()s to verify the correct setting of BtShared.db. (check-in: 2d96aeba user: drh tags: trunk) | |
| 17:09 | Small performance and size optimization spotted while working on the shared-cache problem. (check-in: 828958ff user: drh tags: trunk) | |
| 16:43 | Add some assert() statements to verify, where possible, that BtShared.db is set correctly. (Closed-Leaf check-in: 359277e0 user: dan tags: shared-cache-fix) | |
| 16:06 | Have the vdbe layer call sqlite3BtreeEnter() on all b-trees in use from within sqlite3VdbeExec() even in SQLITE_THREADSAFE=0 builds. This ensures that BtShared.db is set correctly. (check-in: d0214602 user: dan tags: shared-cache-fix) | |
| 02:06 | Add the "sqlite3 -sourceid" command in the TCL interface. Use that command and others to output additional information about the test configuration at the conclusion of a TCL test. (check-in: 4f80440b user: drh tags: trunk) | |
|
2016-01-06
| ||
| 20:50 | Merge updates from trunk. (check-in: 5cbab637 user: mistachkin tags: altShellFix) | |
| 15:54 | Disable the --limit-mem option on fuzzcheck unless the SQLITE_ENABLE_MEMSYS5 or SQLITE_ENABLE_MEMSYS3 compile-time options are used. (check-in: 55a11fd6 user: drh tags: trunk) | |
| 15:49 | Merge changes for version 3.10.0. (check-in: e1d2ffc0 user: drh tags: begin-concurrent) | |
| 15:14 | Merge changes for version 3.10.0. (check-in: fa4705c9 user: drh tags: sessions) | |
| 14:35 | Merge all version 3.10.0 updates. (check-in: 77c28c2b user: drh tags: apple-osx) | |
| 11:01 | Version 3.10.0 (check-in: fd0a50f0 user: drh tags: trunk, release, version-3.10.0) | |
|
2016-01-05
| ||
| 03:39 | Always use -DSQLITE_ENABLE_MEMSYS5 for fuzzcheck so that the --limit-mem option will work. (check-in: a8556977 user: drh tags: trunk) | |
| 03:39 | Another attempt to get reuse of excess opcode array space working correctly on all architectures and platforms. (check-in: 2f858374 user: drh tags: trunk) | |
| 01:48 | Permit the 'test_fs' test module to be compiled and used on MinGW. (check-in: ac27f38e user: mistachkin tags: trunk) | |
|
2016-01-04
| ||
| 23:43 | Fix a corner case in the opcode-array reuse logic where the number of bytes of reusable space might be computed to be a negative number, due to unusual system alignment restrictions and rounding error. (check-in: 1aa53014 user: drh tags: trunk) | |
| 19:02 | Merge in last-minute patches for the 3.10.0 beta. (check-in: c785cd78 user: drh tags: sessions) | |
| 13:06 | Fix the conflict2.test module which was broken by check-in [e30062e9f6c]. (check-in: b779ca8a user: drh tags: trunk) | |
| 12:07 | A new approach to very large sqlite3_mprintf() strings: Back out the [d655a665] check-in and instead make the size fields in StrAccum unsigned. Strings generated by sqlite3_mprintf() can now be as large as 2^31-1 bytes. (check-in: 7adb789f user: drh tags: trunk) | |
| 04:44 | Improved comment on the vtabH-3.1 test. (check-in: 22abe080 user: drh tags: trunk) | |
| 04:41 | Adjust the vtabH.test module to ignore files in the root directory of Windows machines that contain the "$" character. (check-in: 73e33550 user: drh tags: trunk) | |
| 04:28 | Limit the length of sqlite3_mprintf() output to 2^30 bytes, even if SQLITE_MAX_LENGTH is set larger at compile-time. (check-in: d655a665 user: drh tags: trunk) | |
| 03:48 | Fix a harmless compiler warning. (check-in: 4b404a99 user: drh tags: trunk) | |
| 01:08 | Add releasetest.tcl cases for SQLITE_LIKE_DOESNT_MATCH_BLOB and for SQLITE_ENABLE_CURSOR_HINTS. (check-in: f300c35e user: drh tags: trunk) | |
|
2016-01-03
| ||
| 18:59 | Alternative to [76f5efa6], move definition of utf8_printf up. (check-in: 54c5522d user: mistachkin tags: altShellFix) | |
| 18:07 | Bug fix: the conflict resolution behavior for the implied NOT NULL constraint on the PRIMARY KEY of a WITHOUT ROWID table should be ABORT. (check-in: e30062e9 user: drh tags: trunk) | |
| 11:27 | Fix a premature reference to utf8_printf in shell.c. (check-in: 76f5efa6 user: drh tags: trunk) | |
| 11:17 | Add the number of cores used and the name of the host computer to the summary at the end of releasetest.tcl. (check-in: cd3ae0f1 user: drh tags: trunk) | |
|
2016-01-02
| ||
| 05:00 | Fix a (harmless) typo in an #ifdef for SQLITE_ENABLE_CURSOR_HINTS (check-in: 2047d2de user: drh tags: trunk) | |
|
2016-01-01
| ||
| 16:42 | Remember the size of the Vdbe.aOp[] array in bytes, to avoid unnecessary calls to sqlite3_msize(). (check-in: 3e852804 user: drh tags: trunk) | |
| 16:26 | Avoid misaligned memory allocations on Sparc in sqlite3VdbeMakeReady(). This fixes a problem introduced by check-in [a9e819082b]. (check-in: a304e346 user: drh tags: trunk) | |
| 14:14 | Merge recent trunk enhancements. (check-in: 6bea792c user: drh tags: begin-concurrent) | |
| 13:31 | Merge all recent trunk enhancements. (check-in: 5b700f31 user: drh tags: apple-osx) | |
| 13:25 | Merge the latest enhancements from trunk. (check-in: c0be246a user: drh tags: sessions) | |
| 03:37 | Fix an assert() that might be false for a corrupt database. (check-in: 68360cd2 user: drh tags: trunk) | |
| 00:15 | Remove unreachable branches from the new JSON aggregate functions. (check-in: 6e30f8c6 user: drh tags: trunk) | |
|
2015-12-31
| ||
| 22:29 | Fix the ieee754.test module so that it works both on systems that report infinity as "inf" and as "Inf". (check-in: d41d4d73 user: drh tags: trunk) | |
| 19:06 | In the shell, use utf8_printf() when any string formatting is present and raw_printf() otherwise. (check-in: 8cf01fff user: mistachkin tags: trunk) | |
| 19:04 | Fix harmless compiler warning seen with MSVC. (check-in: 98ec778d user: mistachkin tags: trunk) | |
| 15:34 | Fix harmless compiler warnings associated with SQLITE_ENABLE_HIDDEN_COLUMNS. (check-in: 9c392c10 user: drh tags: trunk) | |
| 04:34 | Small size and performance optimization to the VDBE comparison opcodes. (check-in: 7a0b9413 user: drh tags: trunk) | |
|
2015-12-30
| ||
| 20:50 | Use the OvflOffset() macro to try to remove some magic numbers from btree.c. (Leaf check-in: 1541607d user: drh tags: ovfloffset-macro) | |
| 18:18 | Reduce the size of the CellInfo object from 32 to 24 bytes on 64-bit machines, for a small performance increase and library size reduction. (check-in: 6a4cfc7a user: drh tags: trunk) | |
| 17:03 | Enhance the command-line shell so that it can handle MBCS characters on input and output. (check-in: 3d81dfe3 user: drh tags: trunk) | |
| 16:51 | Changes to the way that the default BINARY collating sequence is recorded result in a slightly smaller and slightly faster executable. More work could be done to make this cleaner. (check-in: 2081d757 user: drh tags: trunk) | |
| 15:18 | Simplification to the xfer-optimization logic. (check-in: f35ba018 user: drh tags: trunk) | |
| 14:06 | Remove unnecessary tests from the LIKE pattern matcher. Slightly faster and slightly smaller, and it should also now works with EBCDIC. (check-in: 0a99a8c4 user: drh tags: trunk) | |
| 13:36 | Enhance the command-line shell to handle MBCS characters on input and output. (Closed-Leaf check-in: a0a08b8c user: drh tags: mbcs-shell) | |
| 01:07 | Add the json_group_array() and json_group_object() aggregate functions to the JSON1 extension. (check-in: 7f386a93 user: drh tags: trunk) | |
|
2015-12-24
| ||
| 14:53 | Avoid a harmless compiler warning on systems where the byteorder cannot be determined at compile-time. (check-in: 7c7b7f26 user: drh tags: trunk) | |
|
2015-12-23
| ||
| 16:42 | Fix some harmless gcc compiler warnings. Mostly in fts5, but also two in the core code. (check-in: 5d44d4a6 user: dan tags: trunk) | |
| 10:54 | Enhance the 'utc' modifier on date/time functions so that if the LHS is already known to be in UTC, the modifier becomes a no-op. This is not an incompatibility because the behavior is documented as "undefined" in that scenario. (check-in: b910a3d5 user: drh tags: trunk) | |
|
2015-12-21
| ||
| 15:22 | Ensure that the Expr objects that describe indexed expressions are not modified by code generation. Fix for an assert() problem found by Jon Metzman using AFL. (check-in: 34073ce8 user: drh tags: trunk) | |
|
2015-12-18
| ||
| 19:07 | Fix a problem with prefix queries on fts5 offsets=0 tables. (check-in: ad0987d8 user: dan tags: fts5-offsets) | |
| 16:29 | Micro-optimizations and comment fixes on the mem5.c memory allocator module. (check-in: 8bf5e056 user: drh tags: trunk) | |
| 03:59 | Reduce the size of the CellInfo object from 32 to 24 bytes on 64-bit machines. (Closed-Leaf check-in: 78507154 user: drh tags: optimize-cellinfo) | |
|
2015-12-17
| ||
| 20:36 | Add the "offsets=0" option to fts5, to create a smaller index without term offset information. A few things are currently broken on this branch. (check-in: 40b5bbf0 user: dan tags: fts5-offsets) | |
| 19:17 | Make the VdbeCursor object even smaller. But the resulting library is bigger and slower than trunk. This branch is a failed experiment. (Leaf check-in: 896a06cc user: drh tags: optimize-vdbecursor) | |
| 17:30 | Reduce the size of the VdbeCursor object by a pointer (the pBt pointer used for ephemeral tables). (check-in: 98b710c3 user: drh tags: optimize-vdbecursor) | |
| 14:18 | Fix the spellfix1_scriptcode() function to ignore whitespace and punctuation, and to recognize hebrew and arabic scripts. (check-in: 7adfa4a5 user: drh tags: trunk) | |
| 13:28 | Fixes for harmless compiler warnings. (check-in: 85ebd46c user: drh tags: trunk) | |
|
2015-12-16
| ||
| 23:30 | Fix even more harmless compiler warnings. (Closed-Leaf check-in: 1d0e6aa1 user: mistachkin tags: msvcWarn) | |
| 22:06 | Fix some more harmless compiler warnings. (check-in: 18f531e1 user: mistachkin tags: msvcWarn) | |
| 21:09 | Fix compiler warning seen with MSVC. (check-in: 18a4c054 user: mistachkin tags: msvcWarn) | |
| 19:55 | Merge recent enhancements from trunk. (check-in: cb22efaf user: drh tags: begin-concurrent) | |
| 19:47 | Merge recent enhancements from trunk. (check-in: f6c9273c user: drh tags: sessions) | |
| 13:07 | Make greater use of the SQLITE_WITHIN macro. (check-in: f2fc3aed user: drh tags: trunk) | |
|
2015-12-15
| ||
| 19:32 | Update the mkautoconfamal.sh script to make the building of the sqlite3-autoconf-VERSION.tar.gz package more orthodox. (check-in: 1928f894 user: dan tags: trunk) | |
| 13:50 | Add the SQLITE_OMIT_PARSER_TRACE compile-time option. (check-in: 2fda43e6 user: drh tags: trunk) | |
|
2015-12-14
| ||
| 19:42 | Add a missing memAboutToChange() macro to vdbe.c, the lack of which was causing an assert() to fail incorrectly. Problem found by libfuzzer. (check-in: 1a247911 user: dan tags: trunk) | |
|
2015-12-12
| ||
| 19:23 | Update some stale comments in delete.c. No changes to code. (Leaf check-in: f59a3326 user: dan tags: onepass-delete-or) | |
| 17:31 | Add further tests for the changes on this branch. Also fix a memory-leak that could follow a malloc failure. (check-in: 21526012 user: dan tags: onepass-delete-or) | |
|
2015-12-11
| ||
| 14:59 | Add a new assert() statement to the snapshot-specific part of sqlite3WalBeginReadTrans(). (check-in: d8a12023 user: dan tags: trunk) | |
| 13:59 | Merge recent changes from trunk. Also remove unused variables to permit compiling with -Werror. (check-in: 57b700ba user: drh tags: onepass-delete-or) | |
| 13:51 | Simplified alignment constraints in the memory reuse logic of sqlite3VdbeMakeReady(). (check-in: e998513e user: drh tags: trunk) | |
| 12:53 | Merge recent trunk enhancements, and in particular the snapshot interface. (check-in: 7e7b2406 user: drh tags: apple-osx) | |
| 12:44 | Add the experimental snapshot interface. Because it is experimental, it is subject to change or removal at a later date. (check-in: 9b124a5a user: drh tags: trunk) | |
| 04:11 | Fix a memory allocation bug introduced last week by check-in [a9e819082ba]. The bug only appears on systems where the size of a structure is not always a multiple of 8 - which in practice means only on 32-bit windows systems. (check-in: 96d3e99f user: drh tags: trunk) | |
| 03:27 | Mention that the snapshot interfaces are only available if SQLite is compiled with SQLITE_ENABLE_SNAPSHOT. (Closed-Leaf check-in: 843c15a5 user: drh tags: snapshot-get) | |
| 03:20 | Disable the snapshot test scripts if not compiled with SQLITE_ENABLE_SNAPSHOT. (check-in: 5fd008f0 user: drh tags: snapshot-get) | |
| 03:16 | Fix a variable type mismatch problem in the snapshot logic. (check-in: 93fb8010 user: drh tags: snapshot-get) | |
| 01:22 | Fix a bad assert related to snapshots. (check-in: 767ee30e user: drh tags: snapshot-get) | |
|
2015-12-10
| ||
| 22:48 | Snapshot documentation updates. Comment changes only - no changes to code. (check-in: ef51a398 user: drh tags: snapshot-get) | |
| 20:03 | Update the sqlite3_snapshot_get() API so that if the caller does not have an open read transaction on the named database, one is automatically opened. (check-in: b9c90f10 user: dan tags: snapshot-get) | |
| 19:44 | Add tests to snapshot.test. (check-in: f3b74362 user: dan tags: snapshot-get) | |
| 19:11 | Return SQLITE_BUSY (not SQLITE_BUSY_SNAPSHOT) if sqlite3_snapshot_open() fails to obtain the shared checkpointer lock. (check-in: 5343060b user: dan tags: snapshot-get) | |
| 18:06 | Add tests to ensure that an sqlite3_snapshot_open() client cannot be tricked into reading a corrupt snapshot even if another process fails mid-checkpoint. (check-in: b908048b user: dan tags: snapshot-get) | |
| 17:59 | Move pointer range comparisons into a macro, where they can be dealt with in a more portable way. (check-in: 05bc4f92 user: drh tags: trunk) | |
| 15:45 | Have sqlite3_snapshot_open() avoid a race condition by taking a shared CHECKPOINTER lock while checking pInfo->nBackfillAttempted. (check-in: 8084eae0 user: dan tags: snapshot-get) | |
| 15:09 | Move pointer range comparisons into a macro, where they can be dealt with in a more portable way. (Closed-Leaf check-in: ad3124c8 user: drh tags: stdint.h) | |
| 03:16 | Fix spacing typo in comment. No changes to code. (check-in: 3a18526f user: mistachkin tags: snapshot-get) | |
| 02:15 | Add the nBackfillAttempted field in formerly unused space in WalCkptInfo and use that field to close the race condition on opening a snapshot. (check-in: cb68e9d0 user: drh tags: snapshot-get) | |
|
2015-12-09
| ||
| 20:05 | Update sqlite3_snapshot_open() to reduce the chances of reading a corrupt snapshot created by a checkpointer process exiting unexpectedly. (check-in: 7315f7cb user: dan tags: snapshot-get) | |
| 17:45 | Add extra test cases to delete4.test. (check-in: 571b64b9 user: dan tags: onepass-delete-or) | |
| 17:23 | Further simplifications to the VDBE code generation logic that flow out of the previous check-in. (check-in: 6a5dfe85 user: drh tags: trunk) | |
| 16:26 | Simplification of the DROP TRIGGER logic using sqlite3NestedParse() instead of hand-coded VDBE code. This is a manual cherry-pick of the key change from check-in [c80bbf14b365d]. (check-in: 8021b4c8 user: drh tags: trunk) | |
| 16:08 | Fix a problem with the DROP TABLE command on this branch. (check-in: c80bbf14 user: dan tags: onepass-delete-or) | |
| 16:04 | Merge unrelated fixes from trunk. (check-in: 362615b4 user: drh tags: snapshot-get) | |
| 10:06 | Add simple tests and bugfixes for DELETE statements that qualify for the OR-optimization. (check-in: 10ca7357 user: dan tags: onepass-delete-or) | |
| 08:13 | Merge latest trunk with this branch. (check-in: dc236f11 user: dan tags: onepass-delete-or) | |
|
2015-12-08
| ||
| 19:50 | Experimental optimization for DELETE statements with WHERE clauses that qualify for the OR-optimization. (check-in: d52376df user: dan tags: onepass-delete-or) | |
| 16:58 | Changes to avoid undefined behavior in memset() and memcpy() and in the comparisons of pointers from different allocations. All problems are found by analysis tools - none have been seen in the wild. (check-in: 901d0b8f user: drh tags: trunk) | |
| 16:08 | Avoid doing comparisons with pointers that might have been previously been passed to realloc() and/or free(). (check-in: f20396ad user: drh tags: trunk) | |
| 14:37 | Avoid unnecessary work inside of verifyDbFile() in the unix VFS. (Closed-Leaf check-in: f3c0579e user: drh tags: unix-vfs-optimization) | |
| 04:18 | Add a test case of the form "WHERE a<2 OR a<3" using PRAGMA count_changes. This test case was failing before the 3.9.0 release. (check-in: 177862c1 user: drh tags: trunk) | |
| 00:47 | Update the TclKit download URL. (check-in: 07e5199c user: mistachkin tags: trunk) | |
|
2015-12-07
| ||
| 23:31 | Update MSVC batch build tool to the latest Windows 10 SDK version. (check-in: 2ad50171 user: mistachkin tags: trunk) | |
| 21:46 | Add the ".changes ON|OFF" command to the sqlite3.exe command-line shell, for testing and verifying the sqlite3_changes() and sqlite3_total_changes() interfaces. (check-in: 9bbe1afc user: drh tags: trunk) | |
| 18:18 | Fix the openDirectory() routine in the unix VFS so that it works for databases located in the root of the filesystem and for database files that have no pathname at all. (check-in: e7ae120d user: drh tags: trunk) | |
| 16:43 | Changes to avoid undefined behavior detected by analysis tools - never observed in the wild. Later: This check-in introduces a bug, fixed at [a304e34675404aee]. (check-in: a9e81908 user: drh tags: trunk) | |
| 14:33 | Add tests for snapshot_get(), _open() and _free(). (check-in: 502cc6f3 user: dan tags: snapshot-get) | |
|
2015-12-05
| ||
| 20:51 | Add untested implementations of experimental APIs sqlite3_snapshot_get(), _open() and _free(). (check-in: 0715eb00 user: dan tags: snapshot-get) | |
|
2015-12-04
| ||
| 13:44 | Remove the dependence on "exec ls -U" from the vtabH.test module, as the -U option to "ls" is not universally available. (check-in: 4ecbc75b user: drh tags: trunk) | |
| 03:27 | Prevent a segfault on Solaris in the test_fs.c due to differences in the definition of the dirent object. (check-in: 042738ad user: drh tags: trunk) | |
|
2015-12-03
| ||
| 22:33 | Fix typos in requirements text and update requirements marks. No changes to code. (check-in: 8534a46c user: drh tags: trunk) | |
| 21:47 | Improved OOM recovery in the SELECT code generator logic. (check-in: e6521a43 user: drh tags: trunk) | |
| 20:50 | Make the SQLITE_ENABLE_8_3_NAMES compile-time option available to sqlite3_compileoption_used(). (check-in: 06338201 user: drh tags: trunk) | |
| 20:42 | Cleaner code and additional comments on the handling of 8+3 filenames when trying to find the name of a database file based on its journal filename, in the unix VFS. (check-in: 9e489a71 user: drh tags: trunk) | |
| 13:43 | Make the sqlite3_status64(), sqlite3_strlike(), and sqlite3_db_cacheflush() APIs available to loadable extensions. (check-in: a78e8656 user: drh tags: trunk) | |
| 12:01 | Fix threadtest3 so that it builds using the autoconf build system. (check-in: d96de532 user: dan tags: trunk) | |
| 11:51 | Improve concurrency in test_multiplex.c. Add a switch to "threadtest3" allowing it to run using the multiplexor VFS. (check-in: 9d2c62b0 user: dan tags: trunk) | |
| 01:48 | A unix VFS change replaces fsync() with fstat() when using SQLITE_NO_SYNC, so set PRAGMA synchronous=OFF in the sysfault-3 test to avoid erroneously causing errors in xSync. (check-in: 4f7f3550 user: drh tags: trunk) | |
|
2015-12-02
| ||
| 20:53 | Merge recent enhancements from trunk. (check-in: 9130661a user: drh tags: begin-concurrent) | |
| 20:40 | Merge recent enhancements from trunk. (check-in: d1a1278d user: drh tags: sessions) | |
| 20:22 | Merge all recent trunk enhancements, especially the unix VFS changes. (check-in: e1fb33c7 user: drh tags: apple-osx) | |
| 19:46 | Remove unreachable branches from the decltype computation logic in the query planner. (check-in: 4f2bcff9 user: drh tags: trunk) | |
| 18:59 | Have the sqlite3_column_decltype() API report the declared types for the left-most SELECT statement in a compound SELECT. (check-in: 3e1d71fc user: dan tags: trunk) | |
| 17:40 | Fix an incorrect, though harmless, assert() in the unix VFS. (check-in: 4692ae84 user: drh tags: trunk) | |
| 16:10 | Remove more (dead) SQLITE_FCNTL_WAL_BLOCK logic from wal.c - code that was missed during the [e1d5320ca08933] check-in. (check-in: 58c15c6a user: drh tags: trunk) | |
| 15:44 | Remove an unreachable branch from the unixMapfile() routine of the unix VFS. (check-in: b50f67bc user: drh tags: trunk) | |
| 13:11 | Minor simplifications to the unix VFS. (check-in: 2f13c16b user: drh tags: trunk) | |
| 02:33 | Change the SQLITE_NO_SYNC compile-time option to call fstat() in place of fsync() rather than being a total no-op. (check-in: f64ea8a0 user: drh tags: trunk) | |
| 02:08 | Fix a (harmless) off-by-one error in the unix VFS logic that fsync()s a directory after deleting a file. (check-in: 3d02711a user: drh tags: trunk) | |
| 01:04 | Simplification of the logic used to take the process-wide lock in the unix-excl VFS. (check-in: 73defd52 user: drh tags: trunk) | |
| 00:05 | Remove all traces of SQLITE_FCNTL_WAL_BLOCK from the unix VFS - that feature had been disabled for a long time and never actually worked. (check-in: e1d5320c user: drh tags: trunk) | |
|
2015-12-01
| ||
| 22:09 | Simplification to the posix_fallocate() replacement used for the SQLITE_FCNTL_SIZE_HINT file control in the unix VFS. (check-in: 74934d3f user: drh tags: trunk) | |
| 21:23 | Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option. (check-in: 9e1d6d4c user: drh tags: trunk) | |
| 17:48 | The test_fs.c test module now works on Windows. (check-in: e3d86284 user: drh tags: trunk) | |
| 16:21 | Simplification to the read and write primatives in the unix VFS. (check-in: 9eefa449 user: drh tags: trunk) | |
|
2015-11-30
| ||
| 23:29 | Add experimental support for the 'test_fs' test module on Win32. (Closed-Leaf check-in: f3ffb3ae user: mistachkin tags: testFsWin32) | |
| 22:52 | Add the SQLITE_PRINTF_PRECISION_LIMIT compile-time option. (check-in: ecad75d6 user: drh tags: trunk) | |
| 22:22 | Fix a problem in xFullPathname for the unix VFS. The problem was found by Kostya Serebryany using libFuzzer. (check-in: bb1e2c4d user: drh tags: trunk) | |
| 20:36 | The EOVERFLOW errors from fstat() is not possible unless SQLite has been compiled with SQLITE_DISABLE_LFS. (check-in: 8cfb7a50 user: drh tags: trunk) | |
| 19:16 | Add a rule to main.mk to build the schemalint.tcl script into an executable. Similar to the way the sqlite3_analyzer executable is built. (check-in: b8251065 user: dan tags: schemalint) | |
| 19:15 | Fix the threadtest3 test program so that it works with VFSes that omit the xCurrentTime() method and supply only xCurrentTimeInt64(). (check-in: 3b155855 user: drh tags: trunk) | |
| 18:17 | Fix the schemalint.tcl script to handle identifiers that require quoting. (check-in: 451e0faf user: dan tags: schemalint) | |
| 12:01 | Add the "colUsed" field to the sqlite3_index_info structure passed to virtual table xBestIndex methods. To indicate the subset of the virtual table columns that may be required by the current scan. (check-in: 47f10b7e user: dan tags: trunk) | |
| 00:05 | Simplifications to the locking logic in the unix-dotfile VFS. (check-in: 58381352 user: drh tags: trunk) | |
|
2015-11-29
| ||
| 21:46 | Fix the sqldiff utility program so that it works for schemas that have tables with zero-length column names. (check-in: 64263ccb user: drh tags: trunk) | |
|
2015-11-28
| ||
| 21:49 | Improvements to temporary file creation logic in the unix VFS. (check-in: d6e177fd user: drh tags: trunk) | |
| 18:06 | Add the SQLITE_FCNTL_VFS_POINTER file control which obtains a pointer to the top-level VFS in use by a database connection. (check-in: 7c6a809e user: drh tags: trunk) | |
| 17:38 | Disable testing with SQLITE_USER_AUTHENTICATION as the makefiles are not set up to do that. (check-in: 14bbcdc6 user: drh tags: trunk) | |
|
2015-11-26
| ||
| 22:12 | The first argument to SQLITE_CONFIG_PAGECACHE, SQLITE_CONFIG_SCRATCH, and SQLITE_CONFIG_HEAP must always be a pointer. (check-in: 5e14cadf user: drh tags: trunk) | |
| 19:33 | Add the "colUsed" field to the sqlite3_index_info structure passed to virtual table xBestIndex methods. To indicate the subset of the virtual table columns that may be required by the current scan. (Closed-Leaf check-in: 116b2064 user: dan tags: vtab-colused) | |
| 15:51 | Fix a problem with the userauth extension and no-authentication databases. Run the tests for this extension as part of the Debug-One module in releasetest.tcl. (check-in: 8b156219 user: dan tags: trunk) | |
| 10:37 | Simplify logic for syncing directories after creating or deleting a file in the unix VFS. (check-in: eb180b4f user: drh tags: trunk) | |
| 02:21 | Small simplification to the xOpen method in the unix VFS. (check-in: 96e7d638 user: drh tags: trunk) | |
|
2015-11-25
| ||
| 23:13 | Simplify the temporary filename generator and the time-of-day functions in the unix VFS. (check-in: 6c5621ce user: drh tags: trunk) | |
| 18:40 | Fix harmless compiler warnings in test_fs.c. Fix typos and clean up the text of the documentation for sqlite3_strglob() and sqlite3_strlike(). (check-in: 697b2053 user: drh tags: trunk) | |
| 18:07 | Update test_fs.c to include a virtual table that reads a file-system hierarchy. Use it to further test GLOB and LIKE support for virtual tables. (check-in: 6ef6578c user: dan tags: trunk) | |
| 18:03 | Make the xAccess method of the unix VFS smaller and faster. (check-in: 191aef98 user: drh tags: trunk) | |
| 15:15 | Remove unused methods from the unix VFS. (check-in: 228bd15b user: drh tags: trunk) | |
| 14:00 | Simplification of the error code translator in os_unix.c. Code cleanup only. The logic is unchanged. (check-in: 2a20f793 user: drh tags: trunk) | |
| 11:56 | Fix the fts5 "prefix=" option to match the documentation (space separated list, multiple prefix= options supported). The undocumented comma-separated format (compatible with fts4) still works. (check-in: 11eb8e87 user: dan tags: trunk) | |
| 01:57 | Enhancement the virtual table interface to support LIKE, GLOB, and REGEXP operators. Also add the sqlite3_strlike() interface, which might be useful as part of the implementation of LIKE on some virtual tables. (check-in: a6bfd469 user: drh tags: trunk) | |
|
2015-11-24
| ||
| 21:23 | Add the sqlite3_strlike() interface, which might be useful for implementing LIKE operators on virtual tables. (Closed-Leaf check-in: e70ec71d user: drh tags: vtab-like-operator) | |
| 18:16 | Fix a problem in whereexpr.c causing a crash while processing a user-function taht accepts zero arguments. (check-in: 069e51b1 user: dan tags: vtab-like-operator) | |
| 18:04 | Fix harmless compiler warnings in the TCL test harness logic. (check-in: 2fba7a96 user: drh tags: vtab-like-operator) | |
| 17:44 | Merge latest trunk changes with this branch. (check-in: 99222bb3 user: dan tags: vtab-like-operator) | |
| 17:39 | Add further tests and related fixes for GLOB/REGEXP/LIKE support in virtual tables. (check-in: c5e9fd0d user: dan tags: vtab-like-operator) | |
| 16:40 | Remove from os_unix.c pointless logic that tries to prevent a recurrence of a warning message that can only occur once. (check-in: 20256177 user: drh tags: trunk) | |
| 15:12 | Fix a comment typo in the unix VFS. No changes to code. (check-in: 32e13879 user: drh tags: trunk) | |
| 15:06 | Make the geteuid() system call overloadable using xSetSystemCall() on the unix VFSes. (check-in: 6c2ddea6 user: drh tags: trunk) | |
| 03:50 | Add a test case for the fix of check-in [19d9f9ce691963310] (check-in: 19a9c07b user: drh tags: trunk) | |
| 02:10 | Remove an incorrect ALWAYS() macro. Fix for ticket [e5c6268dd807fa8950] - a problem introduced in SQLite 3.9.0 and found by libFuzzer. (check-in: 824ad96f user: drh tags: trunk) | |
| 01:17 | Add a clarifying comment to the virtual table test module 'test8'. (check-in: e92f97a6 user: mistachkin tags: trunk) | |
| 00:49 | Do not try to eliminate No-ops at the end of VDBE program as this can cause problems for some DISTINCT handling algorithms, and does not improve performance. This also fixes an assertion fault found by libFuzzer. (check-in: 19d9f9ce user: drh tags: trunk) | |
|
2015-11-23
| ||
| 21:09 | Add experimental support for LIKE, GLOB and REGEXP to the virtual table interface. (check-in: 277a5b40 user: dan tags: vtab-like-operator) | |
| 18:28 | In the CREATE INDEX statements output by schemalint.tcl, avoid declaring an explicit collation sequence that is the same as the column's default. (check-in: d3aa067c user: dan tags: schemalint) | |
| 17:14 | Merge latest trunk changes with this branch. (check-in: 8f1ef090 user: dan tags: schemalint) | |
| 17:10 | Fix ORDER BY handling in the schemalint.tcl script. Add internal self-tests to the same script. (check-in: b8f277c9 user: dan tags: schemalint) | |
|
2015-11-21
| ||
| 19:43 | Fix an obscure memory leak found by libfuzzer that may occur under some circumstances if expanding a "*" expression causes a SELECT to return more than 32767 columns. (check-in: 60de5f23 user: dan tags: trunk) | |
| 17:53 | Add a new OP_BColumn opcode where the cursor is guaranteed to be of type CURTYPE_BTREE and is thus able to skip some checks and run slightly faster. (Leaf check-in: 093e0d10 user: drh tags: btree-column-opcode) | |
| 17:27 | Fix over-length source code lines. No logic changes. (check-in: 198d191b user: drh tags: trunk) | |
| 13:24 | Do not allow table-valued function syntax on ordinary tables and views as those objects are not table-valued functions. Fix for ticket [73eba7ba5c7c0fc]. Problem found by libFuzzer. (check-in: ff5716b8 user: drh tags: trunk) | |
|
2015-11-20
| ||
| 20:55 | Add support for ORDER BY clauses to schemalint.tcl. (check-in: 93bdf70e user: dan tags: schemalint) | |
| 19:22 | Refactor the VdbeCursor object. It is now slightly smaller and faster and is easier to understand. (check-in: 9b1d174d user: drh tags: trunk) | |
| 13:49 | Merge all the latest enhancements and fixes from trunk. (check-in: 41c8b8e3 user: drh tags: begin-concurrent) | |
| 13:33 | In the OP_Column opcode, only test the btree payload size for exceeding the string length limit if the payload does not fit on a single page. (check-in: 35c7f6cb user: drh tags: trunk) | |
| 13:17 | Enhancements to a comment in sqliteInt.h. No changes to code. (check-in: 5446ae64 user: drh tags: trunk) | |
|
2015-11-19
| ||
| 19:48 | Merge the latest enhancements from trunk. (check-in: 2c9e5436 user: drh tags: apple-osx) | |
| 19:40 | Merge the latest enhancements from trunk. (check-in: 7d6cfc79 user: drh tags: sessions) | |
| 19:31 | Merge the latest enhancements from trunk. (check-in: 8aede091 user: drh tags: lsm-vtab) | |
| 19:27 | Work toward more flexible typing for keys and values. (check-in: 5c79f531 user: drh tags: lsm-vtab) | |
| 18:11 | Fix problems with the way the IsHiddenColumn() macro is defined. (check-in: 126b998c user: drh tags: trunk) | |
| 18:09 | Fix a problem with VACUUM and __hidden__ columns. (check-in: 13995756 user: dan tags: trunk) | |
| 17:55 | When manifesting a view as part of an DELETE or UPDATE, be sure to include the hidden columns in the manifestation. (check-in: 28df5dc4 user: drh tags: trunk) | |
| 16:46 | Fix problems with INSERT INTO ... SELECT ... statements that write to tables with __hidden__ columns. (check-in: 59bd0ec7 user: dan tags: trunk) | |
| 16:33 | Create the new TK_ASTERISK token to represent the "*" in "SELECT *". Formerly that operator was TK_ALL, which was also used for UNION ALL. Less confusion if they operator symbols are distinct. (check-in: 201ac6d4 user: drh tags: trunk) | |
| 14:11 | If compiled with SQLITE_ENABLE_HIDDEN_COLUMNS, then columns in ordinary tables and views that have names beginning with "__hidden__" are omitted from the "*" expansion in SELECT statements and from the automatic list of columns following the table name in an INSERT INTO statement. (check-in: 011904ca user: drh tags: trunk) | |
| 13:53 | Only support the magic "__hidden__" column name prefix interpretation when compiled with SQLITE_ENABLE_HIDDEN_COLUMNS. (Closed-Leaf check-in: 5490646b user: drh tags: hidden-columns-in-tables) | |
| 13:21 | Fix a 10-year-old misguided attempt at parser performance improvement that actually made parsing slightly slower. (check-in: 3833cbac user: drh tags: trunk) | |
|
2015-11-18
| ||
| 21:22 | Get the __hidden__ column mechanism working on views with INSTEAD OF triggers. (check-in: 20c1e9ce user: drh tags: hidden-columns-in-tables) | |
| 20:59 | Add tests for views to hidden.test. (check-in: 27d4b6f5 user: dan tags: hidden-columns-in-tables) | |
| 20:57 | Honor the "__hidden__" prefix on the columns of views. (check-in: 3071ba2b user: drh tags: hidden-columns-in-tables) | |
| 20:07 | Add a test for the __hidden__ hack on this branch. (check-in: ebf4bbff user: dan tags: hidden-columns-in-tables) | |
| 18:43 | If a table column name begins with "__hidden__" then do not include that column in "*" expansions in SELECT statements, nor fill in that column in an INSERT INTO that omits the column list. This branch is a proof-of-concept only and is not intended to ever be merged into trunk. (check-in: 2dbffb3a user: drh tags: hidden-columns-in-tables) | |
|
2015-11-17
| ||
| 21:42 | When using mmap mode on Win32, use a read-only mapping by default. Write to the database file using WriteFile(). Unless SQLITE_MMAP_READWRITE is defined, in which case use a read/write mapping and write into the file using memcpy(). (check-in: 4f521b5b user: mistachkin tags: trunk) | |
| 20:56 | When using mmap mode on unix, use a read-only mapping by default. Write to the database file using write(). Unless SQLITE_MMAP_READWRITE is defined, in which case use a read/write mapping and write into the file using memcpy(). (check-in: 67c5d3c6 user: dan tags: trunk) | |
| 19:17 | Fix uninitialized variable in the command line shell. (check-in: dc2ac024 user: mistachkin tags: trunk) | |
| 19:16 | Fix harmless compiler warning. (check-in: eea26b6c user: mistachkin tags: trunk) | |
| 02:23 | Basic functionality is now working. (check-in: aa129c51 user: drh tags: lsm-vtab) | |
| 00:15 | The virtual table compiles but does not work and is missing many features. This is an incremental check-in. (check-in: a32849d6 user: drh tags: lsm-vtab) | |
|
2015-11-16
| ||
| 16:00 | Import the LSM code from SQLite4 for use in an experimental virtual table. NB: This is a speculative experiment and could easily result in a dead-end branch. (check-in: 3d930501 user: drh tags: lsm-vtab) | |
| 15:28 | Add testfixture command "vfs_current_time_int64". Returns the value returned by the xCurrentTimeInt64 method of the default VFS. (check-in: f79d5b18 user: dan tags: trunk) | |
| 08:54 | In the shell tool, avoid testing if (sqlite3_vfs.xGetCurrentInt64) is NULL for a version 1 VFS. This field is only defined for version 2 and greater. (check-in: ad5fcaa5 user: dan tags: trunk) | |
|
2015-11-15
| ||
| 11:13 | Fix the column name uniquifier so that it works with zero-length column names. (check-in: 791761eb user: drh tags: trunk) | |
|
2015-11-14
| ||
| 22:04 | Code simplification in sqlite3ColumnsFromExprList(). Update the %z format code so that it works with buffers obtained from sqlite3DbMalloc(). Add a testcase for the slow column name uniquifier. (check-in: 92724260 user: drh tags: trunk) | |
| 20:52 | Use a hash table to improve the preformance of column name uniqueness checking. (check-in: 5b08f29f user: drh tags: trunk) | |
| 16:47 | Use randomness to prevent slowness in the generated-column-name uniqueness checking. (check-in: 62667129 user: drh tags: trunk) | |
|
2015-11-13
| ||
| 20:52 | Fix a memory leak in the fuzzcheck utility. (check-in: dfd6d9f4 user: drh tags: trunk) | |
| 16:59 | Add the "--enable-static-shell" option to the amalgamation autoconf script. If set (the default) the compiled shell tool is statically linked against sqlite3.o. Otherwise, it is linked against libsqlite3.so. (check-in: 499a02a3 user: dan tags: trunk) | |
| 13:15 | Add the --transaction option to the sqldiff tool. (check-in: 8882d1f3 user: drh tags: trunk) | |
| 12:52 | Fix the releasetest-out.txt log output from releasetest.tcl so that it works when the --jobs option is used. (check-in: 6bb314a5 user: drh tags: trunk) | |
| 12:32 | Disable two PRAGMA cache_spill tests when MEMORY_MANAGEMENT is enabled. (check-in: ebda77aa user: drh tags: trunk) | |
| 02:13 | Merge fixes from trunk. (check-in: f9060b2a user: drh tags: apple-osx) | |
| 00:03 | Change the error messages so that they can be grepped using '^!' instead of '^ '. There are far too many extraneous outputs that begin with a space. (check-in: 367ec0db user: drh tags: trunk) | |
|
2015-11-12
| ||
| 23:48 | Update the SQLLOG logic so that to builds in accordance with the instructions in the header comment. (check-in: ee6f2fee user: drh tags: trunk) | |
| 22:15 | Always parse the schema *before* running "PRAGMA cache_size", not after. (check-in: 12e7d9ec user: drh tags: trunk) | |
| 21:55 | Import the test_sqllog.c enhancements from trunk. (check-in: 178da339 user: drh tags: apple-osx) | |
| 21:42 | Add a space before each line of error output in the test scripts so that all errors can be conveniently located in logs by doing "grep '^ '". (check-in: 9d532fb5 user: drh tags: trunk) | |
| 20:12 | Add support for the SQLITE_SQLLOG_CONDITIONAL environment variable to the logging code in test_sqllog.c. When defined, logging is only performed if the "<database>-sqllog" file is present in the file system when the main database is opened. (check-in: cab8126b user: dan tags: trunk) | |
| 16:51 | Merge the latest enhancements from trunk, and in particular the "PRAGMA cache_spill=N" change. (check-in: e72331c7 user: drh tags: apple-osx) | |
| 16:44 | Enhance the "PRAGMA cache_spill" statement to accept an integer argument which is the threshold at which spilling will begin. (check-in: f79d264d user: drh tags: trunk) | |
| 15:47 | Test cases. Minor problems fixed. All appears to work now. (Closed-Leaf check-in: 9a431362 user: drh tags: cache_spill=N) | |
| 15:04 | Fix a #define in parse.y that disabled unused code in the generated parser. (check-in: f84e3085 user: drh tags: trunk) | |
| 14:57 | First attempt at enhancing the "PRAGMA cache_spill" statement to accept a cache threashold size. (check-in: 549d42be user: drh tags: cache_spill=N) | |
|
2015-11-11
| ||
| 18:43 | Fix missing word in a documentation comment. No changes to code. (check-in: ed24d302 user: mistachkin tags: trunk) | |
| 18:08 | Add a hack to debug out a description of the WHERE clause of a SELECT (or other) statement. Use this in script tool/schemalint.tcl to automatically recommend indexes that might speed up specific queries. (check-in: c6fa01c2 user: dan tags: schemalint) | |
| 15:28 | Improvements to the SQLITE_CONFIG_PAGECACHE documentation. Enhance the command-line shell to be able to take advantage of the full range of SQLITE_CONFIG_PAGECACHE capabilities, such as setting pMem==NULL and N<0. (check-in: 2518d5c9 user: drh tags: trunk) | |
|
2015-11-10
| ||
| 14:51 | Improved output formatting for "PRAGMA parser_trace=ON;". (check-in: e43e1171 user: drh tags: trunk) | |
| 14:27 | Make the output of "PRAGMA parser_trace" go to stdout instead of stderr. (check-in: 1e484991 user: drh tags: trunk) | |
| 13:45 | Save a few bytes in the parser by using "int" instead of "u8" or "u16" for all small integer types. (check-in: 5dcd212b user: drh tags: trunk) | |
| 12:41 | Change all parsers to use the standard "lempar.c" template in the tool/ folder and remove the customized lempar.c from src/, plus other compiler performance and space enhancements. (check-in: 0e7fb24a user: drh tags: trunk) | |
| 12:31 | Fix harmless compiler warnings in FTS5. (Closed-Leaf check-in: 09752e51 user: drh tags: parser-enhancements) | |
| 03:30 | Performance enhancement to the tokenizer. (check-in: 6ea2df86 user: drh tags: parser-enhancements) | |
| 00:02 | Remove an unused non-terminal from the grammar. (check-in: 3c37c522 user: drh tags: parser-enhancements) | |
|
2015-11-09
| ||
| 19:35 | Fix a comment typo in the lempar.c template that was missed by the prior check-in. (check-in: c4a7e93f user: drh tags: parser-enhancements) | |
| 19:33 | Change the parser to use the standard "lempar.c" template over in the tool/ folder rather than the customized "lempar.c" found in src/. (check-in: 0a72991f user: drh tags: parser-enhancements) | |
| 15:06 | Avoid recursion in the yy_find_shift_action() routine of the Lemon-generated parser, so that routine can be inlined, for a size reduction and performance increase. (check-in: 0557a179 user: drh tags: trunk) | |
| 14:11 | Size reduction and performance improvement in the stack-popping logic of the Lemon-generated parser. (check-in: 9748c48a user: drh tags: trunk) | |
| 12:47 | Fix incorrect WHERE clause in sqldiff, as reported on the mailing list by Youcef Hilem. (check-in: e0ed4c3e user: drh tags: trunk) | |
| 12:44 | Check in the cg_anno.tcl and run-speed-test.sh scripts, as an historical record. (check-in: 836418d3 user: drh tags: trunk) | |
| 12:33 | Avoid unnecessary function prologues in the sqlite3VdbeAddOp3() routine. (check-in: 7c6a19ba user: drh tags: trunk) | |
| 02:08 | Small size reduction and performance increase in the parser. (check-in: d62cd757 user: drh tags: trunk) | |
|
2015-11-07
| ||
| 18:32 | Enhance the sqldiff utility to deal gracefully with ALTER TABLE ADD COLUMN. (check-in: 7ea036ac user: drh tags: trunk) | |
| 18:07 | Fix a bug in CTE handling discovered by LibFuzzer that can cause an infinite loop in the query planner. (check-in: 088009ef user: dan tags: trunk) | |
| 17:51 | Add test cases for WITH clauses. (Closed-Leaf check-in: e7e65c75 user: dan tags: infinite-with-loop-bug) | |
| 17:48 | Proposed fix for an infinite loop bug in the WITH clause semantic analysis logic. (check-in: 028475cb user: drh tags: infinite-with-loop-bug) | |
| 15:19 | Enhance TreeView to show WITH clauses. Add an assert to detect the infinite loop behavior when certain kinds of errors occur on a nested WITH clause. (check-in: 2040d88e user: drh tags: infinite-with-loop-bug) | |
| 01:57 | Merge recent enhancements and fixes from trunk. (check-in: 5429f99b user: drh tags: apple-osx) | |
| 01:33 | Merge recent enhancements and bug fixes from trunk. (check-in: 78bc42e6 user: drh tags: sessions) | |
| 01:19 | The OPFLAG_SEEKEQ optimization is only applicable to equality comparisons against an index, not against a rowid table. (check-in: 0f5b147d user: drh tags: trunk) | |
| 00:51 | Fix a harmless sanitizer warning in the ieee754 extension. (check-in: dd9a26ec user: drh tags: trunk) | |
|
2015-11-06
| ||
| 20:22 | Avoid an unnecessary key comparison when doing an indexed lookup against an equality constraint. (check-in: d741e1cc user: drh tags: trunk) | |
| 20:13 | Work around a sign-extension bug in the optimizer on the HP C compiler that comes with HP/UX. (check-in: 46c36b15 user: drh tags: trunk) | |
| 20:04 | Test changes: Omit numindex1.test from valgrind, since valgrind uses a none-standard floating-point processor which gives inconsistent answers. Run one releasetest.tcl module using LONGDOUBLE_TYPE=double. (check-in: d421efbf user: drh tags: trunk) | |
| 19:53 | Enforce consistent comparison results between integer and floating point values. Fix for ticket [38a97a87a6e4e83]. (check-in: 849e686d user: drh tags: trunk) | |
| 17:59 | Merge the fixes and tests for the ieee754 extension. (Closed-Leaf check-in: 7a9988d3 user: drh tags: int-float-precision) | |
| 17:28 | A proposed patch for working around a bug in the optimizer for the HP compiler found on HP/UX Itanium. (Closed-Leaf check-in: 8a171548 user: drh tags: hp-optimizer-fix) | |
| 17:01 | Test cases for the ieee754 extension. (check-in: 840cbda8 user: drh tags: trunk) | |
| 14:59 | A different approach to handling integer/float comparisons. This seems to work better on systems where "long double" and "double" are the same type, but still needs refinement and testing. (check-in: a3f7614b user: drh tags: int-float-precision) | |
| 12:50 | Have fts5 load its configuration from the xConnect() method is invoked. This ensures that the very first query run uses the correct value of the 'rank' option. (check-in: 33e6606f user: dan tags: trunk) | |
| 04:14 | More test cases for indexes on large numeric values. (check-in: c220741a user: drh tags: int-float-precision) | |
| 03:37 | Some simple test cases from the mailing list. (check-in: 1d642b73 user: drh tags: int-float-precision) | |
| 01:04 | Increase the precision of integer vs. floating-point comparisons. Candidate fix for ticket [38a97a87a6e4e8]. (check-in: cfcaa0ff user: drh tags: int-float-precision) | |
|
2015-11-05
| ||
| 22:30 | Improvements and simplifications to the equality seek logic. Tests are adjusted so that they all pass now. (Closed-Leaf check-in: 997ce6c9 user: drh tags: seekeq-experiment) | |
| 21:49 | Fix typo in help information for an FTS5 script. (check-in: 777ae800 user: mistachkin tags: trunk) | |
| 20:25 | The top of an index equality loop normally starts with OP_SeekGE and OP_IdxGT. This check-in adds a flag to OP_SeekGE such that it fails immediately if the key is not equal, then jumps over the OP_IdxGT, saving a call to the key comparison functions. Consider this check-in a proof-of-concept. It needs improvement before going on trunk. Some tests fail, but only because they new use fewer key comparisons than expected (which is a good thing!). (check-in: 32e31b9b user: drh tags: seekeq-experiment) | |
| 18:09 | Add the 'hashsize' configuration option to fts5, for configuring the amount of memory allocated to the in-memory hash table while writing. (check-in: 44548009 user: dan tags: trunk) | |
| 11:47 | Remove a #pragma used to work around an issues with MSVC 2012 that has been overcome but subsequent changes. (check-in: 8303e4cf user: drh tags: trunk) | |
| 03:26 | Remove #pragma that was used to work around an obsolete issue with MSVC 2012. (Closed-Leaf check-in: b9b22fae user: mistachkin tags: reoptimizeArm) | |
|
2015-11-04
| ||
| 22:31 | Performance improvements in the getAndInitPage() routine of btree.c. (check-in: 2aa50f6f user: drh tags: trunk) | |
| 20:22 | Rename the sqlite3PagerAcquire() function to sqlite3PagerGet(). The former macro called sqlite3PagerGet() has been removed. (check-in: 708253be user: drh tags: trunk) | |
| 16:34 | In releasetest.tcl, run larger test first if --jobs is greater than 1. Run smaller tests cases first if --jobs is 1. (check-in: 3fece5d0 user: drh tags: trunk) | |
| 13:03 | Exclude cffault.test and symlink.test from the (incompatible) inmemory_journal permutation. (check-in: 4f16e968 user: drh tags: trunk) | |
|
2015-11-03
| ||
| 23:39 | Increase the fuzzcheck timeout when running valgrind. (check-in: a5816877 user: drh tags: trunk) | |
| 19:13 | In 'e_uri.test', make sure all created test database files get deleted. (check-in: 40c4f4a6 user: mistachkin tags: trunk) | |
| 15:39 | In the releasetest.tcl script, add the --progress option to cause the start of each subprocess to be shown. Otherwise, revert to the old-style display. Improvements to the handling of the --buildonly option. (check-in: d969792f user: drh tags: trunk) | |
| 15:16 | In the releasetest.tcl script, show the --jobs object on the command-line summary. Report the time of each "starting:" event. Do not show errors on a --dryrun. (check-in: b7510777 user: drh tags: trunk) | |
| 14:49 | Update the releasetest.tcl script so that it can run multiple tests in parallel in separate processes. (check-in: e3de8291 user: drh tags: trunk) | |
| 06:23 | Further enhancement and a bit of cleanup. (Closed-Leaf check-in: 0d8b5978 user: mistachkin tags: mp-releasetest) | |
| 02:47 | Use the native name for the MSVC makefile as well. (check-in: e457c615 user: mistachkin tags: mp-releasetest) | |
|
2015-11-02
| ||
| 23:29 | Attempt to centralize and simplify the MSVC handling. (check-in: 4ae96d6d user: mistachkin tags: mp-releasetest) | |
| 23:21 | Fix the backcompat.test module so that it does not try to compare against itself on windows. (check-in: f625bce8 user: drh tags: mp-releasetest) | |
| 21:05 | Get things working better on Windows with MSVC. (check-in: 22cc3e6c user: mistachkin tags: mp-releasetest) | |
| 20:52 | Fix the --dryrun option on the releasetest.tcl script. (check-in: e565e026 user: dan tags: mp-releasetest) | |
| 20:28 | Fix releasetest.tcl so that it does not choke if a test fails so badly that there is no log file. Add the --jobs switch to the usage message. (check-in: 20e96f52 user: dan tags: mp-releasetest) | |
| 20:24 | Fix releasetest.tcl so that output lines are less than 80 characters wide. (check-in: aef177fe user: dan tags: mp-releasetest) | |
| 18:57 | Merge all recent enhancements and fixes from trunk. (check-in: 0546d1cd user: drh tags: sessions) | |
| 18:32 | Add the "--jobs N" option to the releasetest.tcl script to allow tests to be run in parallel by N processes. N defaults to 1. (check-in: 3d29f912 user: dan tags: mp-releasetest) | |
| 18:31 | Version 3.9.2 (check-in: bda77dda user: drh tags: release, branch-3.9, version-3.9.2) | |
| 15:10 | Merge latest trunk changes, including the follow-symlinks functionality and 3.9.2 bugfixes, into this branch. (check-in: 447521d7 user: dan tags: apple-osx) | |
| 15:08 | On unix, if a file is opened via a symlink, create, read and write journal and wal files based on the name of the actual db file, not the symlink. (check-in: 6d5ce3ed user: dan tags: trunk) | |
| 11:19 | When creating an automatic-index on a sub-query, add a unique integer to the end of each index key to ensure the entire key is unique. Fix for [8a2adec1]. (check-in: c0c4b6b3 user: drh tags: branch-3.9) | |
| 11:10 | Aborted releaset of 3.9.2. (check-in: c33a275b user: drh tags: branch-3.9) | |
|
2015-11-01
| ||
| 21:42 | Increase the version number to 3.9.2. (check-in: 14bd4fbf user: drh tags: branch-3.9) | |
| 21:35 | If a table-constraint PRIMARY KEY lists a single column in single-quotes and that column has type INTEGER, then make that column an integer primary key, for historical compatibility. Fix for ticket [ac661962a2aeab3c331]. (check-in: dab0e607 user: drh tags: branch-3.9) | |
| 21:19 | If a table-constraint PRIMARY KEY lists a single column in single-quotes and that column has type INTEGER, then make that column an integer primary key, for historical compatibility. Fix for ticket [ac661962a2aeab3c331]. (check-in: db319a03 user: drh tags: trunk) | |
|
2015-10-31
| ||
| 17:58 | On unix, if a file is opened via a symlink, create, read and write journal and wal files based on the name of the actual db file, not the symlink. (Closed-Leaf check-in: c7c81050 user: dan tags: follow-symlinks) | |
|
2015-10-30
| ||
| 20:54 | Add mutex operations to test code in test3.c to avoid triggering assert() failures in certain configurations. (check-in: 9f19420b user: dan tags: trunk) | |
| 17:17 | Merge the sqlite3_db_cacheflush() enhancements and other changes from trunk. (check-in: f2cde4cf user: drh tags: begin-concurrent) | |
| 16:50 | Merge all the latest enhancements from trunk. (check-in: 395a153f user: drh tags: sessions) | |
| 16:37 | Merge the 3.10.0 version number update from trunk. (check-in: 980d6207 user: drh tags: apple-osx) | |
| 16:36 | Increase the version number to 3.10.0, due to the addition of the sqlite3_db_cacheflush() interface. (check-in: 7565b046 user: drh tags: trunk) | |
| 16:23 | Merge latest trunk changes, including sqlite3_db_cacheflush(), with this branch. (check-in: 6e4306ef user: dan tags: apple-osx) | |
| 16:14 | Add new API function sqlite3_db_cacheflush(). (check-in: ad80d307 user: dan tags: trunk) | |
| 14:28 | Return immediately if sqlite3PagerWrite() is called when the pager is in PAGER_ERROR state. (Closed-Leaf check-in: a6695b00 user: dan tags: cacheflush) | |
| 14:25 | Add the --enable-editline option to various autoconf scripts. (check-in: 866f0277 user: drh tags: trunk) | |
| 09:13 | Test that calling sqlite3_db_cacheflush() does not interfere with savepoints. (check-in: 0e09e4a2 user: dan tags: cacheflush) | |
|
2015-10-29
| ||
| 21:11 | Do not attempt to flush the pages of an in-memory database to disk if sqlite3_db_cacheflush() is called. (check-in: 9b79a390 user: dan tags: cacheflush) | |
| 20:57 | Add a test case that calls sqlite3_db_cacheflush() on an in-memory database. (check-in: f0cdfb54 user: dan tags: cacheflush) | |
| 18:16 | Avoid automatically rolling back the transaction if an SQLITE_IOERR or SQLITE_FULL error occurs within sqlite3_db_cacheflush(). (check-in: 370b5d52 user: dan tags: cacheflush) | |
| 14:29 | The optimization on this branch is logically incorrect. It changes the return value of "SELECT 0 OR 'xyzzy'" FROM 0 to 'xyzzy'. (Closed-Leaf check-in: a0c08d26 user: drh tags: simplify-or-clause) | |
| 13:48 | Fix uses of ctype functions (ex: isspace()) on signed characters in test programs and in some obscure extensions. No changes to the core. (check-in: 34eb6911 user: drh tags: trunk) | |
| 12:27 | Apply optimizations to simplify OR clauses that contain constant terms. (check-in: d533e23f user: drh tags: simplify-or-clause) | |
| 01:11 | Enhance comments in the MSVC batch build tool. (check-in: 2964ce25 user: mistachkin tags: trunk) | |
|
2015-10-28
| ||
| 20:01 | Make the internal sqlite3PExpr() interface responsive to the TKFLG_DONTFOLD flag on the operator parameter. (check-in: b10ab59f user: drh tags: trunk) | |
| 19:46 | Add experimental API sqlite3_db_cacheflush(). (check-in: 65b86dc1 user: dan tags: cacheflush) | |
| 16:05 | Factor out adding NOT expression nodes in the parser into a subroutine. (check-in: 00185418 user: drh tags: trunk) | |
|
2015-10-27
| ||
| 20:04 | Have contentless and external content fts5 tables ignore "OR REPLACE" conflict handling. (check-in: a85c2a47 user: dan tags: trunk) | |
| 17:48 | Fix problems with prefix queries in fts5. (check-in: 3b5758c6 user: dan tags: trunk) | |
| 13:35 | Provide hints to the storage engine using the sqlite3BtreeCursorHint() interface when compiling with SQLITE_ENABLE_CURSOR_HINTS. (check-in: 45d3539e user: drh tags: trunk) | |
| 13:24 | Split out sqlite3BtreeCursorHintFlags() from sqlite3BtreeCursorHint() the interface for improved performance. (Closed-Leaf check-in: b3ec9a0d user: drh tags: cursor-hints) | |
|
2015-10-26
| ||
| 20:50 | Merge latest trunk changes, including the SQLITE_IOERR_AUTH error code, with this branch. (check-in: bc195e1c user: dan tags: apple-osx) | |
| 20:39 | Add new extended error code SQLITE_IOERR_AUTH. (check-in: b4e70dd0 user: dan tags: trunk) | |
| 20:11 | Merge the BTREE_FORDELETE enhancement with this branch. (check-in: 20da0849 user: dan tags: cursor-hints) | |
| 18:51 | Merge in all trunk changes prior to the BTREE_FORDELETE enhancement. (check-in: 53d5a4ad user: drh tags: cursor-hints) | |
| 18:01 | Capture BTREE_FORDELETE test cases that were mistakenly omitted from the previous merge. (check-in: de697251 user: drh tags: trunk) | |
| 17:50 | Provide the BTREE_FORDELETE flag to sqlite3BtreeCursor() if the cursor will be used only for deletions and seeking. (check-in: 871b1c78 user: drh tags: trunk) | |
| 16:34 | Fix an uninitialized variable problem in the test code added by the previous commit. (Closed-Leaf check-in: 7849662e user: dan tags: btree-fordelete-flag) | |
| 16:31 | Test that the binary record "0x01 0x00" is interpreted by OP_Column as a vector of NULL (or default) values. (check-in: 5bdc3c82 user: dan tags: btree-fordelete-flag) | |
| 14:54 | Fix a C99-ism and a harmless compiler warning. (check-in: 138783b5 user: drh tags: trunk) | |
| 14:41 | When compiling with SQLITE_HAS_CODEC, honor the hexkey= query parameter on URI pathnames in sqlite3_open_v2(). (check-in: e0ce3fc0 user: drh tags: trunk) | |
| 12:55 | Remove an unreachable branch in malloc.c. (check-in: a36b7fe9 user: drh tags: trunk) | |
|
2015-10-24
| ||
| 20:31 | When creating an automatic-index on a sub-query, add a unique integer to the end of each index key to ensure the entire key is unique. Fix for [8a2adec1]. (check-in: bfea226d user: dan tags: trunk) | |
|
2015-10-23
| ||
| 11:50 | Remove an unused #define from whereInt.h. Add comments describing the new sqlite3BtreeCursor() flags. (check-in: 4c0ba8be user: dan tags: btree-fordelete-flag) | |
|
2015-10-22
| ||
| 20:54 | Modifications to pass a flag to internal routine sqlite3BtreeCursor() when a cursor that is used solely for deleting b-tree entries, or for obtaining the components of keys to delete from other b-trees, is opened. (check-in: cdc92919 user: dan tags: btree-fordelete-flag) | |
| 18:06 | Alternate compiler warning fix for sqlite3StatusHighwater. (check-in: 4315d202 user: mistachkin tags: trunk) | |
|
2015-10-21
| ||
| 22:08 | Fix harmless compiler warnings in FTS5. (check-in: aa4e01ea user: mistachkin tags: trunk) | |
| 22:07 | Fix compilation of 'testfixture' with MSVC when the FTS5 and JSON1 extensions are enabled. (check-in: e31aa97a user: mistachkin tags: trunk) | |
| 20:56 | Remove some branches made unreachable by recent changes from fts5. (check-in: ae350bfb user: dan tags: trunk) | |
| 20:07 | Minor optimization for fts5 queries. (check-in: 363b36d5 user: dan tags: trunk) | |
| 08:26 | Add extra debugging function to test_rbu.c. Enhance the documentation for sqlite3rbu_db() to define the validity of the returned database handles. (check-in: b9c4aa52 user: dan tags: trunk) | |
|
2015-10-20
| ||
| 23:40 | Fix compiler warnings. (Closed-Leaf check-in: 12e869bb user: mistachkin tags: noWarn) | |
| 23:27 | Fix harmless compiler warnings in FTS5. (check-in: 0a903ec2 user: mistachkin tags: trunk) | |
| 21:05 | More optimizations for fts5 prefix queries. (check-in: b8fb263e user: dan tags: trunk) | |
| 19:55 | Fix #line directives added to generated file fts5.c. (check-in: 1f5f5804 user: dan tags: trunk) | |
| 15:49 | Initialize variables in the fts5 integrity-check code to avoid compiler warnings. (check-in: e979e2cc user: dan tags: trunk) | |
|
2015-10-19
| ||
| 20:49 | Another optimization for fts5 prefix (and other) queries. (check-in: 60a8bde0 user: dan tags: trunk) | |
| 17:43 | Another tweak to improve performance of fts5 prefix queries. (check-in: 69be427c user: dan tags: trunk) | |
| 15:59 | Fix a problem in the fts5txt2db.tcl script causing it to fail when creating tables with more than 8 columns. (check-in: 68ee426a user: dan tags: trunk) | |
|
2015-10-17
| ||
| 20:34 | Add tests to cover new branches added to the fts5 code by the previous commit. (check-in: cf618334 user: dan tags: trunk) | |
| 19:49 | Handle equality and range constraints on the "term" column of fts5vocab tables. Also have the same module report columns using names instead of indexes. (check-in: 6020d96a user: dan tags: trunk) | |
| 01:00 | Change the code generator for UPDATE to generate code in an order that might run more efficiently in many cases. (Leaf check-in: c6239bf9 user: drh tags: improved-update) | |
|
2015-10-16
| ||
| 23:55 | Fix a comment in expr.c and add a CORRUPT_DB to an assert() in btree.c. (check-in: 0df371d1 user: drh tags: trunk) | |
| 20:55 | Merge the 3.9.1 updates from trunk. (check-in: bf866e6c user: drh tags: begin-concurrent) | |
| 20:53 | Merge recent enhancements from trunk. Version now 3.9.1. (check-in: 26fa091d user: drh tags: cursor-hints) | |
| 20:52 | Merge the 3.9.1 changes. (check-in: dd07688d user: drh tags: apple-osx) | |
| 20:20 | Merge the version 3.9.1 updates. (check-in: 2bbb9595 user: drh tags: sessions) | |
| 20:13 | Enhancements to the MSVC makefile. (check-in: 39e8a5d9 user: mistachkin tags: trunk) | |
| 20:12 | Merge the 3.9.1 changes into trunk. (This only updates the version number and configure script since all the other changes in 3.9.1 were cherrypicked from trunk.) (check-in: eb231742 user: drh tags: trunk) | |
| 17:31 | Version 3.9.1 (check-in: 767c1727 user: drh tags: release, branch-3.9, version-3.9.1) | |
| 15:56 | Cherrypick the json form-feed fix, and other #ifdef and build script changes to address minor issues that came to light after the 3.9.0 release. Update the version number to 3.9.1. No logic changes except for the form-feed bug-fix in json1 (ticket [57eec374ae1d0a1d4a]). (check-in: 746fcd2f user: drh tags: branch-3.9) | |
| 15:42 | Fix the fuzzershell utility program so that it compiles with the amalgamation that includes JSON1 support. (check-in: d6fc616e user: drh tags: trunk) | |
| 15:35 | Fix the JSON1 extension so that it does not depend on isdigit() and strtod() from the standard library when compiled into SQLite as part of the amalgamation. (check-in: bc9a9a60 user: drh tags: trunk) | |
| 15:16 | Form-feed is not valid whitespace for json. Fix for ticket [57eec374ae1d0a1d] (check-in: 28957d63 user: drh tags: trunk) | |
| 14:54 | Have the sqlite3VdbeSerialType() function go ahead and compute the serial length as well, since it is always needed. This avoids unnecessary calls to sqlite3VdbeSerialTypeLen(). (check-in: 2ad72be1 user: drh tags: trunk) | |
| 14:23 | Use a lookup table to compute the content length for serial types less than 128, for a 1.2% performance improvement. (check-in: 33957248 user: drh tags: trunk) | |
| 13:50 | Simplify the OP_Column logic slightly. One very small performance improvement added. (check-in: 0114b45d user: drh tags: trunk) | |
| 12:53 | OP_Column optimization: Do not check for an oversize row header unless the row header size is larger than the content available on the local page. (check-in: 8125b74c user: drh tags: trunk) | |
| 12:39 | Improved header comment on the tool/vdbe_profile.tcl script. No changes to code. (check-in: b17ad8fc user: drh tags: trunk) | |
| 03:34 | Whenever two or more OP_Column opcodes on the same cursor occur in succession, try to reordering them so that the one that extracts the right-most column is first, so that it will warm up the row cache for all those that follow. This gives a small performance boost. (Leaf check-in: 08e8f04d user: drh tags: reorder-column-opcodes) | |
|
2015-10-15
| ||
| 21:30 | Performance optimization for the OP_Column opcode. (check-in: 076be547 user: drh tags: trunk) | |
| 21:13 | Merge updates from trunk. (Leaf check-in: 40493680 user: mistachkin tags: mutexInitIsInitReCheck) | |
| 21:12 | Merge updates from trunk. (Leaf check-in: a447cf90 user: mistachkin tags: mutexInitSimpleCmpSwap) | |
| 20:17 | Experiments with an OP_Unpack opcode that extracts multiple columns from a record without caching. (Leaf check-in: 39ae92f5 user: drh tags: unpack-opcode) | |
| 19:21 | Enhance the use of the column cache for UPDATE statements, making them more efficient for the case where a column is modified to be an expression of other unmodified columns. (check-in: 871e091d user: drh tags: trunk) | |
| 18:04 | Add the OP_IntCopy opcode - an optimized version of OP_SCopy that only works for integer values. (check-in: 3a2f73a4 user: drh tags: trunk) | |
| 17:31 | Optimization to the out2Prerelease() helper routine in the VDBE engine. (check-in: 79298fe8 user: drh tags: trunk) | |
| 17:21 | Remove a superfluous conditional from the memory allocation initialization. (check-in: 9ccf8f8d user: drh tags: trunk) | |
| 16:20 | Performance optimizations to the sqlite3MallocSize() by requiring the argument to always be non-NULL. (check-in: cb65989b user: drh tags: trunk) | |
| 15:28 | Change sqlite3StatusSet() into sqlite3StatusHighwater() so that only the highwater mark is recorded. This gives a small size reduction and performance improvement. (check-in: 6422d223 user: drh tags: trunk) | |
| 12:06 | Make sure sqlite.h is not #included by itself. (check-in: a61880c2 user: drh tags: trunk) | |
| 07:44 | Merge in the 3.9.0 changes from trunk. (check-in: 5c3a2a6e user: drh tags: begin-concurrent) | |
|
2015-10-14
| ||
| 23:04 | In the MSVC makefile, add LIBTCLPATH variable to make it easier to run tests when the Tcl library is not already present in the PATH. (check-in: 54127602 user: mistachkin tags: trunk) | |
| 22:46 | In the MSVC makefile, make sure LDFLAGS is used for the tool executables as well. (check-in: 0a17ee49 user: mistachkin tags: trunk) | |
| 21:08 | Tests and minor fixes to improve coverage of FTS5 code. (check-in: f4de6d45 user: dan tags: trunk) | |
| 20:34 | Fix harmless compiler warnings. (check-in: 1c46c194 user: mistachkin tags: trunk) | |
| 20:09 | Merge in all the 3.9.0 updates from trunk. (check-in: 29444149 user: drh tags: cursor-hints) | |
| 20:03 | Update makefiles to remove all uses of "awk" - to make building SQLite easier on Windows systems. The only requirements now are tclsh, a C compiler, and common file utilities. (check-in: 4bd0d43d user: drh tags: trunk) | |
| 20:01 | Enable cross-compiling the various tool EXEs with MSVC. (check-in: 7d772333 user: mistachkin tags: trunk) | |
| 19:52 | Fixes to the JSON1 extension and its use by fuzzcheck to avoid problems when building DLLs. (check-in: 01d3ee7b user: drh tags: trunk) | |
| 19:44 | Fix fuzzcheck.c so that it assumes that JSON1 is already compiled in and does not need to be initialized further. (Closed-Leaf check-in: ec003958 user: drh tags: dll-build-fix) | |
| 18:45 | Avoid exporting sqlite3_json_init() from amalgamation builds. (check-in: 8463f7e7 user: dan tags: dll-build-fix) | |
| 12:29 | Version 3.9.0 (check-in: a721fc0d user: drh tags: trunk, release, version-3.9.0) | |
| 10:56 | Add the missing 'extern "C" {...}' blocks to fts5.h and sqlite3rbu.h. (check-in: 47a2ce97 user: dan tags: trunk) | |
|
2015-10-13
| ||
| 20:42 | Merge in the final few changes before the 3.9.0 release. (check-in: e1afdbb5 user: drh tags: sessions) | |
| 17:49 | Merge 3.9.0 prerelease changes into the apple-osx branch. (check-in: 1900ce01 user: drh tags: apple-osx) | |
|
2015-10-12
| ||
| 22:31 | Remove the unused fts5ExprColsetTest() routine. (check-in: 9ecafc0c user: drh tags: trunk) | |
| 22:20 | Fix a couple harmless compiler warnings. (check-in: 7f896a97 user: mistachkin tags: trunk) | |
| 19:12 | Further tweaks to improve fts5 prefix query performance. (check-in: 1c20c1c2 user: dan tags: trunk) | |
| 04:56 | Change all references to 3.8.12 into 3.9.0. Comment changes only - no changes to code. (check-in: 6f2858f6 user: drh tags: trunk) | |
| 03:56 | Remove AWK requirement from the MSVC batch build tool. (Closed-Leaf check-in: 6d9cdb93 user: mistachkin tags: omit-awk) | |
| 03:44 | The TclKit batch tool should not download the TclKit SDK when the TCLKIT_NOSDK environment variable is set. (check-in: 7c5d583b user: mistachkin tags: omit-awk) | |
|
2015-10-11
| ||
| 20:39 | Detect and report circularly defined views even if the views have the columns defined in the CREATE VIEW statement. (check-in: 9ab9c8c6 user: drh tags: trunk) | |
| 20:08 | Remove an unreachable branch in the query flattener substitution logic. (check-in: 46ee3453 user: drh tags: trunk) | |
| 19:46 | Improved substitution logic in the query flattener. Saves code space, and (more importantly) works correctly with table-valued functions. (check-in: 3d0bd95e user: drh tags: trunk) | |
|
2015-10-10
| ||
| 23:39 | Enhance TclKit batch tool (and MSVC makefile) to support targets that require the Tcl stub library. (check-in: bc6223b1 user: mistachkin tags: omit-awk) | |
| 20:35 | Pull in the latest 3.9.0 tweaks from trunk. (check-in: ed174ccf user: drh tags: sessions) | |
| 16:41 | Work around a "security feature" bug in memcpy() on OpenBSD. (check-in: fab6f090 user: drh tags: trunk) | |
| 15:57 | Remove another instance of strcpy() from FTS5, to mollify OpenBSD. (check-in: 35e6248a user: drh tags: trunk) | |
| 15:11 | Omit the use of strcpy() in FTS5 since OpenBSD hates strcpy(). (check-in: bc24a5bb user: drh tags: trunk) | |
| 14:41 | Compiler warning fixes: Rename some local variables from "j1" to avoid a name collision with the j1() bessel function in the math library. Omit a dummy initializer that gcc 4.6.3 does not like. (check-in: 9ddef84d user: drh tags: trunk) | |
| 14:00 | Add some #ifdef-ery to json1.c to avoid a duplicate typedef when used in the amalgamation, since some compilers become upset over duplicate typedefs. (check-in: de28acd4 user: drh tags: trunk) | |
| 02:06 | Remove a couple superfluous double quotes in the MSVC makefile. (check-in: 0f9e205b user: mistachkin tags: omit-awk) | |
| 01:55 | Fix typo in the MSVC makefile. Replace remaining uses of AWK in the MSVC makefile with a Tcl script. (check-in: f8c2193b user: mistachkin tags: omit-awk) | |
| 00:53 | More fine-tuning to the new TclKit tools. (check-in: 43addd8a user: mistachkin tags: omit-awk) | |
|
2015-10-09
| ||
| 20:40 | The previous fix to JSON1 was not complete. A few more tweaks are needed for correct handling of all oversized integers. (check-in: 4a47f017 user: drh tags: trunk) | |
| 18:48 | Tweak batch tool added in the previous check-in to permit the base URI to be overridden. (check-in: 1d2f82df user: mistachkin tags: omit-awk) | |
| 18:21 | Fix the JSON1 extension so that it renders integers outside the range of -9223372036854775808 to +9223372036854775807 as floating-point numbers. (check-in: ae736e35 user: drh tags: trunk) | |
| 17:54 | Remove fts5 sources from TESTSRC2 in main.mk as there is no SQLITE_TEST code in said files. (check-in: c1840639 user: dan tags: trunk) | |
| 17:36 | Add tool capable of downloading a TclKit (and its associated SDK) on Windows. (check-in: 50673dda user: mistachkin tags: omit-awk) | |
| 17:28 | Merge all changes through the first 3.9.0 beta from trunk. (check-in: 1ccae39b user: drh tags: apple-osx) | |
| 15:29 | Merge the version 3.9.0 changes and the incorporation of JSON1 and FTS5 into the amalgamation from trunk. (check-in: c1d96fb6 user: drh tags: sessions) | |
| 14:37 | Add --enable-fts5 and --enable-json1 options to the amalgamation autoconf package. (check-in: 8a4e1988 user: dan tags: trunk) | |
| 14:23 | In the MSVC makefile, adjust the names of two nmake variables for consistency. (check-in: 92aa4b6b user: mistachkin tags: trunk) | |
| 13:42 | Change the version number of the next release to 3.9.0. (check-in: aa8fdadf user: drh tags: trunk) | |
| 13:39 | Add the JSON1 and FTS5 extensions to the amalgamation. Add new options to ./configure: --enable-json1 and --enable-fts5. (check-in: 1eb76993 user: drh tags: trunk) | |
| 13:29 | Fix a typo in the MSVC Makefile (Closed-Leaf check-in: c8a12082 user: drh tags: amalg-json1-fts5) | |
| 12:48 | Add configure script options --enable-fts5 and --enable-json1. Automatically search for -lm when using --enable-fts5. (check-in: a0c44f1d user: drh tags: amalg-json1-fts5) | |
| 11:09 | Makefile and fts5 changes so that fts5 works with main.mk. Still does not work with Makefile.in. (check-in: 6ebac32d user: dan tags: amalg-json1-fts5) | |
| 01:42 | Trying to get FTS5 tests to build and run using main.mk. Not yet working. (check-in: 206174f9 user: drh tags: amalg-json1-fts5) | |
|
2015-10-08
| ||
| 23:37 | Json1 tests are working. Builds without FTS5 enabled. Still some problems building with FTS5. (check-in: 2928f8e8 user: drh tags: amalg-json1-fts5) | |
| 21:02 | Remove calls to "load_static_extension" from fts5 test scripts. (check-in: 53dd7c4c user: dan tags: amalg-json1-fts5) | |
| 21:00 | Further tweaks to main.mk so that fts5 builds as part of testfixture. (check-in: 97e11b79 user: dan tags: amalg-json1-fts5) | |
| 20:40 | Fix further fts5 compilation issues. (check-in: 0d7f301f user: dan tags: amalg-json1-fts5) | |
| 20:28 | Fix two more warnings in fts5 code. (check-in: 5343e601 user: dan tags: amalg-json1-fts5) | |
| 20:11 | Fix a couple of errors in fts5 compilation. This branch still does not build with -Wall -Werror. (check-in: e9e76e12 user: dan tags: amalg-json1-fts5) | |
| 19:29 | First attempt to add json1 and fts5 to the amalgamation. This check-in does not compile. (check-in: d820a1bd user: drh tags: amalg-json1-fts5) | |
| 17:35 | In the RBU extension, use MoveFile() instead of rename() on Windows CE. (check-in: df9ef61f user: mistachkin tags: trunk) | |
| 14:55 | Merge the 3.8.12 beta changes from trunk. (check-in: 35b1b8d4 user: drh tags: sessions) | |
| 02:44 | Remove two unused lines of code - discovered by scan-build. (check-in: 77b707b7 user: drh tags: trunk) | |
|
2015-10-07
| ||
| 19:06 | Further optimizations for fts5 prefix queries without a prefix index. (check-in: 83dc1ff7 user: dan tags: trunk) | |
| 17:06 | Fix harmless compiler warning in FTS5. (check-in: 13adcd03 user: mistachkin tags: trunk) | |
| 17:01 | Allow the subsitute character (codepoint 26 - 0x1A) to appear in fts5 barewords. (check-in: baec1b96 user: dan tags: trunk) | |
| 16:14 | Adjustments to spellfix2.test so that it works reliably on mac. (check-in: d591e860 user: drh tags: trunk) | |
| 13:24 | Add tests for fts5 phrase queries with column filters. (check-in: f20f9f81 user: dan tags: trunk) | |
| 12:36 | Convert the tool/tostr.awk script into tool/tostr.tcl. Remove two obsolete Makefiles. Purge NAWK from the configure script and from unix makefiles. There are still two uses of NAWK in Makefile.msc. (check-in: 5b677521 user: drh tags: omit-awk) | |
| 12:21 | Change the addopcodes.awk script into tool/addopcodes.tcl. (check-in: 8bbf3714 user: drh tags: omit-awk) | |
| 12:11 | Convert the mkopcodec.awk script into tool/mkopcodec.tcl. (check-in: 1506cb33 user: drh tags: omit-awk) | |
| 09:02 | Add further tests for fts5 prefix queries. (check-in: accdc98b user: dan tags: trunk) | |
| 04:20 | Fix a typo in the previous check-in. (check-in: 80027709 user: mistachkin tags: trunk) | |
| 03:07 | When running tests on Tcl 8.6 under Windows, skip tests 'uri-1.12.*' due to a change in Tcl behavior related to NTFS ADS (alternate data streams). (check-in: 8a0a2aa5 user: mistachkin tags: trunk) | |
| 02:52 | Change mkopcodeh.awk into tool/mkopcodeh.tcl. (check-in: ed0ebc46 user: drh tags: omit-awk) | |
| 00:35 | Remove three obsolete and unused files from tool/ (check-in: 0abd6529 user: drh tags: trunk) | |
|
2015-10-06
| ||
| 21:49 | Fix typo in comments. No changes to code. (check-in: a05f903c user: mistachkin tags: trunk) | |
| 21:07 | Simplifications to the VDBE bytecode that handles LIMIT and OFFSET. (check-in: 041df7c2 user: drh tags: trunk) | |
| 20:53 | Optimizations for fts5 expressions that filter on column. More still to come. (check-in: bf1607ac user: dan tags: trunk) | |
| 17:27 | Fix the LIMIT and OFFSET handling for UNION ALL queries that contain a subquery with ORDER BY on the right-hand side. Fix for ticket [b65cb2c8d91f668584]. (check-in: 4b631364 user: drh tags: trunk) | |
| 01:44 | Adjustments to sqlite3MemoryBarrier() when compiling with MSVC and/or WinCE. (check-in: 3168326e user: mistachkin tags: trunk) | |
|
2015-10-05
| ||
| 19:41 | Improve performance of prefix queries without a prefix index on fts5 tables. (check-in: f2f0184e user: dan tags: trunk) | |
| 15:39 | Update fts3 so that expressions to the left and right of a NOT operator are balanced. This prevents relatively small expressions (a dozen terms or so) that are children of NOT operators from triggering the "expression tree is too large" error. (check-in: d6b66cd7 user: dan tags: trunk) | |
| 11:57 | Add fts5txt2db.tcl, a tool for creating sample fts4/5 databases from text files. (check-in: 44f1ce30 user: dan tags: trunk) | |
|
2015-10-03
| ||
| 15:38 | Update fts5 to support the table function syntax. "... FROM fts5_tbl WHERE fts5_tbl MATCH ?1 AND rank MATCH ?1" can now be written "FROM fts5_tbl(?1, ?2)". (check-in: 41d17d9e user: dan tags: trunk) | |
| 12:23 | Add tests for the rtree module to verify that attempts to insert non-integer primary key values or non-numeric dimensions into an rtree table are handled correctly. (check-in: f653fce9 user: dan tags: trunk) | |
|
2015-10-02
| ||
| 20:04 | Update fts5 to avoid using a statement journal for UPDATE and DELETE operations that affect at most a single row. (check-in: 5c83b9db user: dan tags: trunk) | |
|
2015-10-01
| ||
| 18:31 | Fix an fts3 bug causing NEAR queries on uncommitted data to malfunction. (check-in: 6f90839e user: dan tags: trunk) | |
| 16:35 | Changes to the sesssions module ensure that tables appear within changesets and patchsets in the same order that they were attached to the sessions object. (check-in: 76958902 user: dan tags: sessions) | |
|
2015-09-30
| ||
| 14:50 | Merge recent enhancements from trunk, and especially the fix for ticket [1b266395d6bc10]. (check-in: b2face9a user: drh tags: sessions) | |
| 14:30 | Add a corrupt database to test/fuzzdata3.db to validate the previous check-in. (check-in: e796c0ef user: drh tags: trunk) | |
| 14:19 | Fix an assert() in btree.c that is only true for non-corrupt databases. (check-in: 29f7227f user: drh tags: trunk) | |
| 12:59 | Clear the BTCF_ValidNKey flag when putting a cursor into REQUIRESEEK state. Fix for [1b266395]. (check-in: a6d5e4e8 user: dan tags: trunk) | |
| 11:19 | Improve error handling in shell command ".tables". (check-in: 31a91ee7 user: dan tags: trunk) | |
|
2015-09-29
| ||
| 17:51 |
This condition was not always true after all.....
Change an always-true condition in the virtual table transaction interface into an assert(). (Closed-Leaf check-in: 3e15dea5 user: drh tags: mistake) | |
| 17:20 | Use symbolic names XN_ROWID and XN_EXPR in place of the (-1) and (-2) magic numbers in Index.aiColumn[]. Add asserts to help verify that Index.aiColumn[] is always used correctly. Fix one place in FK processing where Index.aiColumn[] was not being used correctly. (check-in: 7d272aa6 user: drh tags: trunk) | |
| 16:47 | Add the sqlite3_index_info.idxFlags field, allowing xBestIndex() implementations to specify to SQLite that a strategy may visit at most one row. Add support for this to fts3/4. Omit the statement journal from virtual table UPDATE and DELETE operations that are guaranteed not to affect more than one row. (check-in: a1d08fd3 user: dan tags: trunk) | |
| 16:41 | Ensure that the xSavepoint() virtual table method is correctly invoked if there are already open savepoints (or statement transactions) the first time a virtual table is written within a transaction. (check-in: 77948b5e user: dan tags: trunk) | |
| 15:50 | Remove dead code, replacing with assert() statements that make sure the code really was dead. (Closed-Leaf check-in: 0e317dda user: drh tags: vtab-onepass) | |
| 13:25 | Create the sqlite3IsToplevel(Parse*) interface to check to see if a top-level VDBE is being coded (versus a trigger) and use that interface. (check-in: 59662cd2 user: drh tags: vtab-onepass) | |
| 12:32 | Fix compiler warnings. (check-in: d1a07838 user: drh tags: vtab-onepass) | |
| 12:19 | Fix an off-by-one error in test function fts5_decode(). (check-in: 3a9f0762 user: dan tags: trunk) | |
| 11:59 | Merge latest trunk change into this branch. (check-in: b519c0d6 user: dan tags: vtab-onepass) | |
| 11:57 | Change the name of the new sqlite3_index_info.flags field to "idxFlags". Add documentation for the same to sqlite.h.in. (check-in: f61203bc user: dan tags: vtab-onepass) | |
| 10:11 | Add tests for fts3 and onepass update/delete operations. Also fix a problem with onepass updates that do not affect any rows. (check-in: 820c8044 user: dan tags: vtab-onepass) | |
|
2015-09-28
| ||
| 23:45 | Avoid unnecessary cursors and seeking when running a DELETE against a WITHOUT ROWID table. (Leaf check-in: 70ec88b2 user: drh tags: delete-without-rowid-opt) | |
| 20:03 | Also allow UPDATE on virtual tables to use the onepass strategy. (check-in: 1aa27d70 user: dan tags: vtab-onepass) | |
| 17:05 | Extra information provided by .wheretrace on input flags to the query planner and on the result of sqlite3WhereOkOnePass(). (check-in: c5566bb3 user: drh tags: trunk) | |
| 15:23 | Update fts3 to use the onepass strategy for delete operations. (check-in: fffab4f7 user: dan tags: vtab-onepass) | |
| 15:20 | Changes to allow DELETE operations on virtual tables to use the onepass strategy under some circumstances. (check-in: e73f919f user: dan tags: vtab-onepass) | |
| 15:08 | Add test cases to the ONEPASS optimization corruption problem fixed by the previous check-in. (check-in: 5c14d447 user: drh tags: trunk) | |
| 14:40 | Fix a database corruption bug caused by the ONEPASS optimization added in check-in [8b93cc5937000535]. Bug detected (prior to release) by sqllogictest. Test cases to follow. (check-in: 9d057f52 user: drh tags: trunk) | |
|
2015-09-26
| ||
| 17:44 | Enable adding JSON1 by appending the json1.c source file to the amalgamation and compiling with -DSQLITE_ENABLE_JSON1 (check-in: 33404b20 user: drh tags: trunk) | |
| 11:15 | Fix a memory leak that can occur following a syntax error in CREATE VIEW. (check-in: f4704035 user: drh tags: trunk) | |
| 03:31 | Fix the title of the documentation on sqlite3_value_subtype(). This is a comment change only. (check-in: b7902354 user: drh tags: trunk) | |
| 03:23 | Expand the header comment to clarify the purpose for the sqlite3MemoryBarrier() function. (check-in: b89495ae user: drh tags: trunk) | |
| 01:28 | Remove an assert in the windows worker-thread logic that can fail in a race condition. (check-in: d7bfb960 user: drh tags: trunk) | |
|
2015-09-25
| ||
| 23:40 | Fix threads.c so that setting sqlite3FaultSim(200) using the SQLITE_TESTCTRL_FAULT_INSTALL callback causes both unix and windows worker threads to be sequential and deterministic, so that they can be tested reliably. (check-in: 2d867c05 user: drh tags: trunk) | |
| 20:49 | Fix PRAGMA integrity_check so that it works with a UNIQUE index over expressions. (check-in: 113181ce user: drh tags: trunk) | |
| 20:18 | Fix a faulty assert() on the benign-malloc controller callback in test_malloc.c. (Leaf check-in: 64f2cb8d user: drh tags: malloc-testing) | |
| 16:29 | Disable the SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS mechanism and replace it with SQLITE_TESTCTRL_BENIGN_MALLOC_CTRL, which gives better control. (check-in: 2c57b2f3 user: drh tags: malloc-testing) | |
| 13:42 | Report an error if the number of named columns in a VIEW is different from the number of result columns in the SELECT statement that implements the VIEW. (check-in: 6e4ac0be user: drh tags: trunk) | |
| 01:09 | Fix a problem computing affinities for indexes during skip-scan code generation when SQLITE_ENABLE_STAT4 is on. Bug introduced by check-in [1ee089a72d789002]. (check-in: 1350dd42 user: drh tags: trunk) | |
|
2015-09-24
| ||
| 18:47 | Enhance the query planner so that it is able to use indexed expressions to help fulfill an ORDER BY clause. (check-in: 668fc1eb user: drh tags: trunk) | |
| 17:38 | Fix over-length source code lines in where.c. No logic changes. (check-in: 1c8c5380 user: drh tags: trunk) | |
| 15:17 | Merge all recent trunk enhancements and fixes into the begin-concurrent branch. (check-in: c63c1e15 user: drh tags: begin-concurrent) | |
| 15:06 | Merge trunk changes into the cursor-hints branch. (check-in: fbe63762 user: drh tags: cursor-hints) | |
| 14:43 | Merge recent trunk enhancements into the apple-osx branch. (check-in: 4dd06d8b user: drh tags: apple-osx) | |
| 14:26 | Merge all the latest trunk enhancements into the sessions branch. (check-in: c91065f8 user: drh tags: sessions) | |
| 12:40 | Strengthen the implementations of xShmMemoryBarrier on both the unix and windows VFSes, so that they likely work even if SQLITE_THREADSAFE=0 is used. (check-in: c6ab807b user: drh tags: trunk) | |
| 12:19 | Make sure joins work correctly when both sides of the join are connected using indexed expressions. (check-in: c2fcb032 user: drh tags: trunk) | |
| 11:26 | Correctly handle the case of a WHERE-clause term with indexed expressions on both sides of the == sign. (check-in: d9b716a6 user: drh tags: trunk) | |
| 11:06 | Fix a JSON1 test case so that it works on builds that omit virtual tables. (check-in: a4444c0f user: drh tags: trunk) | |
| 01:40 | Another (smaller) performance optimization for the JSON parser. (check-in: c43daa8c user: drh tags: trunk) | |
| 01:06 | Performance optimizations on the JSON parser. (check-in: 7dd4b07a user: drh tags: trunk) | |
|
2015-09-23
| ||
| 19:17 | Take care that the number of reserved bits per page is consistent between the source and destination databases when doing the back-copy on a VACUUM. (check-in: 5b61b72f user: drh tags: trunk) | |
| 16:35 | Merge updates from trunk. (check-in: 0a75ebd2 user: mistachkin tags: mutexInitIsInitReCheck) | |
| 16:33 | Correct superfluous whitespace difference. No functional changes. (check-in: 8d69983d user: mistachkin tags: mutexInitSimpleCmpSwap) | |
| 16:24 | Simplify thread-safety of mutex initialization. (check-in: da0587c5 user: mistachkin tags: mutexInitSimpleCmpSwap) | |
| 15:54 | Merge updates from trunk. (Closed-Leaf check-in: 6b85f8cd user: mistachkin tags: mutexInitCmpSwap) | |
| 11:59 | Capture AFL-generated fuzz tests for json1.c into the test/fuzzdata4.db file. (check-in: 10a214fd user: drh tags: trunk) | |
| 01:10 | Do not allow a comma at the end of a JSON array or object. (check-in: 7c7a3f3e user: drh tags: trunk) | |
|
2015-09-22
| ||
| 18:51 | Add the --export-sql and --export-db options to the fuzzcheck utility program. (check-in: 760af445 user: drh tags: trunk) | |
| 17:46 | Fix a typo in the --help screen of the fuzzcheck utility. (check-in: b6ae61fe user: drh tags: trunk) | |
| 01:15 | Futher simplifications to json1.c. Also an obscure bug-fix in the initial output of json_tree() when using a path to an object contained within an array. (check-in: fcb1e327 user: drh tags: trunk) | |
| 00:21 | Fix json_set() so that it can overwrite a value that was previously overwritten during the same call. (check-in: 0f160416 user: drh tags: trunk) | |
|
2015-09-21
| ||
| 23:53 | For MSVC, have the 'sqlite3.c' target depend on 'sqlite3ext.h' as well as other targets may depend on this behavior (e.g. extensions). (check-in: 737ac3fa user: mistachkin tags: trunk) | |
| 23:49 | Fix compilation under older versions of MSVC. (check-in: 17150ada user: mistachkin tags: trunk) | |
| 22:53 | Simplifications to the json1.c logic. (check-in: 1646a2bd user: drh tags: trunk) | |
|
2015-09-20
| ||
| 22:57 | Fix an overly-strict assert() in the btree logic. (check-in: 825ce320 user: drh tags: trunk) | |
|
2015-09-19
| ||
| 20:27 | Do not allow table-valued function syntax to be used on a view. (check-in: 97cfe346 user: drh tags: trunk) | |
| 19:36 | Add the --disable-lookaside option to the fuzzershell utility program. (check-in: 0b043744 user: drh tags: trunk) | |
| 18:54 | Fix a memory leak in json1.c that could occur after misuse of json_object(). (check-in: 394b81b1 user: drh tags: trunk) | |
| 18:11 | Add an assert() statement to delete.c. (check-in: 40fce67e user: dan tags: trunk) | |
| 18:08 | Fix compiler warnings. (check-in: 5c31ee62 user: drh tags: trunk) | |
| 16:51 | Add json1.c to the fuzzer test shells. (check-in: 809d67b6 user: drh tags: trunk) | |
| 16:45 | Adjust Makefiles to use SQLITE_CORE when statically linking json1.c into test shells. (Closed-Leaf check-in: 91682ac3 user: drh tags: json-fuzz) | |
| 14:57 | Adjust fuzzershell so that it adds the json1 extension separately for each no connection. (check-in: ca2d1e90 user: drh tags: json-fuzz) | |
| 14:32 | Include json1.c in fuzzcheck and fuzzershell. (check-in: c4b68eff user: drh tags: json-fuzz) | |
| 12:04 | Fix a documentation typo in sqlite3_bind_parameter_index(). No code changes. (check-in: 650605a8 user: drh tags: trunk) | |
| 11:57 | Fix an off-by-one error (really off-by-2 in this case) in the buffer resize logic of json1. (check-in: d2a02737 user: drh tags: trunk) | |
| 03:07 | Do not allow rowid in a UNIQUE or PRIMARY KEY constraint. (This restores the same behavior exhibited by all prior releases.) (check-in: b1278301 user: drh tags: trunk) | |
|
2015-09-18
| ||
| 18:09 | Fix a crash that can occur with a skip-scan on an index with expressions when SQLITE_ENABLE_EXPLAIN_COMMENTS is defined. (check-in: 25f34cb9 user: drh tags: trunk) | |
| 15:38 | Adjustments to the spellfix2.test module so that it works reliably on windows. (check-in: 09a313fb user: drh tags: trunk) | |
| 15:35 | Adjust two test cases so that they conform to the current code. (check-in: 228e3d7c user: drh tags: trunk) | |
| 15:13 | Fix sqlilimits.test module so that it knows that the SELECT in a CREATE VIEW is not checked until the view is actually used. (check-in: acf5d87f user: drh tags: trunk) | |
| 14:45 | Ensure that "PRAGMA integrity_check" reports an error if the free-list count header field contains a value smaller than the actual number of pages on the database free-list. (check-in: 26f64986 user: dan tags: trunk) | |
| 14:42 | Fix the orderby9.test case so that it works with 32-bit versions of TCL (check-in: 4b6af774 user: drh tags: trunk) | |
| 14:22 | Remove a test made obsolete by the ONEPASS DELETE optimization. (check-in: c88b62c2 user: drh tags: trunk) | |
|
2015-09-17
| ||
| 17:21 | Avoid passing (signed char) values directly to isspace(), isalnum() or isdigit() in json1.c. Cast the value to (unsigned char) first. (check-in: 6713e35b user: dan tags: trunk) | |
| 09:48 | Fix a crash in FTS5 caused by specifying NULL as the rhs of a MATCH operator. (check-in: e8ed62f8 user: dan tags: trunk) | |
|
2015-09-16
| ||
| 17:46 | Add a "flush" to force incremental output to releasetest-out.txt while running the test/releasetest.tcl. script. (check-in: 0f3de2d3 user: drh tags: trunk) | |
| 12:31 | Fix typo in fts5.h. (check-in: 07721c6c user: dan tags: trunk) | |
|
2015-09-15
| ||
| 19:16 | Merge enhancements from trunk. (check-in: fc4d1de8 user: drh tags: begin-concurrent) | |
| 17:31 | Merge enhancements from trunk. (check-in: 66fe0683 user: drh tags: cursor-hints) | |
| 17:20 | Merge trunk enhancements into the apple-osx branch. (check-in: f12b8a0f user: drh tags: apple-osx) | |
| 15:55 | Merge the latest trunk enhancements with this branch. (check-in: b7469c44 user: dan tags: sessions) | |
| 14:39 | Add test cases to cover fts5 integrity-check code. (check-in: 1d018c35 user: dan tags: trunk) | |
| 13:42 | Reformat some code to make it easier to merge with sessions. No logic changes. (check-in: eade355f user: drh tags: trunk) | |
| 11:58 | Fix a problem with fts5 "ORDER BY rowid DESC" queries and large terms. (check-in: b26d8f79 user: dan tags: trunk) | |
|
2015-09-14
| ||
| 22:54 | Remove a comment that is no longer accurate. (check-in: cf114c18 user: mistachkin tags: mutexInitIsInitReCheck) | |
| 22:53 | Merge updates from trunk. (check-in: 25c15771 user: mistachkin tags: mutexInitIsInitReCheck) | |
| 22:52 | Re-check sqlite3GlobalConfig.isInit after the mutex subsystem has been initialized. (check-in: fea8c0b2 user: mistachkin tags: mutexInitIsInitReCheck) | |
| 19:51 | Improve test coverage of fts5_index.c. (check-in: c1f76686 user: dan tags: trunk) | |
| 19:26 | Testability improvements for the ONEPASS_MULTI enhancement. (check-in: d2df93f2 user: drh tags: trunk) | |
| 14:49 | Fix a typo in an SQLITE_USER_AUTHENTICATION macro. (check-in: 379455af user: drh tags: trunk) | |
| 14:45 | Use symbolic names ONEPASS_OFF, ONEPASS_SINGLE, and ONEPASS_MULTI for the various modes of the one-pass optimization. (check-in: 16e56bda user: drh tags: trunk) | |
| 14:08 | Fix a compiler warning and providing missing VdbeCoverage() calls. (check-in: 2edd2e5e user: drh tags: trunk) | |
| 11:09 | Use a single-pass approach for DELETE statements on non-virtual tables that do not require trigger or foreign key processing. (check-in: 8b93cc59 user: dan tags: trunk) | |
| 10:47 | Merge the latest trunk enhancements. (check-in: 22ce9218 user: drh tags: sessions) | |
| 09:23 | Avoid calling sqlite3VdbeCursorMoveto() from more than one point in vdbe.c. Doing so prevents it from being inlined as part of OP_Column. (Closed-Leaf check-in: 166d5af8 user: dan tags: onepass-delete) | |
|
2015-09-13
| ||
| 20:15 | Add static VFS mutexes to the primary header file comments. (check-in: 9a867d9f user: mistachkin tags: trunk) | |
| 18:45 | Experimental changes to avoid recusrively calling xMutexInit. (check-in: c9400ff1 user: mistachkin tags: mutexInitCmpSwap) | |
| 18:43 | Merge updates from trunk. (check-in: b42c2e20 user: mistachkin tags: mutexInitCmpSwap) | |
|
2015-09-12
| ||
| 19:50 | Fix compiler warnings in delete.c. (check-in: 0a4d285e user: dan tags: onepass-delete) | |
| 19:27 | Fix API documentation typos. Emphasize that the sqlite3_config() routine is not threadsafe. (check-in: 786333e0 user: drh tags: trunk) | |
| 19:26 | Experimental change to use a single-pass approach for DELETE statements on non-virtual tables that do not fire triggers or require foriegn-key processing. (check-in: eaeb2b80 user: dan tags: onepass-delete) | |
| 18:58 | Merge updates from trunk. (check-in: d8051f61 user: mistachkin tags: mutexInitCmpSwap) | |
| 18:57 | Import common changes from the mutex initialization branch. (check-in: 334720c0 user: mistachkin tags: trunk) | |
| 16:59 | Merge updates from trunk. (check-in: 48597789 user: mistachkin tags: mutexInitCmpSwap) | |
| 04:22 | Fix comments. (check-in: de3fa51e user: mistachkin tags: mutexInitCmpSwap) | |
| 04:19 | Specifying an invalid mutex implementation (via SQLITE_CONFIG_MUTEX) should cause the default one to be used instead. (check-in: 1a97bc81 user: mistachkin tags: mutexInitCmpSwap) | |
| 03:40 | Clarify the new mutex implementation reset logic in sqlite3_shutdown(). (check-in: f9a03483 user: mistachkin tags: mutexInitCmpSwap) | |
| 03:35 | Add more asserts to the mutex subsystem. (check-in: 7562f1fb user: mistachkin tags: mutexInitCmpSwap) | |
| 01:17 | Fix typo in the Win32 implementation of sqlite3CompareAndSwap. (check-in: 31a26a1d user: mistachkin tags: mutexInitCmpSwap) | |
|
2015-09-11
| ||
| 23:24 | Make sure that the mutex implementation can be altered after calling sqlite3_shutdown(). (check-in: dc2cf897 user: mistachkin tags: mutexInitCmpSwap) | |
| 20:54 | Update evidence marks due to wording changes in requirements text. No changes to code. (check-in: 86781093 user: drh tags: trunk) | |
| 18:05 | Fix harmless compiler warnings. (check-in: bfc7b84b user: mistachkin tags: trunk) | |
| 15:32 | More test cases in test/json102.test corresponding to new examples in the json1 documentation. (check-in: f599a42e user: drh tags: trunk) | |
| 14:15 | Fix some compiler warnings in fts5 code. (check-in: 0dc43611 user: dan tags: trunk) | |
| 05:06 | Enhance mutex initialization to prevent possible race conditions between sqlite3_initialize() and sqlite3_config(). Also, re-check sqlite3GlobalConfig.isInit after the mutex subsystem has been initialized. (check-in: f6a8f577 user: mistachkin tags: mutexInitCmpSwap) | |
| 01:22 | Updates to the sqlite3_value_subtype() and sqlite3_result_subtype() documentation and to test cases for json1 dealing with those interfaces. (check-in: d6cadbe9 user: drh tags: trunk) | |
| 00:26 | Add new interfaces sqlite3_value_subtype() and sqlite3_result_subtype(). Update the json1.c extension to take advantages of those interfaces to avoid the goofy '$$' path syntax and to allow nested calls to json_array() and json_object() that work as expected. (check-in: db4152ae user: drh tags: trunk) | |
| 00:06 | Take out the goofy '$$' path syntax. Instead, use subtypes to communicate when a string is JSON. Add the json() function that validates and minifies the JSON and sets the appropriate subtype. (Closed-Leaf check-in: 8a80d645 user: drh tags: subtypes) | |
|
2015-09-10
| ||
| 20:40 | Make the sqlite3_value_subtype() and sqlite3_result_subtype() interfaces available to loadable extensions. (check-in: c6fca0be user: drh tags: subtypes) | |
| 20:34 | Experimental implementation of sqlite3_result_subtype() and sqlite3_value_subtype() interfaces. (check-in: 7b5be299 user: drh tags: subtypes) | |
| 19:22 | Fix a potential NULL pointer deref in the testing logic of pcache1. NB: The -DSQLITE_TEST compile-time option is needed to hit the problem. (check-in: f5580f08 user: drh tags: trunk) | |
| 17:23 | Modify the fts5 leaf page format to permit faster seek operations. This is a file-format change. Any existing databases can be upgraded by running the fts5 'rebuild' command. (check-in: 0c0c4ae9 user: dan tags: trunk) | |
| 16:39 | Increment the fts5 version value to indicate that the on-disk format has changed. (Closed-Leaf check-in: 99de5e36 user: dan tags: fts5-incompatible) | |
| 16:19 | Fix a segfault in fts5 that could occur if the database contents were corrupt. (check-in: 4931e37d user: dan tags: fts5-incompatible) | |
| 15:52 | Merge latest changes from trunk. Including fts5_expr.c fixes. (check-in: 716e7e74 user: dan tags: fts5-incompatible) | |
| 15:49 | Update description of on-disk format in fts5_index.c. (check-in: 85aac7b8 user: dan tags: fts5-incompatible) | |
| 10:40 | Revert an accidentally committed makefile change. (check-in: 402704b1 user: dan tags: fts5-incompatible) | |
| 10:01 | Fix an fts5 problem that could occur if a term and the first associated rowid are on different leaf pages. (check-in: ffe2796a user: dan tags: fts5-incompatible) | |
| 05:40 | Change the array of 16-bit offsets at the end of each page to an array of varints. (check-in: fab245be user: dan tags: fts5-incompatible) | |
|
2015-09-09
| ||
| 08:15 | Fix a bug in preprocessor macros within fts5_main.c. (check-in: 0eb2b952 user: dan tags: fts5-incompatible) | |
|
2015-09-08
| ||
| 19:55 | Remove the 0x00 terminators from the end of fts5 doclists stored on disk. (check-in: 00d99006 user: dan tags: fts5-incompatible) | |
|
2015-09-07
| ||
| 08:14 | Use macros to make the code in fts5_index.c easier to read. (check-in: 67ff5ae8 user: dan tags: fts5-incompatible) | |
|
2015-09-05
| ||
| 19:52 | Experiment with a different fts5 leaf page format that allows faster seeks. (check-in: a1f4c3b5 user: dan tags: fts5-incompatible) | |