On 18 Apr 2011, at 10:20am, Stefan Keller wrote: > Simon wrote: >> Stefan, please read this: >> http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt > > Thank you for the weblink. > Here are some citations from it which could be of interest to you too > (see below). > I don't think SQLite supports that
You missed the important part of my post. Compare what the other popular SQL implementations do with the spec, and you'll find that they all have significant gaps in their implementation. You won't find a single SQL distribution out there that claims full SQL-92 compliance, and that includes all the biggies like Oracle, Microsoft, and MySQL. We are not saying that SQLite claims to completely conform to the SQL spec.. We're saying that you shouldn't expect it to, because nothing else does either. Most claim only entry-level compliance at best. There are higher levels such as transtional-level and intermediate-level, but as you get higher fewer and fewer implementations claim them. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users