Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
17 check-ins using file src/parse.y version efcb41d403
|
2022-05-17
| ||
| 14:59 | Add the sqlite3_db_name() interface. (check-in: 2ad152236c user: drh tags: trunk) | |
|
2022-05-16
| ||
| 16:55 | Add memory barriers to multi-threaded code in test4.c. (check-in: 9260f4e0fd user: dan tags: trunk) | |
| 16:10 | Fix a problem in test file swarmvtab3.test causing occasional failures. (check-in: f935c155ef user: dan 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: 2277f9ba70 user: drh tags: trunk) | |
| 17:40 | Improved debugging comment generation for the OP_Column opcode. (check-in: 3e073bfddf 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: 9d17233c7d user: drh tags: trunk) | |
|
2022-05-13
| ||
| 23:01 | Change an unreachable branch into an assert(). (check-in: 778e57a558 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: 0f96810b84 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: 12ee29d632 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: 238d9c247c 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: 6f741d6cfb 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: 2f4456f67f 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: 02b24863e6 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: 1ffea07ff9 user: drh tags: trunk) | |
|
2022-05-12
| ||
| 17:09 | Fix a harmless compiler warning in the CLI. (check-in: 7a2ac303d1 user: drh tags: trunk) | |
| 11:56 | Ensure that ON clauses are applied to the correct outer join. (check-in: c7e3a13a32 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: db27611e17 user: drh tags: trunk) | |