This Day In History For 2025-05-19
1 Year Ago (more context)
|
2024-05-19
| ||
| 18:29 | • Ticket [accfef3317] Unicode output from the CLI subprocess not displayed correctly on Windows. status still Closed with 3 other changes (artifact: b07e6e0798 user: larrybr) | |
2 Years Ago (more context)
|
2023-05-19
| ||
| 18:26 | Extend detection of the INSERT...RETURNING locking case to the DB.selectValue(s)/selectArray/selectObject() family of functions. Add tests for INSERT/UPDATE...RETURNING with those functions. (check-in: 58be212d56 user: stephan tags: branch-3.42) | |
| 18:23 | Extend detection of the INSERT...RETURNING locking case to the DB.selectValue(s)/selectArray/selectObject() family of functions. Add tests for INSERT/UPDATE...RETURNING with those functions. (check-in: 3181c50540 user: stephan tags: trunk) | |
| 17:59 | Minor doc typo fix. (check-in: 4533be0878 user: stephan tags: trunk) | |
| 17:52 | oo1.Stmt.finalize() no longer throws, but instead returns the same as the C API. oo1.DB.exec() now triggers the INSERT...RETURNING locking failure as an exception via reset() instead of finalize(). Some code-adjacent internal API renaming for clarity's sake. (check-in: 15f105c782 user: stephan tags: branch-3.42) | |
| 17:50 | oo1.Stmt.finalize() no longer throws, but instead returns the same as the C API. oo1.DB.exec() now triggers the INSERT...RETURNING locking failure as an exception via reset() instead of finalize(). Some code-adjacent internal API renaming for clarity's sake. (check-in: 4ee6b3aa53 user: stephan tags: trunk) | |
| 16:42 | Improved documentation for sqlite3_reset(), in response to forum post a72bab3dea. (check-in: 1dfeb3dcee user: drh tags: trunk) | |
| 16:39 | sqlite3.oo1.Stmt.reset() and finalize() now throw if their underlying C-level APIs return non-0, in order to avoid silent failure in certain locking-related cases. (check-in: db36a9ef59 user: stephan tags: branch-3.42) | |
| 16:34 | sqlite3.oo1.Stmt.reset() now throws if sqlite3_reset() returns non-zero, analog to [f23eb5c6d365]. (check-in: 487ae12c9a user: stephan tags: trunk) | |
| 16:25 | CLI resmanage used wherever resources should not be leaked upon abrupt (OOM) termination. (check-in: 1687d12339 user: larrybr tags: cli_extension) | |
| 16:12 | Add a basic INSERT RETURNING test for the oo1.DB.exec() API. (check-in: d29d62cf76 user: stephan tags: trunk) | |
| 15:54 | sqlite3.oo1.Stmt.finalize() now throws if sqlite3_finalize() returns non-zero. This is intended to address the INSERT RETURNING case covered in forum post 36f7a2e7494897df. (check-in: f23eb5c6d3 user: stephan tags: trunk) | |
| 12:46 | Correct typo in an 'extern' decl name, reported in forum post 1d4342156439233b. (check-in: 3bb1d7b376 user: stephan tags: branch-3.42) | |
| 12:41 | Correct typo in an 'extern' decl name, reported in forum post 1d4342156439233b. (check-in: 6ac18827d8 user: stephan tags: trunk) | |
| 11:48 | Change the RTREE engine so that equality comparisons of floating point values are duplicated in the byte-code so that the comparisons are done using 64-bit floats and consistent results are always obtained. Forum post da61c4a1b5b4af19. (check-in: 4ec0f0a31b user: drh tags: trunk) | |
3 Years Ago (more context)
|
2022-05-19
| ||
| 22:04 | #if'd out the '.nonce' and '.check' commends in WASM builds. (check-in: 326f79ea54 user: stephan tags: trunk) | |
| 21:56 | #if'd out the the '.cd' and '.clone' commands for WASM builds. (check-in: fa391868dd user: stephan tags: trunk) | |
| 18:14 | fiddle: consolidated two duplicate CSS rules. Internal doc typo fix. (check-in: d3175a793f user: stephan tags: trunk) | |
| 17:47 | Added a disclaimer about fiddle's experimental and subject-to-change/removal nature. (check-in: 75b4f57408 user: stephan tags: trunk) | |
| 16:59 | Merge the changes to support the "fiddle" extension. (check-in: 58585f01aa user: drh tags: trunk) | |
| 16:49 | When building fiddle from its own directory (e.g. from emacs instead of the normal build process), force -O0 the sake of compilation speed. The top-level build now defaults to -Oz, which is more appropriate for that case. (Closed-Leaf check-in: 56b82ae806 user: stephan tags: fiddle) | |
| 16:42 | Tweaks to the fiddle make target so that it builds with all of the same extensions as the standard CLI. (check-in: d46a6cb974 user: drh tags: fiddle) | |
| 16:30 | Added a toggle to swap input/output field positions and simplified setup of checkboxes which toggle a CSS class on a given element. (check-in: eae3ab10c8 user: stephan tags: fiddle) | |
| 16:11 | Default to top/bottom layout with input on the bottom. Offer a toggle to swap input/output positions. (check-in: 362d236aca user: stephan tags: fiddle) | |
| 15:58 | Numerous layout tweaks, the most significant being that the layout now adapts to the window size. Swapped positions of the input/output areas. This version supports, by uncommenting a few bits, a jquery.terminal-based view but alternatives to that 300kb dependency are still under investigation. (check-in: 1aad3642c9 user: stephan tags: fiddle) | |
| 10:58 | fiddle make target now accepts fiddle_cflags=... from the CLI to overrid -Ox and such for one-off builds. (check-in: 4609a4f862 user: stephan tags: fiddle) | |
| 10:38 | Ensure that the output area is cleared of any init-time messages which the emscripten bootstrapping process emits when downloading of the wasm module is slow. (check-in: 1d8d059357 user: stephan tags: fiddle) | |
| 10:24 | #if'd out the '.log' command in WASM builds. Cleaned up the user-visible parts of the WASM module initialization. (check-in: b5fa12f824 user: stephan tags: fiddle) | |
| 09:55 | Split the fiddle JS code into separate pre-/post-init files to simplify editing. emcc will combine these into the final fiddle.js, so the number of output deliverables does not change. (check-in: d3d8ea0118 user: stephan tags: fiddle) | |
| 09:22 | Added an option to auto-clear the output area before submitting the input. Experimentally inverted the colors in the input/output areas. (check-in: 1a1e4e7fdb user: stephan tags: fiddle) | |
| 01:12 | Replaced the toggle for the notes/caveats section of the fiddle UI with a button to remove that section. (check-in: 6661d60527 user: stephan tags: fiddle) | |
| 00:38 | #if'd out the '.import' command in WASM builds. Several minor cosmetic UI tweaks. (check-in: e4f87eb7c3 user: stephan tags: fiddle) | |
4 Years Ago (more context)
|
2021-05-19
| ||
| 23:29 | final merge from trunk (Leaf check-in: 0662956944 user: larrybr tags: compile_options) | |
| 21:55 | When constructing the synthensized SELECT statement that is used to choose the rows in an UPDATE FROM, make sure the first table is really the table being updated, and not some common-table expression that happens to have the same name. forum post a274248080. More changes associated with CTE name resolution are pending. (check-in: 0f0959c6f9 user: drh tags: trunk) | |
| 20:01 | Incorporate ..._DESERIALIZE revision. (check-in: b70587cca9 user: larrybr tags: compile_options) | |
| 19:55 | merge from trunk (check-in: 19ffe3cfe2 user: larrybr tags: compile_options) | |
| 19:29 | • Edit [6f2fb60e499fc758|6f2fb60e49]: Mark "Closed". (artifact: 6d46171d80 user: drh) | |
| 19:28 | Add a comment with useful information about SHM locking. No changes to deliverable code. (check-in: 4e81ea3b15 user: drh tags: trunk) | |
| 19:27 | Fix a formatting error on the comment. (Closed-Leaf check-in: 6f2fb60e49 user: drh tags: better-comment) | |
| 19:26 | • Edit [b480aacb3430a789|b480aacb34]: Move to branch better-comment. (artifact: eca477ca71 user: drh) | |
| 16:55 | Add a table of shared-memory lock offsets in a comment in the os_unix.c code. Include some assert()s to help verify the numbers. (check-in: b480aacb34 user: drh tags: better-comment) | |
| 14:49 | Allow aggregate sub-selects within ORDER BY and PARTITION BY clauses of window frame definitions. (check-in: 3daab94977 user: dan tags: trunk) | |
| 12:17 | Improved column name and column type determination for the RETURNING clause. (check-in: 699c33990a user: drh tags: trunk) | |
| 02:33 | Cure some TCL test failures and narrow an object scope. (check-in: 1155696c70 user: larrybr tags: trunk) | |
5 Years Ago (more context)
|
2020-05-19
| ||
| 15:51 | Add compiler hints to disable TSAN for the routines that access the -shm file header in WAL mode using a double-read with memory barrier. (check-in: 3117c1b5a9 user: drh tags: trunk) | |
| 15:40 | In os_win.c, avoid calling sqlite3_uri_boolean() on anything other than a main-db filename. (check-in: cb0a18e64f user: dan tags: trunk) | |
| 15:33 | • Edit [87ecd1eca4890288|87ecd1eca4]: Move to branch mistake. Add propagating "hidden". (artifact: 51e97f86d5 user: dan) | |
| 15:33 | • Edit [87ecd1eca4890288|87ecd1eca4]: Mark "Closed". Add tag "mistake". (artifact: 990f2d7f0a user: dan) | |
| 15:29 | In os_win.c, avoid calling sqlite3_uri_boolean() on other than a main-db file-name. (Closed-Leaf check-in: 87ecd1eca4 user: dan tags: mistake) | |
| 12:29 | User-suggested improvement to the README.txt for the ICU extension. (check-in: 1d1293c25a user: drh tags: trunk) | |
| 12:27 | In wal.c, improved comments on concurrency issues. More use of AtomicLoad() and AtomicStore(). (check-in: 4bf566feca user: drh tags: trunk) | |
10 Years Ago (more context)
|
2015-05-19
| ||
| 23:56 | Enhance the selecttrace display by showing Select.selFlags. (check-in: 45d3893c61 user: drh tags: trunk) | |
| 23:04 | Merge the Makefile.msc fix and the compiler warning fix from trunk. Also fix another compiler warning in sqlite3session_diff(). (check-in: 7530e1bf55 user: drh tags: sessions) | |
| 22:56 | Fix the MSVC makefile so that it works with OTA. Fix a harmless compiler warning in FTS3. (check-in: c7b1664530 user: drh tags: trunk) | |
| 22:42 | Merge recent trunk changes, include the R-Tree enhancement that allows 8-byte BLOB arguments to geometry functions, and the fix for the TEXT affinity problem that could cause corrupt indexes. (check-in: 0a0de8b72c user: drh tags: sessions) | |
| 22:20 | Allow R-Tree geometry functions to take 8-byte BLOB arguments which are passed directly through to the underlying callback, and which can be used to pass pointers into the callback. (check-in: b271ed5653 user: drh tags: trunk) | |
| 20:34 | • Ticket [34cd55d68e] Database corruption following INSERT with a TRIGGER that does an affinity change status still Fixed with 3 other changes (artifact: c195566c38 user: drh) | |
| 19:55 | • Fixed ticket [34cd55d68e]. (artifact: 4d04bea376 user: drh) | |
| 19:52 | Ensure that when the VM applies TEXT affinity to a value it discards any existing REAL or INTEGER value. Fix for [34cd55d6]. Increase the version number to 3.8.10.2. (check-in: 40f67265c4 user: drh tags: branch-3.8.10) | |
| 19:44 | • Edit [f5d0ce80792d58ef|f5d0ce8079]: Edit check-in comment. (artifact: 4e50b5ad02 user: dan) | |
| 19:44 | Ensure that when the VM applies TEXT affinity to a value it discards any existing REAL or INTEGER value. Fix for [34cd55d6]. (check-in: f5d0ce8079 user: dan tags: trunk) | |
| 19:37 | Add tests for fts5 tokenizers. (check-in: 4f90ba20e2 user: dan tags: fts5) | |
| 19:08 | • New ticket [34cd55d68e] Database corruption following INSERT with a TRIGGER that does an affinity change. (artifact: 208465f372 user: drh) | |
| 17:48 | Remove the sqlite3ota_open_v2() API. Add a new parameter to sqlite3ota_open() instead. (check-in: c74e0bc481 user: dan tags: trunk) | |
| 16:50 | Merge the ota-update branch with trunk. (check-in: 08e2864ed7 user: dan tags: trunk) | |
| 16:26 | Add a comment for SQLITE_FCNTL_OTA to sqlite.h.in. (Closed-Leaf check-in: efa20f8e41 user: dan tags: ota-update) | |
| 16:22 | Allow OTA update state data to be stored in a database separate from the OTA update database. (check-in: 5af8db56af user: dan tags: ota-update) | |
| 14:14 | Merge latest trunk changes with this branch. (check-in: 6055a6725c user: dan tags: ota-update) | |
| 11:38 | Update Makefile.in so that the amalgamation files built by "make sqlite3.c" include fts5. (check-in: 2870a80593 user: dan tags: fts5) | |
| 11:32 | Fix a memory leak that could follow an OOM condition in fts5. (check-in: de9f8ef6eb user: dan tags: fts5) | |
15 Years Ago (more context)
|
2010-05-19
| ||
| 23:41 | Merge WIN32 WAL support into trunk. Still some issues with locking to resolve. (check-in: 43377663fc user: shaneh tags: trunk) | |
| 22:09 | Cherry-pick the SQLITE_FCNTL_SIZE_HINT patch (check-in [2b7e3b4a30d6a7c4a8] and bump the version number to 3.6.23.2. (check-in: 776679af58 user: drh tags: branch-3.6.23) | |
| 20:30 | Disable the corruptE test which SQLITE_OVERSIZE_CELL_CHECK is enabled. This is a cherrypick merge from check-in [1dc4f9fe9b83467ba]. (check-in: a40d080ca3 user: drh tags: branch-3.6.23) | |
| 19:39 | Add the SQLITE_FCNTL_SIZE_HINT to the os_win.c VFS. (check-in: 9894118d20 user: drh tags: trunk) | |
| 19:26 | Add the SQLITE_FCNTL_SIZE_HINT operator to sqlite3_file_control() and use it to give the VFS hints about the ultimate size of a database file when the file is growing. (check-in: 2b7e3b4a30 user: drh tags: trunk) | |
| 19:09 | Fix a bug in the new checkpoint computation. Also update the checkpoint algorithm in the test scripts to align with the new implementation. (check-in: 8b6056f2ee user: drh tags: trunk) | |
| 18:08 | Revise the checksumming algorithm in wal.c. More variable refactoring. (check-in: 542b90eba6 user: drh tags: trunk) | |
| 17:49 | Refactoring some variable names in wal.c. (check-in: 1d201ff51f user: drh tags: trunk) | |
| 16:24 | • Edit [97d88a86e45e7a42|97d88a86e4]: Change branch background color to "#c0c0c0". Move to branch branch-3.6.1-exp. Edit check-in comment. Timestamp 2010-05-18 12:37:05. (artifact: e1da89a92c user: drh) | |
| 01:53 | Add a large comment to wal.c describing the WAL and wal-index file formats. (check-in: a71a22b52f user: drh tags: trunk) | |
20 Years Ago (more context)
|
2005-05-19
| ||
| 08:43 | Always use a more specific type (P3_FUNCDEF) instead of P3_POINTER as the P3 type of a vdbe instruction. (CVS 2463) (check-in: 79a41674be user: danielk1977 tags: trunk) | |
| 01:26 | Fix an array index that is out of bounds. Ticket #1251. (CVS 2462) (check-in: bcf87e4d16 user: drh tags: trunk) | |