In today's edition of "Sean is horrified by technical choices of databases", SQLite treats `INNER JOIN`, `CROSS JOIN` and `,` the same and decides whether you want an inner join or a cross join based on whether there is an `ON` clause.
-
Show this thread
-
As a result of this, it also recommends that you add `WHERE true` when inserting from a select statement, since `INSERT INTO foo SELECT * FROM bar INNER JOIN baz ON CONFLICT` can no longer unambiguously decide whether `CONFLICT` is a column name or not in an LR(1) parser >_>
1 reply 1 retweet 2 likesShow this thread
(This should not be ambiguous. `INNER JOIN` *must* be followed by an `ON` clause. `CROSS JOIN` *must not* be followed by an `ON` clause)
2:37 PM - 9 Oct 2018
from Albuquerque, NM
0 replies
0 retweets
1 like
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.