/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent check-ins

2020-07-11
16:45
[1bd18ca35b] Leaf: Add second test case for the improvement in [30735432]. (user: dan tags: trunk)
16:42
[30735432bc] Improved detection of a corrupt database schema. Fix for a problem discovered by dbsqlfuzz. (user: drh tags: trunk)
2020-07-10
21:43
[1e87da9c93] Remove unnecessary code from the window functions implementation. (user: drh tags: trunk)
19:09
[4a64c16fb7] Leaf: An attempt to get the Min/Max optimization working with IN constraints. Not currently working. (user: drh tags: minmax-opt-exp)
11:12
[5124732370] Fix a broken assert() in fts3 that could fail when handling corrupt records. (user: dan tags: trunk)
2020-07-09
21:29
[ccff8cb826] Fix handling of another corrupt database case in fts3. (user: dan tags: trunk)
14:05
[610ee8d5dc] Fix a comment typo. No changes to code. (user: drh tags: trunk)
2020-07-07
19:24
[138beebb2a] Remove bashism from configure script. (user: dan tags: trunk)
2020-07-06
12:13
[612eb590ea] Increase the resolution of the vdbe opcode counters to 64 bits, as apparently some users run single prepared statements that go for longer than 4 billion instructions. See forum post "[https://sqlite.org/forum/forumpost/d07949dc94|Possible freeze in the progress loop]" (user: drh tags: trunk)
2020-07-04
20:29
[6da77973ab] Fix the table_info pragma so that it always checks the schema version and reprepares, even if it is a no-op. (user: drh tags: trunk)
2020-07-03
21:24
[e0a8b11dfd] Fix the line-number of error messages coming out of the ".import" command when the --skip option is used. (user: drh tags: trunk)
21:18
[b27bb4fe38] Fix a compiler warning about an unused procedure in the parser. (user: drh tags: trunk)
18:07
[ca7630a577] Update the lemon documentation to match recent enhancements. (user: drh tags: trunk)
17:24
[1f96a29dd8] If the amalgamation is built using OPT_FEATURE_FLAGS = -DSQLITE_UDL_CAPABLE_PARSER then it can be compiled with or without the -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT option and it works either way. (user: drh tags: trunk)
15:41
[951d22b72f] In lemon, add "%if" and "%else" and allow boolean expressions as the argument to "%if", "%ifdef", and "%ifndef". (user: drh tags: trunk)
12:32
[07f849dee3] Fix the pragma_foreign_key_check virtual table so that it accepts arguments. (user: drh tags: trunk)
12:15
[81bc4b65ae] Fix a problem with "PRAGMA foreign_key_check" where if a table in one schema appears to have foreign key constraints against another table in a different schema, the pragma will try to check the constraints even though they do not apply because they are in different schemas. (user: drh tags: trunk)
2020-07-02
17:05
[6ffd17b668] Minor simplification to the 32-bit varint decoder. (user: drh tags: trunk)
2020-07-01
16:19
[27d4a9a7b5] Ensure that the "PRAGMA schema_version" command causes the schema to be reparsed and reloaded. (user: drh tags: trunk)
14:07
[2094da753f] Fix a problem with VM code generated for some aggregate SELECT statements that feature min()/max() aggregates both with and without FILTER clauses. (user: dan tags: trunk)
2020-06-30
18:21
[f068fb1162] Add a test to ensure that "PRAGMA wal_checkpoint = FULL" invokes the busy-handler to wait on read-locks. (user: dan tags: trunk)
15:32
[4d0cfb1236] Avoid a potential buffer overread in fts3 when processing corrupt records. (user: dan tags: trunk)
2020-06-29
20:26
[fa9d93cf32] Fix generated columns so that they play well with upsert. See the [https://sqlite.org/forum/forumpost/73b9a8ccfb|forum post] by "iffycan" for details. (user: drh tags: trunk)
20:20
[e96c2ac9ab] Change the magic number used to identify the "excluded" pseudo-table in an UPSERT statement into a #define constant. (user: drh tags: trunk)
20:09
[a73f80f22a] Document the dual-use of the P5 operand to the OP_MakeRecord opcode. (user: drh tags: trunk)
19:58
[9c2b4bdd03] Leaf: Passive checkpoints do not use the busy-handler. So, in order to minimize visible changes for legacy applications, do not enable blocking locks for passive checkpoints. (user: dan tags: wal-setlk-changes)
18:30
[87c7d96258] Change the name of IntegrityCk.mallocFailed to IntegrityCk.bOomFault to avoid confusion with the sqlite3 object field with the same name. (user: drh tags: trunk)
18:22
[ac381e6eb3] Change things so that if SQLITE_ENABLE_SETLK_TIMEOUT is defined as 2 instead of 1, all blocking locks are taken for a single millisecond and the default busy-handler invoked as normal. (user: dan tags: wal-setlk-changes)
17:52
[ada43e7c49] Add test script to verify busy-timeouts are working for SQLITE_ENABLE_SETLK_TIMEOUT builds. (user: dan tags: trunk)
16:30
[1b426603f0] Do not run resetAccumulator() after a malloc failure. (user: drh tags: trunk)
13:33
[6e0ffa2053] Fix another fts3 problem with processing corrupt records. (user: dan tags: trunk)
13:12
[61400ef9f1] Small performance improvement in the sqlite3_step() interface. (user: drh tags: trunk)
2020-06-26
20:41
[be545f85a6] Fix a problem that could cause an infinite loop in the fts3 'merge' command. (user: dan tags: trunk)
17:56
[e12225d59c] When computing the verification hash in speedtest1, do not include the value of floating point results (which can very in trailing bits depending on platform) but merely hash the fact that a floating point value was received. (user: drh tags: trunk)
16:17
[d34b8ff5f8] Improvements to speedtest1.c for more consistent verification hashes. (user: drh tags: trunk)
15:42
[f3455cecf2] Improvements to speedtest1. Added the --memdb and --output options. The --verify option now outputs a hash of SQL outputs. The speed-check.sh script disables the hashing feature with --legacy and adds the --verify option. (user: drh tags: trunk)
15:32
[c78cbf2e86] Add the ieee754_to_blob() and ieee754_from_blob() functions. Fix the handling of subnormal forms in the two-argument version of ieee754(). (user: drh tags: trunk)
14:05
[89a11120ab] Closed-Leaf: Add --verify to speed-check.sh and add --memdb and --output to speedtest1.c. Other improvements to speedtest1.c. (user: drh tags: speedtest-hash)
04:34
[cc888878ea] Fix a possible null pointer deref following OOM. Discovered by dbsqlfuzz. (user: drh tags: trunk)
2020-06-25
23:21
[adb7484f93] Update the showlocks utility program so that it functions on files with a huge number of locks without overflowing the stack. (user: drh tags: trunk)
20:28
[60d1e46c8c] Enhance the --verify option to speedtest1.c so that it computes and displays a hash of the result from all SQL queries, for verification purposes. (user: drh tags: speedtest-hash)
2020-06-24
15:06
[db2f0836b6] Add the ieee754_mantissa() and ieee754_exponent() functions to the iee754 extension. Build the ieee754 extension into the CLI. (user: drh tags: trunk)
13:52
[838817b680] Fix the decoding of subnormal values in the ieee754 extension. (user: drh tags: trunk)
13:14
[4199c1e8aa] In the one-argument version of the ieee754() extension function, if the argument is an 8-byte blob, interpret that blob as a binary64 floating point and decode it. (user: drh tags: trunk)
12:29
[5391687bf8] Add the decimal extension. It is built into the shell, but is an optional add-on for the library. It is not included in the amalgamation. (user: drh tags: trunk)
11:45
[d45c27a3e5] Fix the ".selecttrace" command in the CLI (only available when compiled with the non-standard -DSQLITE_ENABLE_SELECTTRACE option) so that it does not segfault if invoked without any arguments. (user: drh tags: trunk)
2020-06-23
20:03
[780e8aaa23] Enhance the --testset option on speedtest1 so that it can accept a comma-separated list of test modules to run in order. (user: drh tags: trunk)
17:57
[be3e7814e4] Try to remove end-of-line whitespace when building the amalgamation. (user: drh tags: trunk)
15:29
[e1416c8b06] Closed-Leaf: Fix a harmless compiler warning. (user: drh tags: decimal)
14:44
[0294ce071c] Avoid unnecessary normalization in decimal_sum(). Trim excess trailing zeros off the result of decimal_mul(). (user: drh tags: decimal)