This Day In History For 2024-11-03
1 Year Ago (more context)
|
2023-11-03
| ||
| 18:45 | Back out the ALWAYS inserted late yesterday. The fuzzer discovered a counter-example. (check-in: 570635575c user: drh tags: trunk) | |
| 17:20 | Fix a case where adjacent tokens are handled incorrectly by the fts5 snippet() function. (check-in: 8f5e9c192f user: dan tags: trunk) | |
| 13:00 | Wrap more of the stmt API behind the JNI wrapper1 API. (check-in: 8fea23dc3a user: stephan tags: trunk) | |
| 12:09 | Enhance the JSONB lookup routine with logic to apply edits. The new logic is currently unused and hence untested but does not create any regressions. (check-in: b12110276f user: drh tags: jsonb) | |
| 11:53 | Bind the sqlite3_keyword_...() and sqlite3_compileoption_...() family of functions to the JNI wrapper1 API. (check-in: b27242414d user: stephan tags: trunk) | |
| 11:41 | Update the tool/srctree-check.tcl script so that it verifies that autoconf has been run following edits to VERSION. (check-in: 52ab3deba4 user: drh tags: trunk) | |
| 11:35 | Merge all the latest trunk fixes and enhancements into the jsonb branch. (check-in: b089bf4637 user: drh tags: jsonb) | |
| 10:15 | Update the version number to 3.45.0 to begin the next development cycle. (check-in: 15b618e92a user: drh tags: trunk) | |
2 Years Ago (more context)
|
2022-11-03
| ||
| 22:51 | Add experimental esm target to ext/wasm/GNUmakefile to tell emcc to generate sqlite3.mjs (ES6 module) instead of sqlite3.js. Related to discussion at ed4596cf8496a39b. (check-in: e55d8eba83 user: stephan tags: trunk) | |
| 22:14 | Experimentally use clang's C preprocessor to filter #ifdef's out of the generated sqlite3-api.js, the goal being to see if we can feasibly use cpp to include ES6 module-specific code in the main code base and conditionally filter it out. (check-in: 718a6d371e user: stephan tags: js-cpp) | |
| 21:21 | Globally replace '' with "" for empty JS strings to please C preprocessor. (check-in: e92e1f42be user: stephan tags: trunk) | |
| 21:08 | Experimental changes that try to identify indexes as covering when they contain expressions which do cover all data uses. This check-in does not work, because the AggInfo object might still refer to individual columns. The purpose of this check-in is to preserve the idea. I might come back to it later. (Leaf check-in: 018914a5a1 user: drh tags: indexed-expr-exp) | |
| 18:46 | • New ticket [73ebbb3a3d] View ought not be materialized. (artifact: 60c699c856 user: drh) | |
| 11:59 | • New ticket [9937817793] Use indexed expressions in an aggregate query. (artifact: 9593cae7fd user: drh) | |
| 11:35 | • New ticket [695a1a53de] Better choice of indexes with covering indexes on expressions. (artifact: f6561b0c33 user: drh) | |
3 Years Ago (more context)
|
2021-11-03
| ||
| 16:35 | Remove two incorrect assert() statements added by a check-in from earlier today. (check-in: 3206edff94 user: drh tags: trunk) | |
| 15:59 | Improved the error message that results when a schema parse fails after ALTER TABLE ADD COLUMN. (check-in: b007a39dd3 user: drh tags: trunk) | |
| 14:02 | Fix INSERT into STRICT table with STATIC generated columns. (check-in: 24285d9136 user: drh tags: trunk) | |
| 12:50 | Add the --strict option to speedtest1.c (check-in: a247b5d88c user: drh tags: trunk) | |
| 11:43 | Fix an issue in PRAGMA integrity_check associated reporting NULL values in a NOT NULL column of type ANY in a STRICT table. (check-in: 5dff1f6673 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2020-11-03
| ||
| 12:06 | • Edit [2a71bebfe3139a74|2a71bebfe3]: Mark "Closed". (artifact: 2fb2739b85 user: shearer) | |
| 11:54 | Make platform compilation clearer, including the section that applies to both *ix and Windows Add link to the detailed compilation instructions Add brief Android section, it seems strange to omit it since Android is the majority use case by numbers (Closed-Leaf check-in: 2a71bebfe3 user: shearer tags: docupdate) | |
| 11:27 | Update for new git-style syntax in Fossil (check-in: d46b6778b1 user: shearer tags: docupdate) | |
| 11:20 | Add links, especially for the docsrc repo, which is otherwise hard to find (check-in: e03867e2fb user: shearer tags: docupdate) | |
5 Years Ago (more context)
|
2019-11-03
| ||
| 10:51 | • New ticket [02aa2bd02f] Row value comparison malfunctions on view with left join. (artifact: 0d1dbe8439 user: mrigger) | |
| 10:06 | • New ticket [3c9eadd2a6] PRAGMA integrity_check fails due to CHECK constraint even without records. (artifact: d58c01a983 user: mrigger) | |
| 00:07 | • Fixed ticket [623eff57e7]: LEFT JOIN in view malfunctions with partial index on table plus 6 other changes (artifact: 4895f3bf95 user: drh) | |
| 00:07 | The optimization of check-in [9b2879629c34fc0a] is incorrectly reasoned. The WHERE clause of the partial index might not be true if the table of the partial index is the right table of a left join. So disable the optimization in that case. Ticket [623eff57e76d45f6] (check-in: 3be19e1151 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2014-11-03
| ||
| 18:03 | Updates to the sqlite3_stmt_scanstatus() documentation. No changes to code. (check-in: d97c324eb1 user: drh tags: trunk) | |
| 16:56 | Add the experimental sqlite3_stmt_scanstatus() API. For comparing the number of rows actually visited by a loop with the estimate used by the query planner. (check-in: ab3b0fc576 user: dan tags: trunk) | |
| 16:39 | Fix a typo preventing this from building with SQLITE_ENABLE_STMT_SCANSTATUS defined. (Closed-Leaf check-in: 4c5714ab3d user: dan tags: scanstatus) | |
| 16:35 | Refactor the interface to make it more easily extensible. (check-in: 7955342da4 user: drh tags: scanstatus) | |
| 15:33 | Add further tests. Fixes so that compilation without ENABLE_STMT_SCANSTATUS works. (check-in: a2303c7192 user: dan tags: scanstatus) | |
| 14:46 | Use exponential buffer size growth in StrAccum, as long as the size does not grow to large, to avoid excess memory allocation resize operations. Also, document the fact that setting scratch memory causes SQLite to try to avoid large memory allocations. (check-in: a518bc3318 user: drh tags: trunk) | |
| 13:24 | When enlarging the size of a StrAccum object, use sqlite3DbMallocSize() to record the entire size of the allocation, not just the requested size. (check-in: 3dda3c9374 user: drh tags: trunk) | |
| 11:25 | Remove unused variable from struct WhereInfo. Add some explanatory comments to new code. (check-in: f5313e0c68 user: dan tags: scanstatus) | |
15 Years Ago (more context)
|
2009-11-03
| ||
| 22:48 | • Edit [941a01eb868815f5|941a01eb86]: Change branch background color to "#c0ffc0". Edit check-in comment. Timestamp 2009-11-03 22:34:36. (artifact: a3c2a90c15 user: drh) | |
| 22:34 | Customizations for OSX contributed by Apple. (check-in: 941a01eb86 user: adam tags: apple-osx) | |
| 19:42 | Fix compiler warnings on MSVC build. (check-in: 01c4b5b84e user: shane tags: trunk) | |
| 19:18 | Enhancements to lemon to generate more compact action tables and to avoid making array bounds tests that can never fail on action table calculations. (check-in: 27d8e684db user: drh tags: trunk) | |
| 14:30 | • Edit [64989904d44556ee|64989904d4]: Change background color to "#ffc0d0". Timestamp 2007-08-13 20:31:01. Add tag "release". (artifact: 1336cae07e user: drh) | |
| 13:08 | Force all qsort() calls in mkkeywordhash.c to be stable so that we get predictable results on different platforms. (check-in: 3b02df27ab user: drh tags: trunk) | |
| 13:02 | Adjust the lemon implementation so that it always computes the same PDA regardless of qsort() implementation on the host platform. In other words, make all sorts in lemon stable. (check-in: d66a0f31eb user: drh tags: trunk) | |
| 01:22 | All SQLITE_MAX_VARIABLE_NUMBER to exceed 32767. The sizes of some structures increase when the compile-time parameter is configured this way. (check-in: 16a24b4485 user: drh tags: trunk) | |
20 Years Ago (more context)
|
2004-11-03
| ||
| 16:27 | Update tests to work even if some features of the library are disabled. (CVS 2050) (check-in: b11fc9b3f3 user: drh tags: trunk) | |
| 13:59 | More work on optionally removing unused features at compile-time. (CVS 2049) (check-in: a82980fd70 user: drh tags: trunk) | |
| 11:37 | Auto-vacuum bug: Deallocate pointer-map pages when shrinking a database file. (CVS 2048) (check-in: bec6a65aca user: danielk1977 tags: trunk) | |
| 09:30 | Comment the autovacuum.test script. No code or test-case changes. (CVS 2047) (check-in: 2eacd38620 user: danielk1977 tags: trunk) | |
| 08:44 | Auto-vacuum bug: Correctly manipulate page cache hash-table entries in sqlite3pager_movepage(). (CVS 2046) (check-in: 719c1b7967 user: danielk1977 tags: trunk) | |
| 03:59 | The makefile now runs mkkeywordhash.c. Keywords that are unused are omitted from the keyword hash table. (CVS 2045) (check-in: 007aec1133 user: drh tags: trunk) | |
| 03:52 | Auto-vacuum bugfix: Do not attempt to move a pointer-map page during auto-vacuum. (CVS 2044) (check-in: bd50fbb5fe user: danielk1977 tags: trunk) | |
| 03:01 | Fix an auto-vacuum bug that occurs when a btree cell is promoted to the parent page during a delete. (CVS 2043) (check-in: b7d953e119 user: danielk1977 tags: trunk) | |