Hi Henrik, all, On Sat, Sep 10, 2011 at 8:14 PM, Henrik Ingo <[email protected]> wrote: > On Sat, Sep 10, 2011 at 4:43 PM, Olaf van der Spek <[email protected]> > wrote: >>> In the same spirit as Drizzle doesn't allow implicit cross joins, I >>> was wondering if this options shouldn't be made default? (...whether >>> inside the server or just in the client.)
I disagree. If "implicit cross joins" are things like "INNER JOIN" or "LEFT JOIN" without a ON clause, then this is very different IMO: standard SQL does not allow INNER JOIN or LEFT or RIGHT JOIN without ON clause, because it doesn't make sense conceptually. And similarly, CROSS JOIN does not even allow an ON clause and for the same reason. A DELETE or UPDATE without a WHERE is valid SQL. With great power comes great responsibility. > Yes. The point is to disallow "DELETE FROM t;". (Error message: please > use TRUNCATE TABLE.) TRUNCATE TABLE is not standard SQL. In Oracle (and Sybase and MS SQL) TRUNCATE does not write to the transaction log. So basically, you can't ROLLBACK. In other words, the semantics are different, and no recommendation should be made to use TRUNCATE instead of DELETE. > It could of course break a few things, but this is to me equivalent > with requiring explicit CROSS JOIN. See above. Not the same thing. I am all for protecting people against shooting themselves in the foot, and it's great that the option is provided as command line argument to the command line client. But don't overdo it, certainly not if you have tot bastardize a standard language implementation to do so. Roland > henrik > > > > -- > [email protected] > +358-40-8211286 skype: henrik.ingo irc: hingo > www.openlife.cc > > My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559 > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > 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 : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
