Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
76 events for the month beginning 2019-08-01 by user dan
Following month ↑|
2019-08-31
| ||
| 17:15 | • Closed ticket [d6a0fbc1]: REINDEX causes "UNIQUE constraint failed" error when using TRIGGER plus 6 other changes (artifact: 9c168f35 user: dan) | |
| 17:14 | If a DELETE trigger fired by an UPDATE OR REPLACE statement deletes the row being updated, do not attempt to proceed with the original UPDATE operation. Fix for [d6a0fbc1]. (check-in: 4145b3e0 user: dan tags: trunk) | |
|
2019-08-30
| ||
| 19:45 | Add test case to window8.test. Also fix an error in a comment in window.c. (check-in: 2925bfa5 user: dan tags: trunk) | |
| 17:28 | Add further comments to window.c. (check-in: 90046456 user: dan tags: trunk) | |
| 16:14 | Fix a bug in RANGE window functions that use "ORDER BY <expr> DESC NULLS FIRST" as the window-frame ORDER BY clause. (check-in: 39b4cad4 user: dan tags: trunk) | |
|
2019-08-29
| ||
| 21:16 | Improve vdbe branch coverage of NULLS LAST code. (check-in: e8e9f77d user: dan tags: trunk) | |
| 19:34 | Fix other problems similar to ticket [c0390363]. (check-in: 96ff2ba9 user: dan tags: trunk) | |
| 15:50 | Fix another case where SQLite assumes that if "~(? AND FALSE)" is true, "?" must be non-null. (check-in: 616f5663 user: dan tags: trunk) | |
| 15:48 | • Edit [84ae41fd2f50cb7c|84ae41fd]: Edit check-in comment. (artifact: 1ab67b0d user: dan) | |
| 15:07 | • Closed ticket [c0390363]: Indexes causes row to not be fetched plus 6 other changes (artifact: f038f6f7 user: dan) | |
| 15:06 | Avoid assuming that for "~ (? AND FALSE)" to be true, "?" must not be NULL, just as we do for "NOT (? AND FALSE)". Fix for ticket [c0390363]. (check-in: 84ae41fd user: dan tags: trunk) | |
| 14:25 | Fix a potential buffer overrun in fts5 caused by corrupted database records. (check-in: c465d0eb user: dan tags: trunk) | |
|
2019-08-27
| ||
| 20:00 | • Closed ticket [f8a7060e]: Incorrect result for query that uses MIN() and a CAST on rowid plus 4 other changes (artifact: 400f3bdf user: dan) | |
| 19:59 | Add support for "ORDER BY ... NULLS FIRST" and "ORDER BY ... NULLS LAST". Use this to fix ticket [f8a7060e]. (check-in: 94085fb3 user: dan tags: trunk) | |
| 09:42 | • New ticket [ac8dd4a3] Segfault when dropping a temp trigger on a database that has already been detached. (artifact: 719304a8 user: dan) | |
|
2019-08-26
| ||
| 14:57 | Tweak the shell tool ".recover" command so that it can recover rows that consist of a rowid and no fields. (check-in: 279ac7fd user: dan tags: trunk) | |
|
2019-08-24
| ||
| 21:02 | Minor performance improvement for balance_nonroot(). (check-in: d7434cae user: dan tags: trunk) | |
| 21:01 | • Edit [c88d42a921edd00f|c88d42a9]: Move to branch mistake. Add propagating "hidden". Mark "Closed". (artifact: bca6da14 user: dan) | |
| 17:11 | Fix a potential buffer overrun in fts5 caused by corrupt database records. (check-in: 156d6128 user: dan tags: trunk) | |
|
2019-08-23
| ||
| 20:33 | Move some things in parse.y so that TK_COLUMN and TK_AGG_COLUMN are assigned the same values as they are on trunk for a very small speedup. (check-in: d26fdfa3 user: dan tags: nulls-last) | |
|
2019-08-21
| ||
| 19:58 | Add missing VdbeCoverage() macros to new code. (check-in: b1cbcdc6 user: dan tags: nulls-last) | |
| 17:46 | Disable broken test case in expert1.test. (check-in: 73e30c2e user: dan tags: nulls-last) | |
| 15:41 | Update this branch with latest trunk changes. (check-in: 6153bcf4 user: dan tags: nulls-last) | |
| 14:55 | • Closed ticket [b8689402]: DISTINCT malfunctions for IS NULL plus 6 other changes (artifact: e33394d3 user: dan) | |
| 14:54 | Avoid assuming that "column IS ?", where column is declared UNIQUE, matches only a single row (as "?" might be NULL). Fix for [b8689402]. (check-in: d02490a2 user: dan tags: trunk) | |
| 11:31 | Fix a broken assert() in the fts3 snippet code that was failing for queries containging more than 64 phrases. (check-in: 4c01e017 user: dan tags: trunk) | |
|
2019-08-20
| ||
| 20:09 | Further tests for the special null-handling on this branch. (check-in: 0dbbb51f user: dan tags: nulls-last) | |
| 19:11 | Fix a problem with fts5 "ORDER BY rank" queries when the fts5 table name requires quoting. (check-in: 00e9a8f2 user: dan tags: trunk) | |
| 17:51 | Add tests for sort-by-index cases that use IN() and non-default NULL handling. (check-in: 09d660ec user: dan tags: nulls-last) | |
| 15:47 | Do not pass ORDER BY clauses with non-standard NULL handling to virtual table implementations. (check-in: a9a82ee8 user: dan tags: nulls-last) | |
| 14:43 | Fix a segfault that could occur following an OOM while processing a SELECT statement for which one or more of the expressions in the window frame declaration are themselves sub-selects that use window functions. (check-in: 75aec4fc user: dan tags: trunk) | |
| 11:45 | • Closed ticket [f043b113]: INDEXED BY results in row not being fetched plus 6 other changes (artifact: 2bf8bb52 user: dan) | |
| 11:43 | Retain the affinity of an expression in a WHERE clause when it is transformed to a reference to an index column on the same expression. Fix for [f043b113]. (check-in: 511da081 user: dan tags: trunk) | |
|
2019-08-19
| ||
| 19:59 | Fix problems with window frames that use ORDER BY ... NULLS LAST etc. (check-in: 75d665a4 user: dan tags: nulls-last) | |
| 17:26 | Prevent NULLS FIRST/LAST from being used in CREATE INDEX and other statements. (check-in: bb9767a2 user: dan tags: nulls-last) | |
|
2019-08-17
| ||
| 19:58 | Add some extra tests for the lsm virtual table module. (check-in: 4cb009b0 user: dan tags: trunk) | |
| 19:14 | • Closed ticket [c7a11719]: WHERE clause erroneously influences value of fetched column from view plus 6 other changes (artifact: fba835a5 user: dan) | |
| 19:13 | When populating an ephemeral b-tree for the RHS of an IN(...) clause, avoid applying an affinity to a value that may be used later on for some other purpose. Fix for [c7a117190]. (check-in: 43e8b143 user: dan tags: trunk) | |
| 18:16 | Add tests to ensure that this branch really does fix ticket [f8a7060ece]. (check-in: f8920664 user: dan tags: nulls-last) | |
| 17:55 | Fix problem with DESC indexes on this branch. (check-in: b49df1fe user: dan tags: nulls-last) | |
| 15:47 | Merge trunk changes into this branch. (check-in: db1e6080 user: dan tags: nulls-last) | |
|
2019-08-16
| ||
| 21:07 | Add support for using indexes for some ORDER BY clauses that use non-default NULL handling. Still some problems on this branch. (check-in: 81069d71 user: dan tags: nulls-last) | |
|
2019-08-15
| ||
| 14:09 | • Ticket [256741a1] null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...) status still Open with 6 other changes (artifact: 6fef4d64 user: dan) | |
| 13:53 | Ensure that SQLite does not attempt to process incompatible window functions in a single scan. Fix for [256741a1]. (check-in: 4f5b2d93 user: dan tags: trunk) | |
| 13:51 | • New ticket [256741a1] null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...). (artifact: ef08d208 user: dan) | |
|
2019-08-14
| ||
| 19:55 | • Closed ticket [17db54d7]: Unexpected error in DELETE with existing trigger plus 6 other changes (artifact: dd9f8d3e user: dan) | |
|
2019-08-13
| ||
| 17:56 | Update test cases so that they work with ICU enabled. (check-in: 408144a1 user: dan tags: trunk) | |
| 17:27 | Update some corruption test cases to take [724f4df9c] into account. (check-in: 927cd7b4 user: dan tags: trunk) | |
| 15:22 | Merge latest trunk changes with this branch. (check-in: 5b4689d8 user: dan tags: reuse-schema) | |
| 15:11 | Fix a problem with RBU function sqlite3rbu_bp_progress() when used during an RBU vacuum. (check-in: 8c44b02f user: dan tags: trunk) | |
|
2019-08-12
| ||
| 16:36 | Experimental implementation of NULLS FIRST/LAST. This branch still has problems - the most significant of which is that ORDER BY clauses with a non-default NULLS FIRST/LAST qualifier can never use an index. (check-in: 07babb0f user: dan tags: nulls-last) | |
|
2019-08-10
| ||
| 14:35 | Add extra test cases related to the previous commit. (check-in: 3c690b2b user: dan tags: trunk) | |
|
2019-08-09
| ||
| 14:54 | In shared-schema mode, handle the case where a connection has created a virtual-table object, but is later assigned a different shared-schema object for which the virtual-table schema has not yet been initialized. (check-in: e30c7414 user: dan tags: reuse-schema) | |
|
2019-08-08
| ||
| 15:47 | Fix spurious "no such table: x1" errors in shared-schema mode that could occur when a query that is a join across two or more databases needs to call the xConnect() methods of a virtual table. (check-in: edf45cd7 user: dan tags: reuse-schema) | |
| 11:44 | Fix a bug causing "no such table" and other similar sqlite3_prepare*() errors to return SQLITE_SCHEMA instead of SQLITE_ERROR in shared-schema mode when there is an attached database for which the schema has never been loaded. (check-in: 111e2c73 user: dan tags: reuse-schema) | |
| 08:31 | • Ticket [f8a7060e] Incorrect result for query that uses MIN() and a CAST on rowid status still Open with 3 other changes (artifact: 64317f51 user: dan) | |
|
2019-08-07
| ||
| 19:57 | Remove use of the affinity() function from view.test, as it is only available in SQLITE_DEBUG builds. (check-in: 7f2246a1 user: dan tags: trunk) | |
| 18:34 | Add "set TMP=%CD%" to the start of each msvc script output by releasetest_data.tcl. Otherwise, since binaries compiled with SQLITE_TEST all choose the same sequence of pseudo-random numbers, collisions between temp file names cause errors when running multiple tests in parallel. (check-in: f5d0436d user: dan tags: trunk) | |
| 17:45 | Eliminate some more cases of redundant sorting in window-function queries. (check-in: 8158d2ac user: dan tags: trunk) | |
|
2019-08-06
| ||
| 21:16 | Ensure that when the col in an operator like "val IN(col)" is a column of a view, its affinity is not used to coerce val. Fix for [0a5e2c1d]. (check-in: 17b3d221 user: dan tags: trunk) | |
| 18:40 | Add "PRAGMA foreign_keys=OFF;" to the start of the script output by ".recover", just as is done for ".dump". (check-in: bfc29e62 user: dan tags: trunk) | |
| 15:02 | Add a multi-threaded test to threadtest3.c for the feature on this branch. (check-in: 62557fab user: dan tags: reuse-schema) | |
| 11:45 | Add an assert() to the code on this branch. (check-in: fdd44bbb user: dan tags: reuse-schema) | |
|
2019-08-05
| ||
| 20:53 | Ensure that columns of views and sub-queries that are expressions with no affinity are not assigned BLOB affinity. This matches the documentation. Fix for [61c853857f40da49]. (On a branch because there are still subtle issues.) (check-in: e15a0977 user: dan tags: pending) | |
| 20:45 | Add test cases to this branch. (Closed-Leaf check-in: f37317d8 user: dan tags: tkt-61c853-A) | |
| 19:44 | Fix the patch on this branch so that it works with sub-queries, as well as views. (check-in: 7480db30 user: dan tags: tkt-61c853-A) | |
| 13:19 | Fix a problem with renaming a table when a view or trigger within the schema uses a FILTER with an aggregate function that is not currently registered with the database. (check-in: 2ac0e42f user: dan tags: trunk) | |
| 12:55 | Prevent an fts5 table from being its own content table, or part of a view that is the content table. (check-in: b6d52c93 user: dan tags: trunk) | |
|
2019-08-03
| ||
| 16:51 | • Closed ticket [71e183ca]: MIN() malfunctions for a query with ISNULL condition plus 4 other changes (artifact: 3dfda9a4 user: dan) | |
| 16:37 | Fix a problem with queries of the form "SELECT min(<expr>) ... WHERE <expr>=?" where there is an index on <expr>. Fix for [71e183ca]. (check-in: d465c3ee user: dan tags: trunk) | |
| 13:44 | • Ticket [71e183ca] MIN() malfunctions for a query with ISNULL condition status still Open with 6 other changes (artifact: 6226b177 user: dan) | |
|
2019-08-02
| ||
| 19:40 | • Closed ticket [41866dc3]: MIN() malfunctions for UNIQUE column plus 6 other changes (artifact: 7206ad61 user: dan) | |
| 19:40 | If a query like "SELECT min(a), b FROM t1" visits no rows where "a" is not null, extract a value for "b" from one of the rows where "a" is null. Fix for ticket [41866dc37]. (check-in: faaaae49 user: dan tags: trunk) | |
| 18:43 | If a query like "SELECT min(a), b FROM t1" visits no rows where "a" is not null, extract a value for "b" from one of the rows where "a" is null. Possible fix for ticket [41866dc37]. (Closed-Leaf check-in: a7277ed0 user: dan tags: tkt-41866dc37) | |
|
2019-08-01
| ||
| 15:18 | Add new release tests for windows to releasetest_data.tcl. (check-in: 1b330ec2 user: dan tags: trunk) | |
| 10:58 | Fix a problem in ALTER TABLE triggered by views or triggers that include the construction "ORDER BY true" or "ORDER BY false". (check-in: 8168021f user: dan tags: trunk) | |