/ Timeline
Login

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

50 check-ins occurring around 980be1730dc1239c.

2019-09-17
03:16
Fix the instr() SQL function so that it makes a copy of its argument before changing the datatype, since the datatype affects processing. Also fix the sqlite3_value_text() routine so that it always works even for values obtained form sqlite3_value_dup(). Ticket [587791f92620090e] check-in: 3fb40f5180 user: drh tags: trunk
2019-09-16
20:16
Improved type information display when tracing VDBE execution. check-in: ee83d8e30d user: drh tags: trunk
18:19
Do not attempt the LIKE optimization for non-text columns and a pattern prefix of "-". Ticket [0f0428096f17252a] check-in: 6fe0367f9a user: drh tags: trunk
15:15
Add recent interesting cases from dbsqlfuzz. check-in: f06ef3d75d user: drh tags: trunk
14:42
Documentation updates for the SQLITE_DIRECTONLY flag. check-in: 5beb6dc9bc user: drh tags: trunk
12:35
Merge all recent trunk enhancements into the reuse-schema branch. check-in: 27eb223690 user: drh tags: reuse-schema
12:29
Bring the begin-concurrent-pnu-wal2 branch up to date with all the latest enhancements on trunk. check-in: 15593bf3ad user: drh tags: begin-concurrent-pnu-wal2
12:23
Merge recent trunk enhancements into the wal2 branch. check-in: da8bc97412 user: drh tags: wal2
12:17
Merge recent trunk enhancements into the begin-concurrent-pnu branch. check-in: 54930b7e0a user: drh tags: begin-concurrent-pnu
12:08
Merge recent trunk enhancements into the begin-concurrent branch. check-in: 93b9ef3f47 user: drh tags: begin-concurrent
12:02
Merge the latest changes from trunk into the apple-osx branch. check-in: a95191deab user: drh tags: apple-osx
05:34
Fix a problem with processing CTEs that use a WINDOW clause. check-in: ca564d4b5b user: dan tags: trunk
2019-09-14
16:44
Add the --no-rowids option to the ".recover" command. check-in: 01d71b947a user: dan tags: trunk
16:21
Extra comments on fields of the Window object. check-in: 3dbed16251 user: drh tags: trunk
00:21
Fix the windows inverse function on the JSON aggregates. check-in: f464d847af user: drh tags: trunk
2019-09-13
20:42
Fix a problem with using json1 window functions with an EXCLUDE clause. check-in: 4a1978814d user: dan tags: trunk
18:59
Fix the windowB test module so that it works even if SQLite is built without JSON support. check-in: 807975c76b user: drh tags: trunk
18:27
Add the SQLITE_SUBTYPE flag, which may be passed to sqlite3_create_window_function() to indicate that the window function uses sqlite3_value_subtype() to check the sub-type of its arguments. check-in: ba2ebc3a34 user: dan tags: trunk
17:36
Change the meaning of the SQLITE_SUBTYPE flag so that it indicates that the function may use sqlite3_value_subtype() on its arguments. Closed-Leaf check-in: 7f424ec9a3 user: dan tags: window-functions-subtype-fix
17:30
Fix a typo in the carray extension header comment - the comment that serves as the documentation to this extension. check-in: 658a42d363 user: drh tags: trunk
17:05
Change the meaning of the SQLITE_SUBTYPE flag so that it indicates that the user-defined function cares about the subtypes of its arguments. Closed-Leaf check-in: af1bc20f50 user: dan tags: window-functions-subtype-fix2
16:19
Merge latest trunk changes with this branch. check-in: 14ef754346 user: dan tags: window-functions-subtype-fix
13:23
Ensure that the idxStr for FTS5 is always zero-terminated. Fix for check-in [9d418a7a491761ee] check-in: 090cd07d37 user: drh tags: trunk
12:24
Fix harmless compiler warnings. check-in: a8927d14f8 user: drh tags: trunk
2019-09-12
19:38
Allow fts5 to filter on multiple MATCH clauses in a single scan. check-in: 9d418a7a49 user: dan tags: trunk
2019-09-11
15:25
Fix typo for one instance of line number handling in the Lemon tool. check-in: 980be1730d user: mistachkin tags: trunk
2019-09-10
17:51
Enhance treeview to show SOFT-COLLATE for TK_COLLATE operators that omit the EP_Collate flag. check-in: a97804620a user: drh tags: trunk
15:33
Ensure the columns of views and sub-queries maintain their implicit collation sequences when the "push-down" optimization is applied. Fix for [18458b1a]. check-in: 36997c4ade user: dan tags: trunk
2019-09-09
20:17
Ensure the columns of views and sub-selects in the FROM clause of a select are always assigned implicit collation sequences, just as table columns are. Fix for [a7debbe0]. check-in: b9ec72203c user: dan tags: trunk
19:49
Ensure the columns of views and sub-selects in the FROM clause of a select are always assigned implicit collation sequences, just as table columns are. Possible fix for [a7debbe0]. Closed-Leaf check-in: 1863b7bf12 user: dan tags: tkt-a7debbe0.
2019-09-07
18:20
Add the SQLITE_SUBTYPE flag, which can be passed to sqlite3_create_function() and similar to indicate to the core that a user function is likely to use sqlite3_result_subtype(). check-in: 6aa438ce41 user: dan tags: window-functions-subtype-fix
2019-09-04
06:56
Fix handling of NULL, text and blob values in window queries that use "RANGE BETWEEN A FOLLOWING AND B FOLLOWING", or "B PRECEDING AND A PRECEDING", where A>B. check-in: cb3e2be674 user: dan tags: trunk
2019-09-03
19:40
Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. Leaf check-in: b54aa18b0f user: dan tags: branch-3.18
19:29
Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. Leaf check-in: b584fd36f7 user: dan tags: branch-3.9
18:43
Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. Leaf check-in: 0770363b30 user: drh tags: branch-3.19
18:36
Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. Leaf check-in: 68b898381a user: drh tags: branch-3.22
18:04
Disable the undocumented rtreenode() SQL function that is only used for testing, except when doing a build that is specifically intended for testing. check-in: 8452fd5499 user: drh tags: branch-3.22
17:55
Disable the undocumented rtreenode() SQL function that is only used for testing, except when doing a build that is specifically intended for testing. check-in: 34cd2d929e user: drh tags: branch-3.19
17:46
Disable the undocumented rtreenode() SQL function that is only used for testing, except when doing a build that is specifically intended for testing. check-in: 0a1cce496c user: drh tags: branch-3.18
17:39
Disable the undocumented rtreenode() SQL function that is only used for testing, except when doing a build that is specifically intended for testing. check-in: 7b4583f932 user: drh tags: branch-3.9
16:23
Updates to the default settings in Makefile.linux-gcc. check-in: 3044cf6917 user: drh tags: trunk
14:27
When we play games with COLLATE in order to commute an operator in the WHERE clause processing, be sure not to use the commuted operator to qualify a partial index, as insufficient COLLATE information is preserved to verify that the expression will correctly qualify the index. Ticket [767a8cbc6d20bd68] check-in: 5351e920f4 user: drh tags: trunk
2019-09-02
22:13
Fix a bug introduced earlier today by check-in [88833a9c2849c959]. Ticket [29f635e0af71234b] check-in: 6e7b4527d3 user: drh tags: trunk
14:46
Fix a potential crash in fts5 caused by using an auxiliary function on a "special" query like '*id' or '*reads'. check-in: 9490683ae8 user: dan tags: trunk
02:21
When applying the IN_INDEX_NOOP optimization and the LHS has REAL affinity, also apply REAL affinity to each element of the RHS. Ticket [2841e99d104c6436]. check-in: 88833a9c28 user: drh tags: trunk
01:25
Fix an obsolete comment that defines the meaning of one of the parameters to the sqlite3FindInIndex() subroutine. No changes to code. check-in: 0c946f0846 user: drh tags: trunk
00:58
When computing an expression value for an index-on-expression or a CHECK constraint and the expressions uses a REAL table column, but the value of that column is an integer (in other words, when it is using the store-real-as-integer optimization) be sure to promote the value to real before evaluating the expression. Ticket [57af00b6642ecd68]. check-in: 0658c16e31 user: drh tags: trunk
2019-09-01
23:36
Remove an obsolete paragraph from the OP_Column documentation. No code changes. check-in: f6d8956cf8 user: drh tags: trunk
2019-08-31
20:29
Fix a harmless compiler warning. check-in: 63c67a54b4 user: drh tags: trunk
20:26
Mark new VDBE branches never taken. check-in: 83c2adffbf user: drh tags: trunk