rewrite strings of same-outered joins to be flat?

Issue #2753 resolved
Mike Bayer repo owner created an issue

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)

  1. Mike Bayer reporter

    nah, user says he's getting 100% good query plans with nesting on MySQL, we're good, don't care much about SQLite here.

  2. Log in to comment