Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins using file test/date.test version 9b73bbeb1b
2024-09-18
| ||
18:04 | Improvements to the scope of valueFromFunction(). (Leaf check-in: b021399a6e user: drh tags: branch-3.28) | |
2024-06-07
| ||
00:20 | Allow the query planner access to the argument of LIMIT even if that argument is a bound parameter. (check-in: 148d505ca0 user: drh tags: branch-3.28) | |
2024-06-06
| ||
16:06 | Better optimize queries that use parameters in the LIMIT clause. (Closed-Leaf check-in: b44f267671 user: drh tags: branch-3.28-var-in-limit) | |
2024-04-02
| ||
18:48 | Fix typos in comments. Provided ".wheretrace" debugging output for the interstage heuristic module. Do omit automatic index loops in the interstage heuristic. (check-in: 357d9513d2 user: drh tags: branch-3.28) | |
18:31 | Fix table-valued functions so that they will work as the right table in a LEFT JOIN. Ticket [2ae0c599b735d59e] (check-in: 1f97086d62 user: drh tags: branch-3.28) | |
11:54 | Add a heuristic in between the two solver() passes of the query planner that tries to prevent a very slow query plan in cases where the output row count estimate is imprecise. (check-in: 74b247d958 user: drh tags: branch-3.28) | |
2023-11-29
| ||
16:26 | Fix a duplicate assert() caused by the second cherrypick in the previous check-in. (check-in: f10d4fc4a8 user: drh tags: branch-3.28) | |
16:07 | Remove Window objects from the corresponding Select.pWin list when they are deleted, as they are, for example, when the ORDER BY clause is optimized out. (check-in: f9c6e6a710 user: drh tags: branch-3.28) | |
2023-10-19
| ||
21:05 | Ensure that when an ephemeral cursor is reopened with a second invocation of to OP_OpenEphemeral, the sequence counter is reset and the cache marked as stale. Fix for [9cdc5c46]. (check-in: d4bfa8d21a user: drh tags: branch-3.28) | |
2023-09-15
| ||
20:04 | Drop support for the view-scan optimization as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subsqueries by a factor of 8. (check-in: 796a65fa61 user: drh tags: branch-3.28) | |
2023-02-26
| ||
11:52 | In the omit-unused-subquery-columns optimization, be sure to remove the EP_Skip and EP_Unlikely flags from the result set expressions that get nulled-out. dbsqlfuzz bf1d3ed6e0e0dd8766027797d43db40c776d2b15. Also fix an incorrect ".selecttrace" code block. (check-in: 83a7f13edb user: drh tags: branch-3.28) | |
2023-02-16
| ||
21:01 | Fix an #ifdef that uses a different macro name from the main branch. (check-in: ad6ac5d3e8 user: drh tags: branch-3.28) | |
19:04 | Back-port omit-unused-subquery-column enhancements into the 3.28 branch. (check-in: 57a4e91f43 user: drh tags: branch-3.28) | |
14:29 | Do not compute result columns of subqueries that are never used. Make those columns NULL instead. This optimization potentially resolves the enhancement request described by [ticket baa5bb76c35a124c]. (check-in: 0163b697dd user: drh tags: branch-3.28) | |
01:29 | Do not compute unused result columns of subqueries. This optimization will potentially resolve the performance optimization request of [ticket baa5bb76c35a124c]. (Closed-Leaf check-in: 0c21b6a5f8 user: drh tags: branch-3.26) | |
01:21 | Update test cases so that they work with TCL 8.7 and later. (check-in: e9b762de0e user: drh tags: branch-3.26) | |
2023-02-15
| ||
13:00 | Update the configure script so that it contains the correct version number. (check-in: a7cbf30808 user: drh tags: branch-3.26) | |
2022-10-24
| ||
13:50 | Improve the ability of the query planner to recognize covering indexes even on tables with more than 63 columns and where the index is over columns beyond the 63rd column. (check-in: 3d1992de47 user: drh tags: branch-3.28) | |
2022-10-19
| ||
11:22 | If a query uses an index where one or more of the columns of the index is an expression and if the corresponding expression is used elsewhere in the query, then strive to read the value of the expression out of the index, rather than recomputing it. This is the "Indexed Expression Optimizations". (check-in: 3da1032878 user: drh tags: branch-3.28) | |
2022-09-01
| ||
10:41 | In the query planner, add a heuristic that will reduce the cost of a full table scan for a materialized view or subquery if the full scan is the outer-most loop. This is shown to speed up some queries. (check-in: e3754cc188 user: drh tags: branch-3.28) | |
2022-08-10
| ||
17:03 | Merge the branch-3.28a fixes into branch-3.28. (check-in: ba6bf33147 user: drh tags: branch-3.28) | |
2022-08-09
| ||
20:22 | Fix a rounding error caused by scalar->logarithm->scalar conversion when using stat4 data to estimate some range scans. (check-in: 68d86f2b20 user: drh tags: branch-3.28) | |
2022-02-11
| ||
13:40 | Upon .import column renaming, issue message saying so. Test this. (check-in: 8b6ca9304b user: larrybr tags: auto-column) | |
01:21 | CLI auto-column rename revamped after forum discussion. (check-in: 2da1f8e45e user: larrybr tags: auto-column) | |
2022-02-10
| ||
12:57 | Faster implementation of the date(), time(), and datetime() functions. (check-in: fa1b393bdb user: drh tags: trunk) | |
12:31 | Fix the test harness so that it builds without SQLITE_ENABLE_PREUPDATE_HOOK. Has been broken since [c006515ae6faff65]. (check-in: 4565f71129 user: drh tags: trunk) | |
03:21 | A CLI feature. auto .import (new table) columns. WIP (check-in: 7e3be36dfc user: larrybr tags: auto-column) | |
02:09 | Create new branch named "auto-column" (check-in: 066febe893 user: larrybr tags: auto-column) | |
01:01 | Fix a typo in documentation. No code changes. (check-in: e97c6ad4c9 user: drh tags: trunk) | |
2022-02-09
| ||
18:47 | When process first moves a database into WAL mode and then tries to run sqlite3_wal_checkpoint() without first performing a transaction, first try to run a synthesized transaction to get the Pager caught up before attemptingn the checkpoint. forum post fd0f19d229156939. (check-in: eee6de1967 user: drh tags: trunk) | |
18:42 | Fix a problem with using sqlite3_bind_value() with sqlite3_value objects obtained from sqlite3_preupdate_new() when an integer value is written to a column with real affinity. (check-in: c006515ae6 user: dan tags: trunk) | |
16:18 | Prototype implementation of IF EXISTS and IF NOT EXISTS clauses on the various forms of ALTER TALE. (Leaf check-in: 460abf93ac user: drh tags: alter-table-if-exists) | |
2022-02-08
| ||
15:14 | Writes to the subjournal should be all-or-nothing. Fix for dbsqlfuzz fe3c397fb90029313446c4e0f4a6cd0c81dd9621. (check-in: 22cc55e84f user: drh tags: trunk) | |
13:41 | Provide sqlite3_error_offset() data for some new errors. (check-in: 1269206db8 user: drh tags: trunk) | |
12:24 | comment-only change to sqlite3.h (check-in: f815cf4a5f user: larrybr tags: trunk) | |
12:13 | Do not show the error code number of CLI error messages unless the error is something other than 1 (SQLITE_ERROR). (check-in: b471601892 user: drh tags: trunk) | |
11:52 | Improved error message formatting in the shell. Distinguish between "Parse errors" and "Runtime errors". (check-in: ae3e322a02 user: drh tags: trunk) | |
2022-02-07
| ||
18:52 | Disable the sqlite3_error_offset() when the error occurs in a trigger or view or some other bit of text that is not part of the original statement. (check-in: 0e909e34fa user: drh tags: trunk) | |
01:09 | When create table/view fails due to name taken, say which took it. (check-in: 9a206e37fb user: larrybr tags: trunk) | |
2022-02-06
| ||
23:54 | Fix unreachable branches in the sqlite3_error_offset() logic. (check-in: 031381aea3 user: drh tags: trunk) | |
22:13 | The sqlite3_vtab_in() interface should return false for a vector IN constraint. (check-in: 245d0241c7 user: drh tags: trunk) | |
21:13 | With the new ALTER TABLE under PRAGMA writable_schema=ON processing, do not ignore non-parser errors such as OOMs. (check-in: 36653ccef6 user: drh tags: trunk) | |
14:30 | CLI extended parsing, new .parameter subcommands, and .x features fairly well tested (check-in: 9c664984fd user: larrybr tags: shell-tweaks) | |
11:51 | Faster computation of Expr.nHeight. (check-in: a7a5af327b user: drh tags: trunk) | |
11:26 | Record the error offset on INTEGER tokens. (check-in: 38e057a580 user: drh tags: trunk) | |
00:30 | Further improvements to localization of errors in input SQL. (check-in: fa34676042 user: drh tags: trunk) | |
00:07 | Sync with trunk. More shell9.test tests to come. (check-in: 2e72dc4621 user: larrybr tags: shell-tweaks) | |
2022-02-05
| ||
23:45 | CLI cleanup, mode push/pop, parameter list beautification (check-in: 53d4582a0e user: larrybr tags: shell-tweaks) | |
23:11 | Enhance sqlite3_error_offset() to report the position of unresolved identifiers. (check-in: 5b8d257790 user: drh tags: trunk) | |
21:49 | Record the position of many identifiers in the parse using the new Expr.w.iOfst field. This is done with the idea of providing offset results for sqlite3_error_offset() for a more kinds of errors, though that part is not yet implemented. (check-in: 32a3a53b62 user: drh tags: trunk) | |
15:26 | Fix CLI Windows build, refine its help, re-org ShellState (check-in: 991a06a480 user: larrybr tags: shell-tweaks) | |
13:27 | Update stale evidence marks on sqlite3_vtab_rhs_value() test cases. (check-in: 46744b83d5 user: drh tags: trunk) | |
12:39 | When PRAGMA writable_schema=ON, allow ALTER TABLE to proceed even if there are entries in the sqlite_schema table that do not parse. (check-in: fc4c82e569 user: drh tags: trunk) | |
12:05 | Fix a NULL pointer dereference that can occur after OOM. Problem introduced by check-in [197cbabf1767d060]. (Closed-Leaf check-in: d4e6b9f0f7 user: drh tags: relaxed-alter-table) | |
11:13 | Fix documentation typo. (check-in: 1a7d8bb5ea user: drh tags: trunk) | |
01:01 | Typo fixes in documentation. (check-in: 1ec747d1c3 user: drh tags: trunk) | |
2022-02-04
| ||
21:49 | CLI .param save/load done; many other small refinements (check-in: 6d415ac2c1 user: larrybr tags: shell-tweaks) | |
20:16 | Test case for permissive ALTER TABLE RENAME when writable_schema=ON. (check-in: 7ee44f66c8 user: drh tags: relaxed-alter-table) | |
20:07 | One more case of disabling errors for ALTER TABLE RENAME when writable_schema=ON. (check-in: c52d0dd8f4 user: drh tags: relaxed-alter-table) | |
19:13 | Add a compile-time option to include vt02.c in fuzzcheck. (check-in: c404c8c726 user: drh tags: trunk) | |
18:12 | Merge trunk enhancements into the reuse-schema branch. (check-in: 5744e1020b user: drh tags: reuse-schema) | |
18:02 | Merge recent trunk changes into the begin-concurrent-pnu-wal2 branch. (check-in: cb045aba7c user: drh tags: begin-concurrent-pnu-wal2) | |
17:52 | Merge trunk enhancements into the wal2 branch. (check-in: d2de02f372 user: drh tags: wal2) | |
17:51 | Merge all recent trunk enhancements into the begin-concurrent-report branch. (check-in: 1c88bcfff5 user: drh tags: begin-concurrent-report) | |
17:40 | Merge trunk enhancements into the begin-concurrent branch. (check-in: 85054a8691 user: drh tags: begin-concurrent) | |
16:43 | Allow ALTER TABLE RENAME COLUMN to proceed even if there are errors in the schema, as long as PRAGMA writable_schema=ON is active. (check-in: 197cbabf17 user: drh tags: relaxed-alter-table) | |
13:15 | Fix various harmless compiler warnings. (check-in: 70049342d5 user: drh tags: trunk) | |
13:05 | For the MULTI-INDEX-OR optimization, when pushing down WHERE clause terms from the main query into the various OR-term subqueries, do not push down slices of a vector comparison, since the right-hand operand of the comparison might have only been initialized in a different OR branch that was not taken. dbsqlfuzz 80a9fade844b4fb43564efc972bcb2c68270f5d1. (check-in: 9f67ad00cd user: drh tags: trunk) | |
09:39 | Fix .param edit unable to edit script vars (bad assert) (check-in: 62d212d0da user: larrybr tags: shell-tweaks) | |
2022-02-03
| ||
21:07 | Sync to trunk. Shell tests pass. (check-in: 79275b81dc user: larrybr tags: shell-tweaks) | |
20:57 | Scripting and .parameter enhancements most in; all in working (check-in: a1581118b0 user: larrybr tags: shell-tweaks) | |
18:14 | Minor typo fix in comment. No code changes. (check-in: f9b763042c user: drh tags: trunk) | |
14:37 | Do not allow the vdbe-compress.tcl script to generate structures named "do" or "if". (check-in: e35ab16dd0 user: drh tags: trunk) | |
14:19 | Prohibit schema changes within xBestIndex callbacks. (check-in: bb0f056b3f user: drh tags: trunk) | |
2022-02-02
| ||
21:06 | Improvement to the sqlite3_vtab_in_first() documentation. (check-in: 403e7ac900 user: drh tags: trunk) | |
19:51 | Add the sqlite3_vtab_in() interface that allows virtual tables to process IN constraints all at once, rather than one value at a time. (check-in: 52559af093 user: drh tags: trunk) | |
19:30 | Additional test cases. (Closed-Leaf check-in: 733d81c3a6 user: drh tags: batch-in-operator) | |
19:15 | Test cases for sqlite3_vtab_in() and sqlite3_vtab_distinct(). (check-in: 21afb81d0a user: drh tags: batch-in-operator) | |
18:47 | Improved documentation for sqlite3_vtab_in(). No code changes. (check-in: c99df4ab5d user: drh tags: batch-in-operator) | |
16:24 | Relax the restriction that the RHS of the IN operator must be a list in order for sqlite3_vtab_in() to work. Change an unreachable branch into an assert(). (check-in: 3bf2153440 user: drh tags: batch-in-operator) | |
15:10 | Be sure that sqlite3_vtab_in_first() and _next() set the correct encoding. (check-in: 04edf36ee8 user: drh tags: batch-in-operator) | |
14:36 | Refactor sqlite3_vtab_in() to make use of the existing sqlite3_value_pointer() mechanism for passing the list of IN operator RHS values into xFilter, for improved memory safety. (check-in: 8965929be2 user: drh tags: batch-in-operator) | |
11:37 | Fix a harmless code indentation issue. (check-in: 41d8d26e48 user: drh tags: trunk) | |
2022-02-01
| ||
21:59 | Tweaks to the sqlite3_vtab_in() interface. (check-in: 75040183b8 user: drh tags: batch-in-operator) | |
16:30 | Index in 2nd argument to sqlite3_vtab_in() should be on the aConstraint[] array, not the internal array of all constraints. (check-in: 5acf90a931 user: drh tags: batch-in-operator) | |
15:08 | Take CLI's wordwrap from trunk (check-in: 768c70a926 user: larrybr tags: shell-tweaks) | |
14:58 | Add new interfaces to enable virtual table to process IN operator constraints all at once, rather than one element at a time. (check-in: eb84b80e1f user: drh tags: batch-in-operator) | |
13:17 | CLI: Take extra care to not split a multi-byte unicode character when doing wordwrap. (check-in: 00b1b7020a user: drh tags: trunk) | |
12:28 | CLI: Add the --ww option as an alias for --wordwrap. Improve the wordwrap algorithm so that it breaks at punctuation if it cannot find space. Always wordwrap with --ww even if there is a .width setting for the column. (check-in: 1b528e31f8 user: drh tags: trunk) | |
02:50 | Add "--wordwrap on/off" option for CLI columnar modes, qwbox shortcut (check-in: 10dbc27870 user: larrybr tags: trunk) | |
00:00 | CLI: In ".mode column" output, if any row contains a newline or wraps, then put a single blank line in between each pair of rows to provide additional visual separately. (check-in: fd42f4c304 user: drh tags: trunk) | |
2022-01-31
| ||
22:14 | CLI: for columnar output modes, make sure the header is not too big. Also, improve the help text. (check-in: 070fae3a09 user: drh tags: trunk) | |
20:39 | CLI: Fix a problem with tabs in the new qbox mode. (check-in: ca96ab3ef7 user: drh tags: trunk) | |
19:52 | Sync to trunk (check-in: f51a17b627 user: larrybr tags: shell-tweaks) | |
19:23 | Cleanup dot-command handling, make multi-line work, honor exit requests from more contexts (check-in: 5cf66e8907 user: larrybr tags: shell-tweaks) | |
16:29 | Fix harmless compiler warnings in MSVC. (check-in: 3ec6141c41 user: drh tags: trunk) | |
15:59 | Do not attempt to limit the number of columns used in a table to a prefix if the table will be used to construct an automatic index or bloom filter. dbsqlfuzz 787d9bd73164c6f0c85469e2e48b2aff19af6938. (check-in: f8766231d2 user: drh tags: trunk) | |
14:14 | CLI: Enhancements to columnar output modes. (See [forum/forumpost/5b53cd851f66441f9|forum post 5b53cd851] for discussion.) New output mode "qbox". New output options "--quote" and "--wrap N". (check-in: 539cef5214 user: drh tags: trunk) | |
12:29 | Fix an obscure problem in sqlite3_backup_init() caused by [6a45d8fe8bfbc11a|check-in 6a45d8fe8bfbc11a]. See forum post 8b39fbf3e7 for the original bug report. (check-in: 639fc7633b user: drh tags: trunk) | |
10:55 | CLI: Fix the new ".mode box" output so that it works with unicode characters. (check-in: 454af48724 user: drh tags: trunk) | |
2022-01-30
| ||
21:09 | CLI: For columnar modes ("box", "column", "table", "markdown") the ".width" is now both the minimum and maximum width of the column. Text that spans multiple lines or that contains tabs is properly formatted. If any part of the output contains multi-line text, then extra separators are provided between each row. (check-in: c10ed4a7fe user: drh tags: trunk) | |
11:44 | Always enable all JSON tests, now that JSON is included by default. (check-in: 8c9f350182 user: drh tags: trunk) | |
11:42 | Remove a faulty NEVER(). Fix for dbsqlfuzz 4678cf825d27f87c9b8343720121e12cf944b71a (check-in: d4e402458d user: drh tags: trunk) | |
01:35 | Sync with trunk (check-in: 59693d3e73 user: larrybr tags: shell-tweaks) | |
01:21 | Enhance shell parser for multi-line dot-commands (check-in: 5ed528e27b user: larrybr tags: shell-tweaks) | |
2022-01-29
| ||
21:41 | Documentation enhancements. No code changes. (check-in: 312642d982 user: drh tags: trunk) | |
2022-01-28
| ||
23:44 | Add the SQLITE_INDEX_CONSTRAINT_LIMIT and SQLITE_INDEX_CONSTRAINT_OFFSET constraints to the sqlite3_index_info for the xBestIndex method of virtual tables. (check-in: 1e227ad9f4 user: drh tags: trunk) | |
23:19 | Add a NEVER() on an unreachable branch. (Closed-Leaf check-in: 388926254b user: drh tags: vtab-limit-offset) | |
21:39 | When nesting Parse objects, make sure the new one has nErr set if there has been an OOM error. (check-in: ae088cbc96 user: drh tags: trunk) | |
19:53 | Include hidden columns of table valued functions that are constrained by the function arguments in the colUsed bitmask. (check-in: 8f8cab0d0e user: drh tags: vtab-limit-offset) | |
18:43 | Remove a NEVER() that has become reachable now that we have the sqlite3_vtab_rhs_value() interface. (check-in: c4c30df7cd user: drh tags: vtab-limit-offset) | |
13:18 | Enable SQLITE_INDEX_CONSTRAINT_LIMIT/OFFSET even if there are vector comparison operators in the WHERE clause. Also: Do not enable sqlite3_vtab_rhs_value() for LIMIT/OFFSET if the value is negative, as this violates an invariant on Expr.u.iValue. (check-in: 140480b3ec user: drh tags: vtab-limit-offset) | |
2022-01-27
| ||
21:18 | Query planner always honors the aConstraintUsage[].omit flag for the SQLITE_INDEX_CONSTRAINT_OFFSET constraint. (check-in: 38c5151eb8 user: drh tags: vtab-limit-offset) | |
18:45 | Make LIMIT and OFFSET values available to sqlite3_vtab_rhs_value(). (check-in: b2d37c086c user: drh tags: vtab-limit-offset) | |
16:14 | Give the virtual table xBestIndex method access to (some) OFFSET and LIMIT clauses. (check-in: 74fa5757ee user: drh tags: vtab-limit-offset) | |
13:52 | Enforce the restriction that 'unixepoch' only works as the first modifier after the time-value. This has been documented since 2004, but has never actually been enforced before. Also add new test cases for date/time functions with evidence marks. (check-in: 64fa9e8c87 user: drh tags: trunk) | |
2022-01-25
| ||
16:28 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 6e4154d414 user: drh tags: reuse-schema) | |
16:05 | Merge the latest trunk changes into begin-concurrent-pnu-wal2 (check-in: 3d949775e3 user: drh tags: begin-concurrent-pnu-wal2) | |
15:57 | Merge the latest trunk changes into the wal2 branch. (check-in: 84f737abd1 user: drh tags: wal2) | |
15:48 | Merge the latest trunk enhancements into the begin-concurrent-report branch. (check-in: 42e6d842ab user: drh tags: begin-concurrent-report) | |
15:20 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: dae81f45d2 user: drh tags: begin-concurrent) | |
00:03 | Minor adjustment to error handling in sqlite3FinishCoding(). (check-in: a8db69411b user: drh tags: trunk) | |
2022-01-24
| ||
21:47 | Remove an unnecessary assert() that is sometimes not true following an OOM. (check-in: e9361d72f3 user: drh tags: trunk) | |
20:20 | New dbsqlfuzz cases added to test/fuzzdata8.db. (check-in: d1fbf63330 user: drh tags: trunk) | |
20:16 | One of the ALWAYS() macros in the previous check-in could sometimes be false, following an OOM. Remove it. Problem found by dbsqlfuzz. (check-in: 11df9187da user: drh tags: trunk) | |
19:38 | Add ALWAYS() macros. Change some existing ALWAYS() into assert(). Other code simplifications. (check-in: 4aa27b4fcd user: drh tags: trunk) | |
16:47 | Remove many redundant checks for sqlite3.mallocFailed now that any OOM should cause Parse.nErr to be non-zero. (check-in: 1f7fa46126 user: drh tags: trunk) | |
15:34 | Make it so that any Parse object is always linked into the database conenction while it is active. Hence, an OOM will cause Parse.nErr to be set. (check-in: 6a45d8fe8b user: drh tags: trunk) | |
14:01 | Fix testcase for CLI .read recursion. (check-in: 53d4404458 user: larrybr tags: trunk) | |
12:48 | Make sure the sqlite3OomFault() routine sets an error in the Parse object if there is a Parse object active and linked to the database connection. (check-in: ad7aace761 user: drh tags: trunk) | |
11:25 | Ensure that any error encountered while coding a trigger program is transfered to the main Parse structure before it is used with any other routine that might set the error code. (check-in: 4293656578 user: dan tags: trunk) | |
07:11 | Take CLI input redirect recursion limit from trunk (check-in: 5e70204415 user: larrybr tags: shell-tweaks) | |
06:36 | Limit CLI input redirect nesting (check-in: 7a07393175 user: larrybr tags: trunk) | |
04:21 | Add CLI .x command, make string redirection work (check-in: 2f2f1aaed6 user: larrybr tags: shell-tweaks) | |
00:22 | CLI prepared for reading string input (check-in: 073ded4d18 user: larrybr tags: shell-tweaks) | |
2022-01-23
| ||
20:54 | Factor out DB protection lift and restore in CLI (check-in: 4462ed8964 user: larrybr tags: shell-tweaks) | |
04:19 | Shell refinements, seeargs, booleans, undocumented commands (check-in: 8735caf13f user: larrybr tags: shell-tweaks) | |
02:53 | Create new branch named "shell-tweaks" (check-in: 3f13df296b user: larrybr tags: shell-tweaks) | |
2022-01-22
| ||
22:28 | Add support for the sqlite3_vtab_distinct() interface. Virtual table implementations can use this API to determine more detail about the ordering requirements needed by the query plan and perhaps reduce the amount of work required to compute a correct answer. This is an optimization opportunity for the virtual table implementation. The correct answer should still be obtained (though perhaps more slowly) even if sqlite3_vtab_distinct() is ignored. (check-in: e4caf1e393 user: drh tags: trunk) | |
20:45 | Bring sqlite3_vtab_distinct() up to spec so that it works as described in the documentation. (Closed-Leaf check-in: 4289edf3c5 user: drh tags: sqlite3_vtab_distinct) | |
19:19 | Iimproved documentation for sqlite3_vtab_distinct(). No changes to code. (check-in: 7af03f0294 user: drh tags: sqlite3_vtab_distinct) | |
02:52 | Omit the WhereLoopBuilder.pOrderBy field, which is no longer needed. (check-in: a13afc909c user: drh tags: sqlite3_vtab_distinct) | |
00:18 | An initial attempt to implement sqlite3_vtab_distinct(). (check-in: d571262d23 user: drh tags: sqlite3_vtab_distinct) | |
2022-01-21
| ||
19:26 | Update evidence marks for the latest changes to the documentation. (check-in: 19247e919f user: drh tags: trunk) | |
18:57 | Fix some of the new date/time function features to comply with the spec. Update requirement marks. (check-in: 2f5dc7a9ee user: drh tags: trunk) | |
16:47 | When computing a vector to be used as a key for an index lookup, do not check for NULL values and abort until after all key values have been computed, in case one of the later key values involves some initialization that is needed by a LEFT JOIN. Fix for the problem identified by Forum post ab95010d410a0a55. (Leaf check-in: 3bc8d16207 user: drh tags: branch-3.37) | |
16:41 | When computing a vector to be used as a key for an index lookup, do not check for NULL values and abort until after all key values have been computed, in case one of the later key values involves some initialization that is needed by a LEFT JOIN. Fix for the problem identified by Forum post ab95010d410a0a55. (check-in: 4db5217a28 user: drh tags: trunk) | |
01:00 | Add the sqlite3_vtab_rhs_value() interface, allowing the xBestIndex method of a virtual table to access known values on the right-hand side of constraint expressions. (check-in: e19a0b132a user: drh tags: trunk) | |
00:38 | Add requirements marks and tuning. (Closed-Leaf check-in: ac951490fd user: drh tags: sqlite3_vtab_rhs_value) | |
2022-01-20
| ||
19:00 | Test cases for sqlite3_vtab_rhs_value() based on the qpvtab extension. (check-in: 577d3d6655 user: drh tags: sqlite3_vtab_rhs_value) | |
18:27 | Enhancements to the qpvtab virtual table to make it more useful for testing and verification of virtual table interfaces. (check-in: 850efc4cf3 user: drh tags: sqlite3_vtab_rhs_value) | |
17:10 | Initial implementation of the sqlite3_vtab_rhs_value() interface and the qpvtab extension used for testing the virtual table interface. (check-in: 0873c76b9b user: drh tags: sqlite3_vtab_rhs_value) | |
14:51 | A better and more robust fix for the problem of reading a read-only WAL mode database with existing -wal and -shm files, replacing [f426874e005e3c23]. (check-in: 1266220a01 user: drh tags: branch-3.37) | |
14:40 | A better and more robust fix for the problem of reading a read-only WAL mode database with existing -wal and -shm files, replacing [f426874e005e3c23]. (check-in: 71bfd0b57a user: drh tags: trunk) | |
12:58 | Fix harmless scan-build warnings. (check-in: ab160e8bae user: drh tags: trunk) | |
12:36 | Fix the ability to read read-only WAL-mode database when -shm is present, ([00ec95fcd02bb415|check-in 00ec95fcd02bb415]) so that it works for the case of 64K page size. (check-in: 2cc15e2f29 user: drh tags: branch-3.37) | |
05:20 | A WIP checkin, progress toward what .help promises (Closed-Leaf check-in: 4688e6dff8 user: larrybr tags: script_command) | |
02:04 | Fix the ability to read read-only WAL-mode database when -shm is present, ([00ec95fcd02bb415|check-in 00ec95fcd02bb415]) so that it works for the case of 64K page size. (check-in: f426874e00 user: drh tags: trunk) | |
2022-01-19
| ||
21:11 | Initial help changes for .script (and enhanced .parameter) (check-in: a94ab403eb user: larrybr tags: script_command) | |
20:38 | Mistaken branch creation. (Closed-Leaf check-in: 03548c2574 user: larrybr tags: mistake) | |
18:31 | Fix a test result for alterauth2.test due to the recent fix to authorizer calls for ALTER TABLE DROP COLUMN. (check-in: e799a35f2b user: drh tags: trunk) | |
2022-01-18
| ||
16:16 | Fix ALTER TABLE DROP COLUMN so that it invokes the authorizer. Fix for forum post fd82b85947541dec. (check-in: aca6c61d79 user: drh tags: trunk) | |
2022-01-17
| ||
23:53 | Allow an "IntReal" value to count as a REAL when checking types for insertion into a generated column on a STRICT table. Forum post fa012c77796d9399. (check-in: b6fb223d90 user: drh tags: branch-3.37) | |
23:37 | Allow an "IntReal" value to count as a REAL when checking types for insertion into a generated column on a STRICT table. Forum post fa012c77796d9399. (check-in: 1ec44d55da user: drh tags: trunk) | |
20:01 | Merge the latest trunk changes into the reuse-schema branch. (check-in: 769ff85765 user: drh tags: reuse-schema) | |
19:46 | Merge the latest trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: 45fa7efecb user: drh tags: begin-concurrent-pnu-wal2) | |
19:36 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 82f031b41d user: drh tags: wal2) | |
19:24 | Bring the begin-concurrent-report branch up to date with all the latest trunk enhancements. (check-in: ef6fc89507 user: drh tags: begin-concurrent-report) | |
19:17 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: 02daae7a67 user: drh tags: begin-concurrent) | |
19:10 | Merge the begin-concurrent-pnuu branch into begin-concurrent. (check-in: 22fb505005 user: drh tags: begin-concurrent) | |
17:22 | .ar fixed and constituent line numbers off (until they are right) (check-in: ec363f81ce user: larrybr tags: cli_extension) | |
15:23 | Fix incorrect testcase() and assert() macros in json.c. They were not causing problems. The assert() was simply unreachable. The testcase() added an unreachable condition. (check-in: 5623497adc user: drh tags: trunk) | |
14:42 | Never allow the b-tree layers view of the number of pages in the database file exceed the actual number of pages in the database file, even when PRAGMA writeable_schema=ON. This helps with earlier detection of corruption, and prevents excess memory usage and CPU cycles in some integrity_check ops. (check-in: 0407c87937 user: drh tags: trunk) | |
03:53 | Merge from trunk, w/adapations. (.ar still broken) (check-in: e09a6dd7b9 user: larrybr tags: cli_extension) | |
03:25 | Bring .import --schema enhancement in. Refine mkshellc include logic. (check-in: e38f45cdc5 user: larrybr tags: cli_extension) | |
2022-01-16
| ||
19:11 | Fix test cases so that they all still work even with -DSQLITE_DQS=0. (check-in: 4883776669 user: drh tags: trunk) | |
15:15 | Fix ALTER TABLE so that it works even when compiled using -DSQLITE_DQS=0. Forum post 3c1a00b66fca81fe. (check-in: 092ad64faa user: drh tags: trunk) | |
2022-01-14
| ||
23:28 | Remove code from lemon.c that was made superfluous by [1b22b42e59793af1|check-in 1b22b42e59793af1] in late 2017. (check-in: 6d2f95a474 user: drh tags: trunk) | |
21:34 | Fix a NEVER() in the byte-code engine that can sometimes be true. Test case in TH3. (check-in: 7ac91b5339 user: drh tags: trunk) | |
16:29 | For .import schema, quote it as for other identifiers. (check-in: bff9153cee user: larrybr tags: trunk) | |
2022-01-13
| ||
21:22 | Add --schema S option to .import (check-in: 38d9dbca16 user: larrybr tags: trunk) | |
2022-01-12
| ||
20:31 | When the result of a subquery is to be stored in a register and that subquery has an ORDER BY clause and an OFFSET, NULL out the destination register before starting the ORDER BY so that the register will be set correctly even if the OFFSET is larger than the number of output rows. Fix for the problem reported in forum post 0ec80f12d02acb3f. (check-in: 9282bcde30 user: drh tags: trunk) | |
01:42 | Make tool/mctimec.tcl effect more regular and obvious (check-in: 02aaa10f34 user: larrybr tags: trunk) | |
00:52 | Fix mkctimec.tcl with the updated compile-time options for JSON. (check-in: 8ded3f5b00 user: drh tags: trunk) | |
00:28 | Fix harmless compiler warning seen with MSVC. (check-in: adebb9d747 user: mistachkin tags: trunk) | |
2022-01-11
| ||
23:28 | Merge the JSON interface into the core. Add -> and ->> operators for JSON that are compatible with by MySQL and PG. (check-in: 4cbb3e3efe user: drh tags: trunk) | |
22:06 | Remove vestigial traces of json_ntype(). (Closed-Leaf check-in: 8da07c8b09 user: drh tags: json-in-core) | |
18:01 | Fix the PG-compatible -> and ->> path parsing. (check-in: 22d5138315 user: drh tags: json-in-core) | |
2022-01-10
| ||
17:43 | Fix typo in the json-enhancements.md document. (check-in: feba24ef77 user: drh tags: json-in-core) | |
15:43 | Implement the new PG-compliant versions of the -> and ->> operators. (check-in: 39eff3b9bf user: drh tags: json-in-core) | |
13:55 | New proposal for -> and ->> operators. (check-in: 1108e12a22 user: drh tags: json-in-core) | |
2022-01-09
| ||
21:16 | Update the json-enhancements.md document to match the version in the json-in-core branch, as outside readers have linked to this branch. (Leaf check-in: 2027b3beb9 user: drh tags: json-enhancements) | |
20:51 | Typo fix in doc/json-enhancements.md. (check-in: c3b01d4964 user: drh tags: json-in-core) | |
20:42 | Update the doc/json-enhancements.md document to better explain the features of this branch. (check-in: b8ac938f41 user: drh tags: json-in-core) | |
19:44 | Do not enclude ENABLE_JSON1 in the compile-time options. (check-in: 8bf41bc5cb user: drh tags: json-in-core) | |
19:36 | Merge trunk enhancements into the json-in-core branch. (check-in: ea75577169 user: drh tags: json-in-core) | |
16:54 | Add a new built-in subtype() function. (check-in: a25f4ce255 user: drh tags: json-in-core) | |
2022-01-08
| ||
21:59 | mkshellc.tcl to convert #include to INCLUDE for in-tree includees (check-in: b1f3b317c0 user: larrybr tags: cli_extension) | |
21:50 | Add NEVER() macros to two branches that became unreachable due to [e199a851e316bd47]. (check-in: 71272caff5 user: drh tags: trunk) | |
21:00 | Add function format() as an alias for printf(), for compatibility with other systems. (check-in: 68bffc612c user: drh tags: trunk) | |