- changed status to wontfix
rewrite strings of same-outered joins to be flat?
Issue #2753
resolved
i.e.:
a left outer join (b left outer join c)
have the compiler reassemble the joins before rendering based on them all being "outer" or "inner".
then, many of the joins that the SQLite compiler turns into subqueries won't be so.
we can always flatten out a <J> (b <J> (c <J> (...)))
, as long as all J are the same, right? computer scientist in the house?
Comments (2)
-
reporter -
reporter - removed milestone
Removing milestone: 0.9.0 (automated comment)
- Log in to comment
nah, user says he's getting 100% good query plans with nesting on MySQL, we're good, don't care much about SQLite here.