Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around 54930b7e0a585d0d.
2019-09-23
| ||
12:38 | Omit the sqlite3IntTokens array constant for a code simplification. check-in: f907395ef5 user: drh tags: trunk | |
11:55 | When a scalar subquery has a pre-existing "LIMIT X" then change it to "LIMIT X<>0" rather than just "LIMIT 1" so that if X is 0 the limit will still be zero. Ticket [99cd4807dc03f178]. Test cases in TH3. check-in: 82e5dcf5c1 user: drh tags: trunk | |
2019-09-21
| ||
18:49 | Fix a harmless unused variable warning in the test logic. check-in: d7673a445f user: drh tags: trunk | |
17:31 | Fix harmless compiler warnings. check-in: 8ea1dc727d user: drh tags: trunk | |
15:44 | Allow SQLite to omit redundant ORDER BY sorts in the case where a SELECT statement has GROUP BY and ORDER BY clauses that use the same expressions, even when the ORDER BY expressions are marked "DESC". check-in: 20f7951bb2 user: dan tags: trunk | |
13:34 | Add --multithread, --serialized, and --singlethread options to the speed-check.sh test script. check-in: c17078af60 user: drh tags: trunk | |
2019-09-20
| ||
21:12 | Simplify the fix in the previous commit. check-in: 5ef64b0f55 user: dan tags: trunk | |
20:52 | Fix a problem with queries containing a min() or max() function for which the FILTER clause excludes all rows. check-in: b1d7e104e0 user: dan tags: trunk | |
2019-09-19
| ||
13:51 | Fix an assert() in fts3 that could fail when accessing a corrupt database. check-in: 601ce9532d user: dan tags: trunk | |
2019-09-18
| ||
20:34 | Always clear the temporary register cache after coding a subroutine. check-in: b6f2a7f9cd user: drh tags: trunk | |
17:22 | Add extra tests for the handling of corrupt records in fts3. check-in: 40e29a47d1 user: dan tags: trunk | |
12:49 | Fix another potential "jump depends on uninitialized value" warning. check-in: 633b214e9b user: drh tags: trunk | |
11:46 | Fix a "jump depends on unititialized value" valgrind error in fts5 triggered by corrupt database records. check-in: 6b6751cd90 user: dan tags: trunk | |
11:16 | Fix an OOB read in the INSTR() function introduced yesterday by check-in [3fb40f518086c1e8] and detected by OSSFuzz. The test case is in TH3. check-in: d49047c1b5 user: drh tags: trunk | |
2019-09-17
| ||
21:28 | Do not change the OP_String8 opcode into OP_String until *after* any necessary encoding conversions are accomplished. Otherwise, a rerun of the prepared statement after an OOM can result in errors. Test case in TH3. check-in: 8efd62594e user: drh tags: trunk | |
13:30 | Test cases for ticket [587791f92620090e] check-in: ca0e3a83a1 user: drh tags: trunk | |
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 | |