Hi Olaf, all, On Mon, Sep 12, 2011 at 12:08 AM, Olaf van der Spek <olafvds...@gmail.com> wrote: >> If "implicit cross joins" are things like "INNER JOIN" or "LEFT JOIN" > without a ON clause, > > I assume they're like from A, B, C, D. Inner join is explicit.
I see now that the documentation at http://docs.drizzle.org/join.html#different-kinds-of-sql-joins indeed only mentions this case requiring a WHERE (or an ON, which is puzzling - I'm pretty sure FROM t1,t2 ON .. is not valid standard SQL). If one's currently allowed to leave out the ON clause for INNER, LEFT and RIGHT JOIN, then I think it'd be good to change that behaviour to align it with the standard. >> A DELETE or UPDATE without a WHERE is valid SQL. With great power > comes great responsibility. > > Power isn't affected, safety is. Fair point, but in that case, IMO it makes much more sense to set autocommit off by default. > > Greetings, > > Olaf > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : drizzle-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Roland Bouman blog: http://rpbouman.blogspot.com/ twitter: @rolandbouman Author of "Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL", http://tinyurl.com/lvxa88 (Wiley, ISBN: 978-0-470-48432-6) Author of "Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration", http://tinyurl.com/33r7a8m (Wiley, ISBN: 978-0-470-63517-9) _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : drizzle-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
