/ Timeline
Login

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

50 most recent check-ins

2019-12-09
02:20
Fix possible null pointer dereferences in the fts5_expr() scalar function. Leaf check-in: c5d4414359 user: dan tags: trunk
2019-12-08
00:06
Fix incorrect column-usage accounting associated with generated columns and added by check-in [6601da58032d18ae]. Fix for ticket [b92e5e8ec2cdbaa1]. check-in: 9d75e1ccc7 user: drh tags: trunk
2019-12-07
13:42
Correctly deal with multi-row VALUES clauses that contain window functions. check-in: 26d991f214 user: drh tags: trunk
12:13
Ignore type affinity for auxiliary columns in RTREE as it is too error-prone to try to parse out the type from other constraints. Ticket [8bf76328ac940d52] check-in: 7fa664ea0e user: drh tags: trunk
00:22
Fix a problem with foreign keys and generated columns discovered by Manuel Rigger. check-in: 27c0fdab1b user: drh tags: trunk
2019-12-06
19:07
Early detection and reporting of too few columns in an rtree CREATE VIRTUAL TABLE statement. check-in: ef73107f47 user: drh tags: trunk
13:10
In the rtree extension, actively suppress extra tokens on the column names, and be pedantic about column affinities. Ticket [367a86e28859f1ff] check-in: 97fb5a72f9 user: drh tags: trunk
11:48
The check-in [b7810062ec2489e1] was not quite right in that it allowed an oversized shift operation (which is UB in C) on some obscure inputs. OSSFuzz found the problem for us overnight. check-in: 62f2235adf user: drh tags: trunk
01:38
Further enhancements to RTREE, following up to check-in [f898d04cf272ef01] so that constraints are allowed to be compared to strings that look like numbers. Ticket [aa573a787b8f1fdf] check-in: 32772dfd50 user: drh tags: trunk
01:23
Do not allow UPSERT of a view. check-in: ebf897e861 user: drh tags: trunk
2019-12-05
21:46
Fix to the rowvalue logic that avoids disabling rowvalue inequality contraints on a virtual table when the virtual table sets the omit flag. The logic has been incorrect since row-values were added. However, this does not come up often as very few virtual tables implement inequality constraints using the omit flag. Ticket [f096d191b6641daa] check-in: b7810062ec user: drh tags: trunk
18:29
Documentation update: Clarify that the sqlite3_index_info.aConstraintUsage.omit flag is a hint only and that the code generator is not obligated to follow the hint. check-in: 7d3e3f6e7e user: drh tags: trunk
17:31
Additional debugging information printed with the ".wheretrace 0x100" option. No changes to normally delivered code. check-in: fc72ec52c9 user: drh tags: trunk
14:42
Make sure the rowid of an RTREE virtual table has integer affinity. Ticket [9fe487ba3c064b4e] check-in: 7ae8c0d52f user: drh tags: trunk
14:31
Fix a problem in ALTER TABLE that could occur if an index, view or trigger in the schema features an expression of the form ((SELECT ...) IN ()) where the SELECT statement uses a CTE. check-in: 7e5ad8e0ab user: dan tags: trunk
13:34
Be strict about type enforcement on rowid look-ups in the RTREE extension. Ticket [30e2c183b6b356e4] check-in: d43e0efb96 user: drh tags: trunk
00:44
Enhance the RTREE extension so that it give correct query results even if the query uses non-numeric constraints. Ticket [a55ab6d97d01ecbc] check-in: f898d04cf2 user: drh tags: trunk
2019-12-04
19:45
Window functions are never constant. check-in: 35f0b5a8c7 user: drh tags: trunk
15:08
Ensure that an ALWAYS() in the rename logic really is always true, even for faulty inputs. check-in: 54410f0e77 user: drh tags: trunk
14:26
Fix an assert() failure that could occur in ALTER TABLE code when the schema contains a view that uses a CTE. check-in: 75b04a4b0d user: dan tags: trunk
03:46
Fix a buffer overread that could occur in fts3 with corrupt %_stat records. check-in: e01fdbf9f7 user: dan tags: trunk
03:31
Fix an incorrect NEVER() macro. check-in: 96b6a76da0 user: drh tags: trunk
01:42
Fix a double-free that could occur when a component of a compound SELECT with an ORDER BY clause uses named window definitions. check-in: 92893b7980 user: dan tags: trunk
2019-12-03
03:34
Avoid a crash that could occur when a database containing a table with a temp trigger that has the same name as a temp table is detached. check-in: c4cb9708d4 user: dan tags: trunk
03:31
Avoid a harmless zero offset of a null pointer in FTS3, so as to not provoke unnecessary warnings from run-time checkers. check-in: 85d95abec4 user: drh tags: trunk
02:51
Avoid computing a zero offset of a null pointer, which though this is technically harmless, is upsetting to pedantic run-time checkers. check-in: 3ce804e99b user: drh tags: trunk
2019-11-30
19:29
Do not allow a term in the WHERE clause of the query to qualify a partial index on the right table of a LEFT JOIN. Ticket [7f39060a24b47353] check-in: 4066a34da7 user: drh tags: trunk
2019-11-29
13:01
Add comments in the parse.sql file to help demonstrate how rules are encoded. check-in: 2c4f714892 user: drh tags: trunk
12:51
Fix the parse.sql output file so that it is readable into a database where foreign keys are enforced. check-in: 3a82c554c3 user: drh tags: trunk
2019-11-27
20:40
More details on the comment justifying the aleged data race in the WAL-mode checkpoint logic. check-in: 0fab65c79f user: drh tags: trunk
12:03
Fix obsolete comment. No changes to code. Leaf check-in: 0ff59edbbb user: drh tags: reuse-shm
2019-11-26
14:24
Fix various documentation typos suggested by Mark Benningfield. No changes to code. check-in: 08f09dc4f9 user: drh tags: trunk
11:10
Fix to check-in [5d9a369301a65f32] so that it compiles without SQLITE_DEBUG. check-in: fefe2d0467 user: drh tags: trunk
02:22
Add the new -S option to the lemon parser generator to cause it to output SQL that describes the input grammar. check-in: 4dbd398d64 user: drh tags: trunk
02:03
Fix an assert() in fts3 that could fail due to corrupt database records. check-in: 5d9a369301 user: dan tags: trunk
2019-11-25
23:55
Experimental file-controls for controlling the use of the -shm file. check-in: 12b8fa2336 user: drh tags: reuse-shm
04:15
Modify journal3.test so that it can handle Tcl command "file attr <file> -perm" returning octal values in either "00755" or "0o755" format. check-in: b0b655625c user: dan tags: trunk
00:07
Minor enhancements to the TclKit download tool. check-in: 75e31b1d56 user: mistachkin tags: trunk
2019-11-23
16:34
Abort the window function tree rewrite early following an OOM. check-in: d66f95a515 user: drh tags: trunk
15:10
Avoid evaluating PARTITION BY or ORDER BY expressions multiple times for window function queries that use multiple window functions with the same window-definition. check-in: 57070c68bb user: dan tags: trunk
08:51
Enhance the path arguments in JSON functions to access "#-N" array indexes. check-in: ffeec62cb5 user: drh tags: trunk
08:36
Fix a memory leak in fts5 error handling code. check-in: de6637e15d user: dan tags: trunk
2019-11-22
17:37
Extend the json-path mechanism with array indexes of the form "#" or "#-n" for some positive number "n", to reference the end of an array. Closed-Leaf check-in: 35ed68a651 user: drh tags: json-path-enhancement
11:49
Fix a harmless compiler warning. check-in: 34343c4b06 user: drh tags: trunk
11:47
Fix an indentation error and improve the placement of an assert() based on a tweet from Yuri Kotov. check-in: e6314e386c user: drh tags: trunk
11:38
Add more test cases from Yongheng Chen and Rui Zhong. check-in: f24e6ca4f2 user: drh tags: trunk
10:14
Fix a crash that could occur if a sub-select that uses both DISTINCT and window functions also used an ORDER BY that is the same as its select list. check-in: bcdd66c169 user: dan tags: trunk
00:42
Revise the SQLITE_OPEN_NOFOLLOW so that it actually uses O_NOFOLLOW in the open() system call. This backs out the SQLITE_ACCESS_SYMLINK value but adds the new SQLITE_OK_SYMLINK return code from the xFullPathname method of sqlite3_vfs when that routine resolves symbolic links. O_NOFOLLOW is always included in open() system calls for journal files. check-in: 6a64fb6a2d user: drh tags: trunk
2019-11-21
20:24
Add all fuzz-test cases received from Yongheng Chen and Rui Zhong. Also fix a minor problem in gencol1.test cases. check-in: ac080432b4 user: drh tags: trunk
20:10
Fix an out-of-bounds array reference in the generated column logic. Problem discovered by valgrind. check-in: a0ab42f779 user: drh tags: trunk