Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 ancestors of [700a3c69]
|
2017-10-16
| ||
| 11:50 | Improved comments, including a typo fix, on the whereLoopCheaperProperSubset() function. check-in: 700a3c69 user: drh tags: trunk | |
|
2017-10-15
| ||
| 22:16 | In the query planner, do not consider index X to be a proper subset of index Y if X is a covering index but Y is not. check-in: ee31c043 user: drh tags: trunk | |
|
2017-10-14
| ||
| 19:54 | Updates to the Makefiles for MSVC. check-in: ac8786f3 user: mistachkin tags: trunk | |
|
2017-10-13
| ||
| 20:14 | Improved ability to generate stand-alone program using TCL and SQLite by compiling with -DTCLSH_INIT_PROC=name to cause the TCL interpreter to be initialized using procedure name(). Both sqlite3_analyzer and testfixture are now built this way. check-in: d65d1f29 user: drh tags: trunk | |
| 18:58 | Add the tcl/mkccode.tcl script used to construct a single C-language source fiel for programs that combine C-code, SQLite, and TCL. Use this script to construct the sqlite3_analyzer program. check-in: 298a3fdd user: drh tags: trunk | |
| 16:19 | Move a bunch of unrelated test code out of tclsqlite.c and into test_*.c files. There is still some test code in tclsqlite.c, but the amount is greatly reduced. check-in: a9c4bc88 user: drh tags: trunk | |
| 16:01 | The db_use_legacy_prepare command no longer exists. Use the undocumented -use-legacy-prepare option to DB version instead. Closed-Leaf check-in: ea2fa9ab user: drh tags: tclsqlite-cleanup | |
| 15:56 | When compiling with SQLITE_TEST, extra options are available on the "DB version" command for controlling the internal state of the SqliteDb object, for testing purposes. check-in: bf86478d user: drh tags: tclsqlite-cleanup | |
| 15:06 | Move some test logic out of tclsqlite.c and into auxiliary test_*.c files. This is a work in progress. check-in: 95b7687f user: drh tags: tclsqlite-cleanup | |
|
2017-10-12
| ||
| 20:37 | Add the sqlite_dbpage virtual table (enabled using SQLITE_ENABLE_DBPAGE_VTAB). Make that virtual table and dbstat available to the command-line shell. check-in: eaeeb09d user: drh tags: trunk | |
| 19:50 | Create the new ext/repair folder and move checkfreelist.c there. Remove checkfreelist.c from the command-line shell (undoing check-in [48418f2e]). Closed-Leaf check-in: dfdebd12 user: drh tags: dbpage | |
| 13:47 | The src/shell.c file is now generated from src/shell.c.in, so remove shell.c from version control and update the makefiles to build it automatically. check-in: 36acc0a9 user: drh tags: trunk | |
| 13:21 | Merge fixes from the 3.21 branch. check-in: 29292169 user: drh tags: trunk | |
| 11:33 | Fix a potential crash that may follow an OOM or other system error in the shell tool. check-in: c36761e1 user: dan tags: trunk | |
| 11:13 | Update some test cases to work with SQLITE_OMIT_VIRTUALTABLE and DEFAULT_AUTOVACUUM builds. check-in: 4b68f424 user: dan tags: trunk | |
| 10:28 | Make sure the tableColumnList() routine of the command-line shell does not cause a null-pointer dereference in an error condition. check-in: 5d0ceb8d user: drh tags: branch-3.21 | |
| 01:24 | Merge fixes from the 3.21 branch. check-in: 18d4654f user: drh tags: dbpage | |
| 01:19 | Fix a typo in a numeric constant in an assert() - a bug that has been present in the code since check-in [79e22b95038] on 2010-03-30. check-in: f0a2724f user: drh tags: branch-3.21 | |
|
2017-10-11
| ||
| 20:27 | Add test file mmapwarm.test. With tests for the sqlite3_mmap_warm() extension. check-in: 5c4980ef user: dan tags: trunk | |
| 18:26 | Add the checkfreelist extension to the command-line shell. check-in: 48418f2e user: drh tags: dbpage | |
| 18:21 | Check that the leaf count on each freelist trunk page is in range as part of checkfreelist processing. check-in: 4e894062 user: dan tags: dbpage | |
| 18:00 | Add new extension "checkfreelist", which uses sqlite_dbpage to check that there are no invalid entries on the database free-list. check-in: 21930ef5 user: dan tags: dbpage | |
| 17:51 | Convert the implementation of the ".dbstat" dot-command of the command-line shell to use the sqlite_dbpage table. check-in: 497409e1 user: drh tags: dbpage | |
| 17:50 | Make JSON1 defines consistent in the makefiles for MSVC. check-in: 31eee0e4 user: mistachkin tags: branch-3.21 | |
| 17:25 | Enable JSON by default in the Windows command-line shell sqlite3.exe. check-in: 79c96121 user: drh tags: branch-3.21 | |
| 17:13 | Enable sqlite_dbpage and dbstat virtual tables in the shell, by default. check-in: 01bf856c user: drh tags: dbpage | |
| 15:02 | Get writes working on the sqlite_dbpage virtual table. Add a few test cases. check-in: a8b264d8 user: drh tags: dbpage | |
| 13:48 | Initial implementation of the "sqlite_dbpage" virtual table. Currently it is read-only and has a place-holder xBestIndex. check-in: c2c1d656 user: drh tags: dbpage | |
| 12:20 | In the speed-check.sh test script, allow an additional test-name argument which becomes the comparison baseline, in place of "trunk". check-in: 0245adff user: drh tags: trunk | |
| 11:12 | Create a branch for the 3.21.0 release. Development continues on trunk. check-in: 0f160a8a user: drh tags: branch-3.21 | |
|
2017-10-10
| ||
| 13:37 | DROP TABLE now works for WITHOUT ROWID tables and the SQLITE_OMIT_AUTOVACUUM compile-time option. Fix for ticket [e651b1341861d6] check-in: b8c1b5a5 user: drh tags: trunk | |
|
2017-10-08
| ||
| 02:22 | Fix harmless compiler warnings in FTS5 seen with MSVC. check-in: 5594a121 user: mistachkin tags: trunk | |
|
2017-10-07
| ||
| 23:58 | Fix harmless compiler warning seen with MSVC. check-in: 39d920d1 user: mistachkin tags: trunk | |
| 23:35 | Revise variable declaration moved in the previous check-in so sqlite3VdbeReset() is consistent with sqlite3VdbeRewind(). check-in: 63d1b425 user: mistachkin tags: trunk | |
| 23:31 | Fix C99-style variable declaration issue seen with older versions of MSVC. check-in: 14b181e8 user: mistachkin tags: trunk | |
|
2017-10-06
| ||
| 18:00 | Add tests for the example fts3 "rank" function that appears in the documentation. check-in: 702b137a user: dan tags: trunk | |
|
2017-10-05
| ||
| 20:57 | Fix compiler warnings that come up with SQLITE_OMIT_WAL. check-in: 8ca0fa8d user: drh tags: trunk | |
| 20:02 | Fix a problem building with SQLITE_OMIT_WAL defined. check-in: 373b0ace user: dan tags: trunk | |
| 19:12 | Fix the command-line shell so that the ".schema --indent" command does a better job of dealing with \r\n in the middle of a CREATE statement in the schema. check-in: 4258fb57 user: drh tags: trunk | |
| 11:29 | Disable the delta checksum verification in RBU by default. Reenable it using -DRBU_ENABLE_DELTA_CKSUM, if desired. check-in: d22c99b6 user: drh tags: trunk | |
|
2017-10-04
| ||
| 18:26 | Updates to requirements marks. check-in: 40964a4e user: drh tags: trunk | |
| 17:05 | Update the speedtest1 program so that it prints the output of "PRAGMA compile_options" if the -stats option is specified. check-in: 7c69f8f1 user: dan tags: trunk | |
| 16:35 | Fix typos in session extension header comments. No changes to code. check-in: 182ec9d6 user: mistachkin tags: trunk | |
| 14:13 | New test cases for ticket [b899b6042f97f5] derived from a bug report on the mailing list from Wout Mertens. check-in: ef94ea06 user: drh tags: trunk | |
| 12:08 | Amend recent changes to busy.test to avoid failing with SQLITE_ENABLE_STAT4 builds. check-in: 9ff49441 user: dan tags: trunk | |
| 12:06 | Turn restriction 20 on the query flattener into an assert since the situation restricted can no longer occur because of the more aggressive use of co-routines. check-in: 4464f40c user: drh tags: trunk | |
| 10:39 | Add tests to verify that the busy-handler is invoked correctly when processing "PRAGMA optimize" and ANALYZE commands. check-in: fb83c3d8 user: dan tags: trunk | |
| 05:59 | Remove a redundant restriction from the query flattener. check-in: 66629b2a user: drh tags: trunk | |
| 02:30 | Fix a minor typo in the query flattener header comment. No code changes. check-in: d050dc60 user: drh tags: trunk | |
|
2017-10-03
| ||
| 19:53 | Simplify the computation of types on columns of a view. check-in: 772b0db1 user: drh tags: trunk | |
| 18:35 | Do not enable SELECT tracing with -DSQLITE_DEBUG. Require the -DSQLITE_ENABLE_SELECTTRACE compile-time option to enable SELECT tracing. check-in: f5c39583 user: drh tags: trunk | |
| 17:29 | Add some OK_IF_ALWAYS_TRUE() marks on optimization branches in select.c. check-in: 1dd82808 user: drh tags: trunk | |
| 17:17 | Remove an unused variable from sqlite3Insert() and fix harmless compiler warnings associated with -DSQLITE_MUTATION_TEST. check-in: 7be760e9 user: drh tags: trunk | |
| 16:57 | Fix the sqlite3_column_decltype() interface to return the correct datatype when the value comes through a CTE. check-in: 966438bd user: drh tags: trunk | |
| 14:24 | The simplification to sqlite3SelectExpand() in last night's [3a4ffb21] check-in was not completely correct. This adjustment is needed for correct OOM handling in some configurations. check-in: c5ad5e16 user: drh tags: trunk | |
| 03:01 | Do not compute column and row size estimates for the transient Table objects associated with the result set of a SELECT statement, since those estimates are never used for anything constructive. check-in: e4342fd4 user: drh tags: trunk | |
|
2017-10-02
| ||
| 23:50 | Mark a single branch within sqlite3SelectExpand() as an optimization. check-in: 3a4ffb21 user: drh tags: trunk | |
| 23:30 | Simplification to sqlite3SelectPrep() for improved testability. check-in: 5bf2ccb9 user: drh tags: trunk | |
| 21:29 | Add the OK_IF_ALWAYS_TRUE() and OK_IF_ALWAYS_FALSE() macros for marking conditionals that improve performance but do not change the outcome. check-in: 6035c9b2 user: drh tags: trunk | |
| 13:20 | Avoid using lookaside memory for persistent virtual table structures. check-in: d815f255 user: drh tags: trunk | |
| 02:52 | The query planner now always prefers to implement a FROM-clause subquery using a co-routine rather than flattening the subquery into the outer query. check-in: c9104b59 user: drh tags: trunk | |
| 02:32 | Improvements to a comment in lempar.c. No code changes. check-in: 8000d230 user: drh tags: trunk | |
|
2017-09-30
| ||
| 11:47 | More details in the header comment of pushDownWhereTerms(). No changes to code. Closed-Leaf check-in: 92848623 user: drh tags: prefer-coroutine-sort-subquery | |
| 10:50 | Make sure the SQLITE_Stat34 optimization switch is always 0x800, a value which is hard-coded in the TH3 test suite. check-in: 6aed4ea3 user: drh tags: prefer-coroutine-sort-subquery | |
| 01:25 | Fix unreachable conditionals and revise a testcase that was made obsolete by the changes on this branch. check-in: 71f0adf7 user: drh tags: prefer-coroutine-sort-subquery | |
|
2017-09-29
| ||
| 22:13 | Always render a subquery that is not part of a join as a co-routine. check-in: 6b1651d7 user: drh tags: prefer-coroutine-sort-subquery | |
| 16:08 | Merge the query flattener comment improvements from trunk. check-in: f62cd4d9 user: drh tags: prefer-coroutine-sort-subquery | |
| 16:07 | Clean up the comments on the query flattener to more clearly and accurately express the conditions under which the flattener is able to run. check-in: 0840f9f8 user: drh tags: trunk | |
| 14:31 | Merge changes from trunk. check-in: 06f432fb user: drh tags: prefer-coroutine-sort-subquery | |
| 12:44 | Make sure the 6th parameter to the authorizer callback for view subqueries has the correct view name. check-in: 2a45bbc9 user: drh tags: trunk | |
| 12:12 | Better names for subqueries in EXPLAIN comments. check-in: 04ef40a8 user: drh tags: trunk | |
|
2017-09-28
| ||
| 20:06 | Do not flatten subqueries that contain an ORDER BY or GROUP BY clause and can be implemented using a co-routine. check-in: 042d655d user: drh tags: prefer-coroutine-sort-subquery | |
| 17:29 | Remove the (undocumented) query-planner control that prevents a "SELECT ALL" subquery in FROM clause from being implemented as a co-routine. This control was added by [a29e117d7ec], where it was called a "stop-gap". check-in: ff2f5a31 user: drh tags: trunk | |
| 16:56 | Fix over-length source code lines in select.c. No logic changes. check-in: fd3267ef user: drh tags: trunk | |
| 13:47 | Fix an issue introduced by check-in [4cd2a9672c59] (2017-03-03) that could allow a negative value in the 3rd parameter to memmove() when defragmentPage() is called on a btree page with a corrupted freeblock list. The corruption is now detected early and results in an SQLITE_CORRUPT return before the memmove() is reached. check-in: 5b9ae693 user: drh tags: trunk | |
| 01:58 | Add new routines to simplify dealing with collating sequences in expressions: sqlite3ExprNNCollSeq() and sqlite3ExprCollSeqMatch(). check-in: 490e488e user: drh tags: trunk | |
| 01:09 | Indexes on expressions with a COLLATE clause are able to satisfy an ORDER BY with the same COLLATE clause. check-in: 04130018 user: drh tags: trunk | |
| 00:01 | In two places, change the magic number -1 to its proper symbol XN_ROWID. check-in: 80277d2f user: drh tags: trunk | |
|
2017-09-27
| ||
| 16:51 | Disable tests for the LIKE optimization when ICU is enabled, since the LIKE optimization only works for the built-in LIKE operator and ICU overrides the built-in. check-in: f5ef2e1b user: drh tags: trunk | |
|
2017-09-25
| ||
| 09:37 | Add an extra snapshot related test case. check-in: 24a95e14 user: dan tags: trunk | |
|
2017-09-22
| ||
| 16:23 | Use the updated Win32 VFS semantics for winOpen from check-in [5d03c738e9] for WinRT, et al, as well. check-in: 2c03d8b8 user: mistachkin tags: trunk | |
| 12:52 | Partial backout of check-in [e0af9a904076]. It turns out we do need some extra space at the end of the record blob as an overrun area to use when decoding a maliciously malformed record. check-in: 403b88a8 user: drh tags: trunk | |
| 00:24 | Update the configure script so that it looks for tclsh8.7 ahead of tclsh8.6. check-in: 0a12915b user: drh tags: trunk | |
|
2017-09-21
| ||
| 20:43 | In the Windows VFS, when trying to open a database file read/write, if it fails check to see if the file exists and is read-only and immediately fall back to a read-only open attempt, rather than running the AV retry loop. check-in: 5d03c738 user: drh tags: trunk | |
| 20:03 | In the Windows VFS, do not emit an SQLITE_CANTOPEN error log message when falling back from SQLITE_OPEN_READWRITE to SQLITE_OPEN_READONLY. Wait until the open fails completely. check-in: fa3f5bcc user: drh tags: trunk | |
| 19:08 | Fix harmless UB in the ICU extension. check-in: 68e9a840 user: drh tags: trunk | |
| 13:11 | Fix a potential use of an uninitialized pointer in RTree following an OOM error. check-in: fd4ec0cd user: drh tags: trunk | |
| 10:24 | Fix a bug in tool/mksourceid.c: The mksourceid.c program was incorrectly including the "# Remove this line" line of the Fossil-generated "manifest" file in the SHA3 hash. That means that all SQLITE_SOURCE_IDs for trunk versions going back to check-in [30966d56] (2017-08-22) are incorrect. check-in: 65765222 user: drh tags: trunk | |
| 01:04 | Revert one performance improvement changes from check-in [3b3e32d4cd07] as it was causing a reference to an uninitialized value. check-in: f8b1c64d user: drh tags: trunk | |
| 00:49 | Fix the rendering of the P4_INTARRAY argument to the OP_IntegrityCk opcode in the output of EXPLAIN. check-in: adc12c83 user: drh tags: trunk | |
|
2017-09-20
| ||
| 18:47 | Size and performance optimization on sqlite3VdbeMemGrow(). check-in: 4b3f7eac user: drh tags: trunk | |
| 18:07 | The BLOB returned by sqlite3VdbeMemFromBtree() does not need to be zero-terminated. check-in: e0af9a90 user: drh tags: trunk | |
| 17:49 | Small size and performance optimization in the bytecode engine. check-in: 3b3e32d4 user: drh tags: trunk | |
| 10:47 | Improved resolution of large integer values in "CAST(x AS NUMERIC)". check-in: 7f2bd4ff user: drh tags: trunk | |
| 09:09 | Updates to the "lemon.html" document received from Andy Goth. check-in: 5b2002f3 user: drh tags: trunk | |
|
2017-09-18
| ||
| 18:17 | Add the sqlite3_mmap_warm() function as an extension in the ext/misc/mmapwarm.c source file. check-in: 1b2de414 user: drh tags: trunk | |
| 18:08 | Fix a typo in the MSVC makefile. Closed-Leaf check-in: 3235835b user: drh tags: mmap-warm | |
| 16:28 | Add extension "mmapwarm.c". Provides function sqlite3_mmap_warm(), used to "warm up" the memory mapping used by SQLite in mmap mode to access db file content. check-in: d4a30b91 user: dan tags: mmap-warm | |
| 13:16 | Minor simplification of error message generation during compound query code generation. check-in: a9447193 user: drh tags: trunk | |
| 09:40 | The out-of-bounds read on recovery fix of check-in [378afa16381a222a] caused problems for some corner-case error conditions. This alternative fix appears to work better. check-in: 74f399d8 user: drh tags: trunk | |
| 00:18 | Fix the CSV virtual table extension so that it works when the default character is unsigned. check-in: 42f07775 user: drh tags: trunk | |