Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around af1bc20f502816db.
2019-09-25
| ||
17:47 | Remove an unused variable. (check-in: a1988445 user: drh tags: trunk) | |
16:41 | Further simplifications to window-function code. (check-in: 5fe15c1d user: dan tags: trunk) | |
11:49 | In the previous check-in, the variable should be openMode, not openFlags. (check-in: 77b0db22 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: ab853724 user: drh tags: trunk) | |
02:07 | Simplifications to the window-function code. (check-in: 489a1eb3 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: 040e196a user: dan tags: trunk) | |
2019-09-23
| ||
12:38 | Omit the sqlite3IntTokens array constant for a code simplification. (check-in: f907395e user: drh tags: trunk) | |
11:58 | • Edit [82e5dcf5c1d500ed|82e5dcf5]: Edit check-in comment. (artifact: 888509c1 user: drh) | |
11:55 | • Fixed ticket [99cd4807]: Scalar subquery with "LIMIT 0" should return NULL plus 5 other changes (artifact: 9f208d7d user: drh) | |
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: 82e5dcf5 user: drh tags: trunk) | |
11:44 | • New ticket [99cd4807] Scalar subquery with "LIMIT 0" should return NULL. (artifact: 56f51649 user: drh) | |
2019-09-21
| ||
18:49 | Fix a harmless unused variable warning in the test logic. (check-in: d7673a44 user: drh tags: trunk) | |
17:31 | Fix harmless compiler warnings. (check-in: 8ea1dc72 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: 20f7951b user: dan tags: trunk) | |
13:34 | Add --multithread, --serialized, and --singlethread options to the speed-check.sh test script. (check-in: c17078af user: drh tags: trunk) | |
2019-09-20
| ||
21:12 | Simplify the fix in the previous commit. (check-in: 5ef64b0f 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: b1d7e104 user: dan tags: trunk) | |
2019-09-19
| ||
13:51 | Fix an assert() in fts3 that could fail when accessing a corrupt database. (check-in: 601ce953 user: dan tags: trunk) | |
2019-09-18
| ||
20:34 | Always clear the temporary register cache after coding a subroutine. (check-in: b6f2a7f9 user: drh tags: trunk) | |
17:22 | Add extra tests for the handling of corrupt records in fts3. (check-in: 40e29a47 user: dan tags: trunk) | |
12:49 | Fix another potential "jump depends on uninitialized value" warning. (check-in: 633b214e user: drh tags: trunk) | |
11:46 | Fix a "jump depends on unititialized value" valgrind error in fts5 triggered by corrupt database records. (check-in: 6b6751cd 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: d49047c1 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: 8efd6259 user: drh tags: trunk) | |
13:30 | • Fixed ticket [587791f9]: Row is not fetched when using WHERE clause with INSTR() plus 6 other changes (artifact: d66ce425 user: drh) | |
13:30 | Test cases for ticket [587791f92620090e] (check-in: ca0e3a83 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: 3fb40f51 user: drh tags: trunk) | |
2019-09-16
| ||
20:16 | Improved type information display when tracing VDBE execution. (check-in: ee83d8e3 user: drh tags: trunk) | |
19:25 | • New ticket [587791f9] Row is not fetched when using WHERE clause with INSTR(). (artifact: aff07e7c user: mrigger) | |
18:20 | • Fixed ticket [0f042809]: GLOB unexpectedly does not match plus 6 other changes (artifact: de4655d7 user: drh) | |
18:19 | Do not attempt the LIKE optimization for non-text columns and a pattern prefix of "-". Ticket [0f0428096f17252a] (check-in: 6fe0367f user: drh tags: trunk) | |
15:15 | Add recent interesting cases from dbsqlfuzz. (check-in: f06ef3d7 user: drh tags: trunk) | |
14:42 | Documentation updates for the SQLITE_DIRECTONLY flag. (check-in: 5beb6dc9 user: drh tags: trunk) | |
12:35 | Merge all recent trunk enhancements into the reuse-schema branch. (check-in: 27eb2236 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: 15593bf3 user: drh tags: begin-concurrent-pnu-wal2) | |
12:23 | Merge recent trunk enhancements into the wal2 branch. (check-in: da8bc974 user: drh tags: wal2) | |
12:17 | Merge recent trunk enhancements into the begin-concurrent-pnu branch. (check-in: 54930b7e user: drh tags: begin-concurrent-pnu) | |
12:08 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: 93b9ef3f user: drh tags: begin-concurrent) | |
12:02 | Merge the latest changes from trunk into the apple-osx branch. (check-in: a95191de user: drh tags: apple-osx) | |
05:34 | Fix a problem with processing CTEs that use a WINDOW clause. (check-in: ca564d4b user: dan tags: trunk) | |
2019-09-14
| ||
16:44 | Add the --no-rowids option to the ".recover" command. (check-in: 01d71b94 user: dan tags: trunk) | |
16:21 | Extra comments on fields of the Window object. (check-in: 3dbed162 user: drh tags: trunk) | |
00:21 | Fix the windows inverse function on the JSON aggregates. (check-in: f464d847 user: drh tags: trunk) | |
2019-09-13
| ||
20:42 | Fix a problem with using json1 window functions with an EXCLUDE clause. (check-in: 4a197881 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: 807975c7 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: ba2ebc3a user: dan tags: trunk) | |
18:25 | • Edit [c12653d3d2383fcd|c12653d3]: Move to branch mistake. Add propagating "hidden". Mark "Closed". (artifact: f45c94e5 user: dan) | |
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: 7f424ec9 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: 658a42d3 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: af1bc20f user: dan tags: window-functions-subtype-fix2) | |
16:19 | Merge latest trunk changes with this branch. (check-in: 14ef7543 user: dan tags: window-functions-subtype-fix) | |
13:24 | • Edit [090cd07d37904da4|090cd07d]: Edit check-in comment. (artifact: 58bdd27b user: drh) | |
13:23 | Ensure that the idxStr for FTS5 is always zero-terminated. Fix for check-in [9d418a7a491761ee] (check-in: 090cd07d user: drh tags: trunk) | |
12:24 | Fix harmless compiler warnings. (check-in: a8927d14 user: drh tags: trunk) | |
2019-09-12
| ||
19:38 | Allow fts5 to filter on multiple MATCH clauses in a single scan. (check-in: 9d418a7a user: dan tags: trunk) | |
2019-09-11
| ||
15:25 | Fix typo for one instance of line number handling in the Lemon tool. (check-in: 980be173 user: mistachkin tags: trunk) | |
11:30 | • Closed ticket [18458b1a]: COLLATE issue in view plus 4 other changes (artifact: a3867649 user: dan) | |
2019-09-10
| ||
19:46 | • Closed ticket [c4130c33]: DISTINCT malfunctions for VIEW plus 6 other changes (artifact: 419e98d5 user: drh) ... 1 similar event omitted. | |
17:51 | Enhance treeview to show SOFT-COLLATE for TK_COLLATE operators that omit the EP_Collate flag. (check-in: a9780462 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: 36997c4a user: dan tags: trunk) | |
07:50 | • Ticket [18458b1a] COLLATE issue in view status still Open with 7 other changes (artifact: 7a5fee4d user: drh) ... 1 similar event omitted. | |
2019-09-09
| ||
20:18 | • Closed ticket [a7debbe0]: BETWEEN issue in view plus 6 other changes (artifact: 2c6a62d6 user: dan) | |
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: b9ec7220 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: 1863b7bf user: dan tags: tkt-a7debbe0.) | |
2019-09-07
| ||
18:51 | • New ticket [a7debbe0] BETWEEN issue in view. (artifact: fea928c9 user: mrigger) | |
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: 6aa438ce 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: cb3e2be6 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: b54aa18b 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: b584fd36 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: 0770363b user: drh tags: branch-3.19) | |
18:36 | Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. (check-in: 68b89838 user: drh tags: branch-3.22) | |
18:23 | • New ticket [0f042809] GLOB unexpectedly does not match. (artifact: 6afdb361 user: mrigger) | |
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: 8452fd54 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: 34cd2d92 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: 0a1cce49 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: 7b4583f9 user: drh tags: branch-3.9) | |
16:23 | Updates to the default settings in Makefile.linux-gcc. (check-in: 3044cf69 user: drh tags: trunk) | |
14:27 | • Fixed ticket [767a8cbc]: COLLATE NOCASE string comparison yields incorrect result plus 6 other changes (artifact: 126c7225 user: drh) | |
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: 5351e920 user: drh tags: trunk) | |
13:35 | • Fixed ticket [29f635e0]: IS NULL unexpectedly evaluates to TRUE plus 6 other changes (artifact: be050867 user: drh) | |
08:25 | • New ticket [767a8cbc] COLLATE NOCASE string comparison yields incorrect result. (artifact: b41bd360 user: mrigger) | |
2019-09-02
| ||
22:14 | • Fixed ticket [29f635e0]: IS NULL unexpectedly evaluates to TRUE plus 7 other changes (artifact: 781749e7 user: drh) | |
22:13 | Fix a bug introduced earlier today by check-in [88833a9c2849c959]. Ticket [29f635e0af71234b] (check-in: 6e7b4527 user: drh tags: trunk) | |
19:22 | • New ticket [29f635e0] IS NULL unexpectedly evaluates to TRUE. (artifact: 34ebd7c7 user: mrigger) | |
14:46 | Fix a potential crash in fts5 caused by using an auxiliary function on a "special" query like '*id' or '*reads'. (check-in: 9490683a user: dan tags: trunk) | |
02:22 | • Fixed ticket [2841e99d]: Different rounding when converting TEXT to REAL plus 6 other changes (artifact: 59028a40 user: drh) | |
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: 88833a9c 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: 0c946f08 user: drh tags: trunk) | |
00:58 | • Fixed ticket [57af00b6]: Expression computed on row yields incorrect result plus 4 other changes (artifact: 608fe566 user: drh) | |
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: 0658c16e user: drh tags: trunk) | |
2019-09-01
| ||
23:36 | Remove an obsolete paragraph from the OP_Column documentation. No code changes. (check-in: f6d8956c user: drh tags: trunk) | |
19:46 | • Ticket [57af00b6] Expression computed on row yields incorrect result status still Open with 6 other changes (artifact: 14089bcd user: drh) | |
18:44 | • New ticket [2841e99d] Different rounding when converting TEXT to REAL. (artifact: 08df019d user: mrigger) | |
16:02 | • New ticket [57af00b6] Expression computed on row yields incorrect result. (artifact: ece608d0 user: mrigger) | |
2019-08-31
| ||
20:29 | Fix a harmless compiler warning. (check-in: 63c67a54 user: drh tags: trunk) | |
20:26 | Mark new VDBE branches never taken. (check-in: 83c2adff user: drh tags: trunk) | |
20:13 | Improvements to the algorithm that determines which SELECT in a sequence of nested SELECT statements that an aggregate function belongs to. This resolves an issue identified by dbsqlfuzz. (check-in: d7680074 user: drh tags: trunk) | |
17:15 | • Closed ticket [d6a0fbc1]: REINDEX causes "UNIQUE constraint failed" error when using TRIGGER plus 6 other changes (artifact: 9c168f35 user: dan) | |