This Day In History For 2025-11-11
1 Year Ago (more context)
2024-11-11
| ||
21:11 | Clarify the documentation to make it clear that rows inserted by a CREATE TABLE AS SELECT statement are not counted by sqlite3_count64(). Forum post 1e6cde5648. (check-in: 5c5982e393 user: drh tags: trunk) | |
21:07 | Adjust the behavior of sqlite3_changes64() so that it counts INSERTs into a new table created using "CREATE TABLE name AS SELECT ...". It has never done this before. The documentation is a little ambiguous about whether or not it actually should. This check-in is on a branch because it will probably never make it to trunk for fear of breaking some legacy program. (Closed-Leaf check-in: b741608cd3 user: drh tags: chngcnt-create-as) | |
19:49 | Fix the fts5 trigram tokenizer so that it handles non-nul-terminated strings. (check-in: 84f4e37178 user: dan tags: trunk) | |
19:07 | Add the ".dbtotxt" command to the CLI. (check-in: b43acf5a8c user: drh tags: trunk) | |
18:15 | Wrap some exceptionally long lines in main.mk. Add option to override LDFLAGS on the sqlite3.dll target. Audit: all targets for which it is hypothetically relevant can now inherit user-supplied LDFLAGS, but only those provided to the configure script, not at make-time, in order to mimic the historical build's restriction in that regard. (check-in: 073080cae3 user: stephan tags: trunk) | |
18:11 | Optimize deferred allocation of pages on this branch by avoiding BTALLOC_LE. (check-in: 0812161025 user: dan tags: begin-concurrent) | |
17:03 | Update this branch with latest changes and build system updates from trunk. (check-in: 52bd7953f1 user: dan tags: begin-concurrent) | |
17:02 | Use Win32 APIs to read/write the console in Windows unless the SQLITE_USE_STDIO_FOR_CONSOLE option is defined. This is an attempt to get the build working on MinGW. (check-in: abfe488ed6 user: drh tags: trunk) | |
15:38 | • Edit [d85f14c713690711|d85f14c713]: Move to branch cli-fuzz. (artifact: f286d0c63e user: drh) | |
13:17 | Add an -fsanitize=fuzzer compatibility mode to the CLI. (Leaf check-in: d85f14c713 user: drh tags: cli-fuzz) | |
09:53 | Doc update to account for [05073350087b]. (check-in: b81976c520 user: stephan tags: trunk) | |
09:37 | Rename proj-define-if-opt-truthy to the more accurate, and less verbose, proj-define-for-opt. (check-in: 0507335008 user: stephan tags: trunk) | |
2 Years Ago (more context)
2023-11-11
| ||
22:53 | Remove SHELL_LEGACY_CONSOLE_IO PP symbol and code it made active. (It is in the repo if ever needed/wanted, but it is just inferior or dead code now.) (check-in: 27c5bf6563 user: larrybr tags: console-io-lib) | |
22:11 | • Edit [923c6b8b3a508c71|923c6b8b3a]: Edit check-in comment. (artifact: 41eba8abbe user: larrybr) | |
20:46 | Complete shell transition to using {f,o,e}put{f,z}() emit functions. (check-in: 923c6b8b3a user: larrybr tags: console-io-lib) | |
14:50 | JNI wrapper1: when checking for an out-of-bounds statement column index, perform the is-statement-finalized check before the range check so that the former exception trumps the latter. (check-in: 0832f9a8e9 user: stephan tags: trunk) | |
14:43 | Do not cache a statement's column count in the JNI wrapper1 API because an ALTER TABLE via another statement may invalidate it, as reported in forum post 6d80efd58d4591c7. (check-in: a6ab88e9a6 user: stephan tags: trunk) | |
13:09 | Fix malf with redirected input due to bad assumption that stdin is a console in the fgets() replacement. (check-in: 79d1f2c101 user: larrybr tags: console-io-lib) | |
06:20 | Pervasive changes to console_io.{c,h} in support of simplifying ubiquitous emit ops in shell, and to get better control of console streams that might be opened only via .read or .output commands. Changes to shell to use {s,o,e}put{f,z}(...) calls for initial testing, but this check-in has few such conversions so that most will be in a separate check-in. Many renames to better follow recent coding convention. This code seems to be working, but has not been tested on difficult platforms or with multiple console hosts yet. So it is a WIP. (check-in: 14762a004c user: larrybr tags: console-io-lib) | |
3 Years Ago (more context)
2022-11-11
| ||
13:51 | • Closed ticket [ee4b2b48f5]: Prepared statement cache plus 5 other changes (artifact: c40bea5050 user: drh) | |
13:17 | • Fixed ticket [6c266900a2]: shell: The column mode (and width option) does not manage correctly UTF-8 plus 4 other changes (artifact: 6fcbd02442 user: drh) | |
13:00 | • Edit [d31c019fd6849e4c|d31c019fd6]: Edit check-in comment. (artifact: a4f61caf33 user: drh) | |
4 Years Ago (more context)
2021-11-11
| ||
23:52 | Make sure the rowid value returned by the VUpdate opcode is always initialized. (check-in: 150b5be5d5 user: drh tags: trunk) | |
16:26 | Remove a NEVER() that was add yesterday. The fuzzer found a new test case to make it happen. (check-in: 83e6ac7107 user: drh tags: trunk) | |
11:23 | New assert() statements to help prove correct usage of VdbeCursor objects. (check-in: 7cee62f77a user: drh tags: trunk) | |
5 Years Ago (more context)
2020-11-11
| ||
19:11 | Fix a typo in a comment. No changes to code. (check-in: 572f1ed59d user: drh tags: trunk) | |
10 Years Ago (more context)
2015-11-11
| ||
18:43 | Fix missing word in a documentation comment. No changes to code. (check-in: ed24d30265 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: c6fa01c28e 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: 2518d5c971 user: drh tags: trunk) | |
15 Years Ago (more context)
2010-11-11
| ||
17:48 | Use "COMPOUND" instead of "COMPOSITE" in the EXPLAIN QUERY PLAN output to describe UNION, UNION ALL, EXCEPT and INTERSECT operations. (check-in: 28643b85d9 user: dan tags: experimental) | |
16:46 | Add a row of EXPLAIN QUERY PLAN output for each composite select operation (UNION, EXCEPT etc.) in the query. (check-in: 00fb8468b5 user: dan tags: experimental) | |
11:43 | Fix a bug in the EXPLAIN QUERY PLAN code. (check-in: 7ae068952f user: dan tags: experimental) | |
10:36 | Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: 30904ef841 user: dan tags: experimental) | |