Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
13 check-ins related to "transitive-constraints"
|
2015-05-18
| ||
| 12:28 | Transitive constraints should only work if operands have compatible affinities and collating sequences. check-in: 5df4056448 user: drh tags: trunk | |
| 12:18 | Use an ALWAY() on conditionals in the transitive constraint logic that are always true as far as we know. Closed-Leaf check-in: 204e567f68 user: drh tags: transitive-constraints | |
| 11:34 | Refinements to the determination of when an A==B term is an equivalence. Add test cases. check-in: 6bfaf525ca user: drh tags: transitive-constraints | |
|
2015-05-16
| ||
| 20:51 | Further restrictions on the use of the transitive property in WHERE clauses. check-in: 8c886c43ff user: drh tags: transitive-constraints | |
| 19:17 | Fix the transitive constraint processing to only allow transitivity if the operands of the == or IS operator have compatible affinities. check-in: a46a247fbc user: drh tags: transitive-constraints | |
| 18:31 | Fix a typo in a comment. No changes to code. check-in: ee4b74250a user: drh tags: trunk | |
|
2013-01-17
| ||
| 17:20 | Enhance the query planner to exploit transitivity of join constraints. check-in: 38852f158a user: drh tags: trunk | |
| 16:43 | Add the ability to disable transitive constraints using the sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS) interface. Closed-Leaf check-in: 593d67c8b0 user: drh tags: transitive-constraints | |
| 16:18 | Avoid unnecessary collating sequence and affinity restrictions on the use of transitivity. Add test cases to show that the restrictions are not needed. check-in: 56549f4566 user: drh tags: transitive-constraints | |
| 15:05 | Make more aggressive use of transitivity in optimizing queries. Add a test case. check-in: d96762841a user: drh tags: transitive-constraints | |
| 00:08 | Improved comments explaining the operation of the findTerm() utility routine in where.c. Increase the maximum number of levels of transitivity from 4 to 11. check-in: fe152f8b04 user: drh tags: transitive-constraints | |
|
2013-01-16
| ||
| 17:08 | Enhance the query planner to exploit transitivity of join constraints in a multi-way join. check-in: 13171eb5dc user: drh tags: transitive-constraints | |
| 00:46 | Improvements to query planning for joins: Avoid unnecessary calls to "optimal scan" checks in cases where table reordering is not possible. Make sure optimal scan checks are carried out for CROSS JOINs and LEFT JOINs. check-in: d5ebb78778 user: drh tags: trunk | |