Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
106 events for the month beginning 2022-05-01 by user drh
Following month ↑|
2022-05-31
| ||
| 18:18 | New FULL JOIN test cases. No changes to code. (check-in: 13e89ef6 user: drh tags: trunk) | |
| 17:24 | More JOIN test cases inspired by the problem fixed in [3869fd9a2b9483cb]. (check-in: f2d224c5 user: drh tags: trunk) | |
| 15:18 | Fix an assert that is incorrect for a corrupt database. (check-in: fe0a8408 user: drh tags: trunk) | |
| 14:19 | Many new PG-confirmed test cases in joinD.test. (check-in: 481e89c7 user: drh tags: trunk) | |
| 11:22 | Restore an ON-clause test case (removed by [3869fd9a2b9483cb]) that turns out to be necessary for correct operation. Fix for forum post c2554d560bac97c5. (check-in: f407ec67 user: drh tags: trunk) | |
| 11:13 | Add back in a test case for ON-clauses that was removed yesterday by [3869fd9a2b9483cbf] but which turned out to be necessary after all. (Closed-Leaf check-in: aba52a90 user: drh tags: right-join-bug-20220531) | |
| 10:48 | Add test cases for forum post c2554d560bac97c5. (check-in: e66d5ae8 user: drh tags: right-join-bug-20220531) | |
|
2022-05-30
| ||
| 17:33 | For an outer join, then ON-clause constraints need to be evaluated at just the right moment - not too early and not too late. Fix for the problem reported by forum post 3902c7b833. (check-in: 3869fd9a user: drh tags: trunk) | |
|
2022-05-28
| ||
| 15:01 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 4d46296e user: drh tags: reuse-schema) | |
| 14:51 | Merge the latest trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: 4d65f45b user: drh tags: begin-concurrent-pnu-wal2) | |
| 14:44 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 934656f1 user: drh tags: wal2) | |
| 14:32 | Merge the latest trunk enhancements into the begin-concurrent-report branch. (check-in: 034d2c51 user: drh tags: begin-concurrent-report) | |
| 14:25 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: d6f6ee5c user: drh tags: begin-concurrent) | |
| 14:03 | Apply the UPDATE-FROM file from check-in [98b3816bbaf539ea] to update-delete-limit builds. (check-in: 7e87892c user: drh tags: trunk) | |
|
2022-05-27
| ||
| 18:06 | Mark an always-true conditional as ALWAYS(). (check-in: 3492fe8a user: drh tags: trunk) | |
| 17:36 | Minor simplification to ALTER TABLE logic. (check-in: 01beb036 user: drh tags: trunk) | |
| 14:41 | Omit an unnecessary branch. (check-in: f56473f9 user: drh tags: trunk) | |
|
2022-05-26
| ||
| 17:33 | Correct handling of outer joins in the FROM clause of an UPDATE statement that occurs inside of a trigger. Follow-on to [98b3816bbaf539ea]. (check-in: 664a49fa user: drh tags: trunk) | |
| 14:46 | Clarification of the meaning of the N parameter in sqlite3_db_name(). Documentation only. No changes to code. (check-in: f22f41d2 user: drh tags: trunk) | |
|
2022-05-25
| ||
| 13:10 | Slight increase in the accuracy of log10(). (check-in: c48a735b user: drh tags: trunk) | |
| 12:49 | Do not allow the right operand of a RIGHT JOIN to be reordered with other FROM clause terms that are even further to the right. Fix for the issue identified by forum post 5cfe08eed6. (check-in: 4be0c60e user: drh tags: trunk) | |
| 11:17 | Add in a VdbeCoverage() macro accidentally omitted from [d64ae49a1f251317]. (check-in: 18b5cea0 user: drh tags: trunk) | |
| 11:09 | Fix the UPDATE-FROM logic so that it works the same as PostgreSQL when the FROM clause contains an outer join. (check-in: 98b3816b user: drh tags: trunk) | |
| 02:32 | An attempt to get UPDATE FROM working when the FROM clause contains a RIGHT or FULL JOIN. (Closed-Leaf check-in: a124e4f9 user: drh tags: update-from-right-join) | |
|
2022-05-24
| ||
| 16:05 | When an ON clause on an INNER JOIN references a table to the right of of the join, just convert the ON clause to an ordinary WHERE clause term, in order to be compatible with older versions of SQLite. See forum thread 687b0bf563a1d4f1 for details. (check-in: 2b6ebba2 user: drh tags: trunk) | |
|
2022-05-23
| ||
| 12:37 | New test cases to further demonstrate the difference in name matching rules for LEFT JOIN versus RIGHT JOIN that protect legacy behavior. Forum thread e90a8e6e6fa652ac. (check-in: 2c586060 user: drh tags: trunk) | |
| 11:51 | Add an assert() to clear a harmless static-analyzer warning. (check-in: 919ba2f0 user: drh tags: trunk) | |
| 10:57 | Do not run the subroutine that materializes a view or subquery until just before the materialization is actually needed, so that if the materialization turns out to never been needed, unnecessary work can be avoided. (check-in: d64ae49a user: drh tags: trunk) | |
|
2022-05-21
| ||
| 18:03 | Defer materializing a view or subquery until the materialization is actually needed, so that if it is not needed, not useless work is performed. (Closed-Leaf check-in: 16bf3506 user: drh tags: deferred-materialize) | |
| 15:54 | Fix a typo in a comment. (check-in: 34d7045b user: drh tags: deferred-materialize) | |
| 15:12 | Use the newer OP_BeginSubrtn opcode instead of OP_Integer to start the subroutine used to matrialize a view. This does not change execution but does make the byte code a little easier to read. (check-in: cebd4fd6 user: drh tags: deferred-materialize) | |
|
2022-05-19
| ||
| 16:59 | Merge the changes to support the "fiddle" extension. (check-in: 58585f01 user: drh tags: trunk) | |
| 16:42 | Tweaks to the fiddle make target so that it builds with all of the same extensions as the standard CLI. (check-in: d46a6cb9 user: drh tags: fiddle) | |
|
2022-05-18
| ||
| 20:44 | Experimental code to provide a SIZE_HINT when writing the -wal file. (Leaf check-in: 3b29080d user: drh tags: wal-size-hint) | |
|
2022-05-17
| ||
| 15:33 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 495f0353 user: drh tags: reuse-schema) | |
| 15:11 | Fix harmless compiler warnings in the new unixFullPathname implementation. (check-in: f7e1ceb5 user: drh tags: trunk) | |
| 14:59 | Add the sqlite3_db_name() interface. (check-in: 2ad15223 user: drh tags: trunk) | |
|
2022-05-14
| ||
| 19:05 | Do not allow an index scan on an index-on-expression for a RIGHT JOIN because the index might not be positioned on the correct row when running the the right-join no-match loop. dbsqlfuzz 39ee60004ff027a9e2846cf76e02cd5ac0953739 (check-in: 2277f9ba user: drh tags: trunk) | |
| 17:40 | Improved debugging comment generation for the OP_Column opcode. (check-in: 3e073bfd user: drh tags: trunk) | |
| 15:59 | Improvements to the decision of when to check ON constraints for an inner join that is an operand to a RIGHT JOIN. Fix for issue identify by forum post c06b10ad7e. (check-in: 9d17233c user: drh tags: trunk) | |
|
2022-05-13
| ||
| 23:01 | Change an unreachable branch into an assert(). (check-in: 778e57a5 user: drh tags: trunk) | |
| 20:11 | Transitive equality constriants do not work on a RIGHT JOIN, since the right-hand side might be a non-matched row. (check-in: 0f96810b user: drh tags: trunk) | |
| 19:50 | Walk back the optimization from check-in [cc458317bd77046c] that tries to reuse the same ephemeral cursor of a list subquery when that subquery is reused, as it does not work in cases where the list subquery is used both for lookups and for scans. (check-in: 12ee29d6 user: drh tags: trunk) | |
| 17:45 | Defer generating WHERE clause constraints for a RIGHT JOIN until after the ON-clause processing for the RIGHT JOIN has done its own row elimination. This fixes and incorrect output from some RIGHT JOINs that was identified by forum post 41cc3851d864c5e6. (check-in: 238d9c24 user: drh tags: trunk) | |
| 16:38 | Redefine the acccess rules for the Expr.w union so that the Expr.w.iJoin member is accessible on either EP_OuterON or EP_InnerON. (check-in: 6f741d6c user: drh tags: trunk) | |
| 15:36 | Corrections to the header comment to the new joinE.test script. Add the generator TCL as a comment at the bottom of the script. (check-in: 2f4456f6 user: drh tags: trunk) | |
| 15:31 | New test cases for outer joins. Case joinE-32 currently gets an incorrect answer. See forum post 41cc3851d8 for the bug report. (check-in: 02b24863 user: drh tags: trunk) | |
| 14:52 | Improved names for flags on the Expr object: EP_FromJoin becames EP_OuterON and EP_InnerJoin becomes EP_InnerON. (check-in: 1ffea07f user: drh tags: trunk) | |
|
2022-05-12
| ||
| 17:09 | Fix a harmless compiler warning in the CLI. (check-in: 7a2ac303 user: drh tags: trunk) | |
| 11:56 | Ensure that ON clauses are applied to the correct outer join. (check-in: c7e3a13a user: drh tags: trunk) | |
| 11:45 | Add IS NOT DISTINCT FROM and IS DISTINCT FROM binary operators which are equivalent to IS and IS NOT, respectively, for compatability with PostgreSQL and hence standard SQL. (check-in: db27611e user: drh tags: trunk) | |
| 11:01 | Fix the ".echo" command of the CLI so that it shows the results of input lines immediately, before invoking sqlite3_prepare(). (check-in: cf7fdabd user: drh tags: trunk) | |
|
2022-05-11
| ||
| 17:57 | The unix interface now resolves all symbolic links in filenames before actually using those filenames. (check-in: d55273e3 user: drh tags: trunk) | |
| 17:45 | Use osReadlink() in os_unix.c, not readlink() directly. (Closed-Leaf check-in: c3da4c16 user: drh tags: resolve-symlinks) | |
| 16:46 | For the unix VFS, rewrite the xFullPathname method so that it automatically resolves all symbolic links, rendering a canonical pathname that contains no symlinks. (check-in: 40c9273d user: drh tags: resolve-symlinks) | |
|
2022-05-10
| ||
| 23:28 | Fix a bug in the sqlite3WhereMalloc() routines that were added by chekc-in [f237e1d8cc41b937]. The bug was detected by dbsqlfuzz test case 4c5e3e89bc251d28378be88233f531b84ec66901. (check-in: 764b7126 user: drh tags: trunk) | |
| 18:43 | New requirement marks. (check-in: e8479e56 user: drh tags: trunk) | |
| 18:18 | Fix a stale requirement mark. (check-in: fcda7fb1 user: drh tags: trunk) | |
| 17:42 | Fix a stale requirement mark. (check-in: 3eda4030 user: drh tags: echo-sql) | |
| 15:55 | Fix a harmless UBSAN warning. (check-in: 8f935502 user: drh tags: trunk) | |
| 13:06 | Merge all recent trunk changes into the reuse-schema branch. (check-in: 9f6d6e61 user: drh tags: reuse-schema) | |
| 12:45 | Merge the latest trunk enhancements into theh begin-concurrent-pnu-wal2 branch. (check-in: d28af1f8 user: drh tags: begin-concurrent-pnu-wal2) | |
| 12:39 | Merge recent trunk enhancements into the wal2 branch. (check-in: 33d77fea user: drh tags: wal2) | |
| 12:25 | • Edit [c4a61135d5c8a161|c4a61135]: Move to branch begin-concurrent-report-3.28. (artifact: 006ea93d user: drh) | |
| 12:24 | Merge the latest trunk enhancements into the begin-concurrent-report branch. Had to restore the sqlite3VdbeSerialPut() routine that was removed in check-in [6f4d6f212a3558c2] when it was inlined because that routine is used again in a different place by this branch. (check-in: e6b5224d user: drh tags: begin-concurrent-report) | |
| 12:00 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: f65bd767 user: drh tags: begin-concurrent) | |
| 00:24 | Simplified "hidden" and "no-expand" handling in the *-expander. (check-in: c6c3115f user: drh tags: trunk) | |
|
2022-05-09
| ||
| 17:55 | Minor STAT4 test case change due to the ANALYZE enhancement of [eb59c46a5aed69bc|check-in eb59c46a5aed69bc]. (check-in: 8ce2fecb user: drh tags: trunk) | |
| 16:29 | Add ALWAYS() on two unreachable branches in the * expander. (check-in: 387c8523 user: drh tags: trunk) | |
| 12:59 | Simplify a branch in the "*" expansion logic. New test case for an INSTEAD OF trigger on a RIGHT and FULL outer join. (check-in: d2717348 user: drh tags: trunk) | |
|
2022-05-06
| ||
| 22:29 | Perserve the requested reserved-bytes size for the database file when doing a VACUUM. (check-in: dac6d87c user: drh tags: trunk) | |
| 17:06 | Merge the 3.38.5 fix into the 3.38 subbranch of reuse-schema. (Leaf check-in: bfccca2b user: drh tags: reuse-schema-3.38) | |
| 16:52 | Merge the 3.38.5 fix into the begin-concurrent-wal2 subbranch for 3.38. (Leaf check-in: 0586b3e9 user: drh tags: begin-concurrent-wal2-3.38) | |
| 15:25 | Version 3.38.5 (Leaf check-in: 78d9c993 user: drh tags: release, version-3.38.5, branch-3.38) | |
| 01:02 | Prevent an infinite loop on SQLITE_ERROR_RETRY when trying to modify a corrupt schema while PRAGMA writeable_schema=ON is active. dbsqlfuzz ded83609f475cc989c7339d45efb5151c1495501 (check-in: 7fcdb760 user: drh tags: branch-3.38) | |
| 00:43 | Prevent an infinite loop on SQLITE_ERROR_RETRY when trying to modify a corrupt schema while PRAGMA writeable_schema=ON is active. dbsqlfuzz ded83609f475cc989c7339d45efb5151c1495501 (check-in: 217b3323 user: drh tags: trunk) | |
|
2022-05-05
| ||
| 10:04 | Update the version number to 3.38.5 (check-in: bf73b57f user: drh tags: branch-3.38) | |
| 10:03 | Backout check-in [9fb20a21feb8f697] which was incorrect. (check-in: 66f65b32 user: drh tags: branch-3.38) | |
| 10:02 | Backout check-in [9fb20a21feb8f697] which was incorrect. (check-in: 99225618 user: drh tags: trunk) | |
|
2022-05-04
| ||
| 18:43 | Improvements for name resolution for parenthsized joins. (check-in: 006b2d9c user: drh tags: trunk) | |
| 17:43 | New test cases for RIGHT and FULL JOIN, focusing on cases that make use of Bloom filters, and a bug fix related to when ON-clause constraints are applied. (check-in: 67510354 user: drh tags: trunk) | |
| 17:30 | Code EP_InnerJoin constraints at the same time that EP_FromJoin constraints are coded. (Closed-Leaf check-in: b57033d2 user: drh tags: joinD) | |
| 16:46 | Merge version-3.38.4 into the reuse-schema-3.38 subbranch. (check-in: d5b0fd84 user: drh tags: reuse-schema-3.38) | |
| 16:36 | Merge the version 3.38.4 fixes into the begin-concurrent-wal2-3.38 branch. (check-in: 8473718d user: drh tags: begin-concurrent-wal2-3.38) | |
| 15:45 | Version 3.38.4 (check-in: d402f498 user: drh tags: release, version-3.38.4, branch-3.38) | |
| 14:46 | Merge ON-clause constraint usage fix from trunk into the joinD branch. (check-in: 0a20d4a8 user: drh tags: joinD) | |
| 14:45 | Fix ON-clause constraint usage for FULL and RIGHT JOINs. (check-in: 544268a7 user: drh tags: trunk) | |
| 11:49 | New test cases using various join types and Bloom filters. Two cases differ from PG and need to be resolved. (check-in: befa8cbc user: drh tags: joinD) | |
| 02:01 | In the query planner, do not let tables commute across any outer join. (check-in: 8cee5388 user: drh tags: trunk) | |
|
2022-05-03
| ||
| 16:26 | Merge Bloom filter bug fix from trunk into the right-join branch. (Closed-Leaf check-in: 72131ad1 user: drh tags: right-join) | |
| 16:18 | Fix a typo in a comment. (check-in: c19c3c48 user: drh tags: right-join) | |
| 14:26 | Increase the version number to 3.38.4. (check-in: def971a0 user: drh tags: branch-3.38) | |
| 14:25 | Fix the Bloom filter pull-down optimization so that it jumps to the correct place if it encounters a NULL key. Fix for the bug described by forum thread 2482b32700384a0f. (check-in: 3dc9fc2f user: drh tags: branch-3.38) | |
| 14:01 | Fix the Bloom filter pull-down optimization so that it jumps to the correct place if it encounters a NULL key. Fix for the bug described by forum thread 2482b32700384a0f. (check-in: 6eda9b1a user: drh tags: trunk) | |
| 12:11 | Add assert()s to show that jumps always land an an instruction that is between 1 and Vdbe.nOp-1. Had these assert()s been in place before, they would have caused an assertion fault for the byte-code error reported by forum post 2482b32700. (check-in: 8f8a58fe user: drh tags: trunk) | |
|
2022-05-02
| ||
| 20:49 | Organize the various flag bits of the ExprList_item object into a substructure so that the whole lot can be copied all at once. Faster and smaller code. (check-in: 5341d4bb user: drh tags: right-join) | |
| 20:14 | Merge trunk fixes into the right-join branch. (check-in: e01f4c05 user: drh tags: right-join) | |
| 20:04 | Improved comments. (check-in: 158b80be user: drh tags: right-join) | |
| 19:59 | Name resolution and "*" wildcard expansion for parenthesized FROM clauses seems to work the same as PG. The code is chaos, however, and needs some cleanup. (check-in: 6f9c0b07 user: drh tags: right-join) | |
| 15:47 | Remove a testcase() macro taht was made obsolete by [a8da85c57e07721d]. (check-in: 053cf45e user: drh tags: trunk) | |
| 15:31 | Document (in comments) that the SQLITE_FlttnUnionAll bit has a specific value needed by TH3. (check-in: bcaa4a44 user: drh tags: trunk) | |
| 15:23 | Fix a harmless compiler warning in sqlite3TreeViewWinFunc() (a routine that does not even appear in release builds). (check-in: daff6070 user: drh tags: trunk) | |
| 15:11 | • Edit [ad32da8045e69137|ad32da80]: Mark "Closed". (artifact: baec69dd user: drh) | |
| 15:10 | Merge the latest trunk fixes and enhancements into the right-join branch. (check-in: afbcf075 user: drh tags: right-join) | |
| 14:32 | Improvement on check-in [a193749730d6cfba] so that the subroutine call to the IN operator right-hand side generator from the RIGHT JOIN no-match logic does not generate unreachable byte code. (check-in: cc458317 user: drh tags: trunk) | |
| 11:24 | Bring the comments on sqlite3FindInIndex() into closer alignment with what that routine actually does. (check-in: 40f32747 user: drh tags: trunk) | |