On Wed, 27 Jan 2016 20:10:01 +0000 Simon Slavin <slavins at bigfraud.org> wrote:
> There are later standards for SQL and SQLite and other SQL implementations > include some of the features in them. But at this point different > implementations start to diverge from one-another far more. With this, you fully answered the question :-) > Given what you wrote you should definitely read SQL1992. It is the core > standard for SQL and you will find some ways in which SQLite is not SQL1992. > However most SQL implementations implement most things in SQL1992. Given what you wrote, I definitely should, indeed (will just have to print it, as it is a text file). By the way, I learned about another divergence: with ROWID, SQLite allows NULL in PRIMARY KEY columns. I wonder if this is the same with SQLite4 (I don't know it, as Python does not support it) -- Yannick Duch?ne
