/ Timeline
Login

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

50 descendants of [9d418a7a49]

2019-09-26
16:08
Test for an OOM condition in resolveAlias(). check-in: 322eca7f6a user: drh tags: trunk
15:53
Fix a window-functions problem that could occur if an ORDER BY clause contains an alias for a window-function that is not a top-level expression. check-in: 1cc6cf6407 user: dan tags: trunk
2019-09-25
18:44
Add a missing VdbeCoverage() macro. check-in: 36d35dbd5a user: drh tags: trunk
17:47
Remove an unused variable. check-in: a19884455b user: drh tags: trunk
16:41
Further simplifications to window-function code. check-in: 5fe15c1d83 user: dan tags: trunk
11:49
In the previous check-in, the variable should be openMode, not openFlags. check-in: 77b0db22d6 user: drh tags: trunk
10:36
In the unix VFS layer, do not attempt to chown() the journal to be the same as the database if running in 8+3 filename mode. Also, update the comments on the chown() attempt to be more precise. check-in: ab853724a7 user: drh tags: trunk
02:07
Simplifications to the window-function code. check-in: 489a1eb3aa user: drh tags: trunk
2019-09-24
20:20
Bug fixes for window frames of the form (... RANGE BETWEEN b PRECEDING AND a PRECEDING) or (... RANGE a FOLLOWING AND b FOLLOWING) where (a > b). check-in: 040e196a8b user: dan tags: trunk
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:51
Add the SQLITE_SUBTYPE flag, which may be passed to sqlite3_create_window_function() to indicate to the core that the window function may call sqlite3_value_subtype() on its arguments. Closed-Leaf check-in: c12653d3d2 user: dan tags: mistake
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