On 2/11/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > John Stanton <[EMAIL PROTECTED]> wrote: > > That ia a nice idea. To have a pragma which specied the dialect. There > > could be "strict" or "ansi" and "mysql", "oracle", "sqlserver" etc etc. > > It would give tighter control over hard to track annoying minor syntax > > errors. > > > > And, it would multiple exponentially the number of test cases > we have to write and maintain in order to adequately test the > parser.... ;-) >
One of the dangers of supporting "other standards" is that it becomes hard to wean folks off of them when you do decide to go "pure." Microsoft is experiencing a similar issue with IE. IE6 buggered up the standards support royally, but enough people around the world used it and made websites that were "compliant" with it that when MS made IE7 which hewed to the standards much better, all those websites broke. So, they are now proposing a new quirks mode in IE8. A nice collection of links debating both sides is at <http://www.digital-web.com/news/2008/01/IE8_Version_Targeting_causes_quite_a_stir> Keep SQLite simple, and keep it compliant with whatever the single ANSI SQL standard may be there out there. Users of other databases that adhere to the same standards will feel at home. Others will adapt. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users