Re: [sqlite] "Standard SQL" ?

2020-02-03 Thread James K. Lowden
On Sun, 2 Feb 2020 10:05:11 +0100 Markus Winand wrote: > When you say ?many standards? do you mean the different releases > those standards have? Yes. > IMHO, there is only one SQL standard, namely ISO/IEC 9075. The > current and technically only valid version is that of 2016 (even > though

Re: [sqlite] "Standard SQL" ?

2020-02-02 Thread Markus Winand
> On 1 Feb 2020, at 23:31, James K. Lowden wrote: > > Similarly, last I checked, no SQL standard supported LIMIT for SELECT. Just FYI: The the functionality of LIMIT was added to the SQL standard ISO/IEC 9075 with the 2008 update in form of FETCH FIRST … ROWS ONLY This clause also

Re: [sqlite] "Standard SQL" ?

2020-02-01 Thread James K. Lowden
On Thu, 30 Jan 2020 19:19:53 + Simon Slavin wrote: > Have any of you been using this term for a meaning other than "Fully > conforming to SQL:2019 (or whatever version you think current) ? Do > you have documentation somewhere ? Or are my suspicions correct and > there's no such thing ? I

Re: [sqlite] "Standard SQL" ?

2020-01-30 Thread Markus Winand
> On 30 Jan 2020, at 21:12, Keith Medcalf wrote: > > On Thursday, 30 January, 2020 12:20, Simon Slavin > wrote: > >> I would appreciate your help. Reading a technical article today, I came >> across a casual reference to "Standard SQL" as if it was a well-known >> thing. This worried me

Re: [sqlite] "Standard SQL" ?

2020-01-30 Thread Keith Medcalf
On Thursday, 30 January, 2020 12:20, Simon Slavin wrote: >I would appreciate your help. Reading a technical article today, I came >across a casual reference to "Standard SQL" as if it was a well-known >thing. This worried me since I've never heard the term and I'm meant to >know about such

Re: [sqlite] "Standard SQL" ?

2020-01-30 Thread Chris Brody
A few resources I found from https://www.google.com/search?q=sql+standard : - https://en.wikipedia.org/wiki/SQL - https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/#gref - https://dev.to/0xcrypto/who-owns-the-sql-standard-76m -