Hi!
I think there might be a glitch in the way SQLite 3.31.x derives the collation
information from the expression of a generated column.
In particular, COLLATE inside the AS parens seems to be ignored, but it is
honoured after the parens:
SQLite version 3.31.1 2020-01-27 19:55:54
Enter
> On 29 Jan 2020, at 14:59, Richard Hipp wrote:
>
> On 1/29/20, Markus Winand wrote:
>> Hi!
>>
>> I think there might be a glitch in the way SQLite 3.31.x derives the
>> collation information from the expression of a generated column.
>
> I think the c
Further comments to your statements below…
> On 30 Jan 2020, at 23:06, Keith Medcalf wrote:
>
>
> On: Wednesday, 29 January, 2020 06:45, Markus Winand
> wrote:
>
>> I think there might be a glitch in the way SQLite 3.31.x derives the
>> collation informati
> 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
> 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
> On 30 Jan 2020, at 18:20, Richard Hipp wrote:
>
> On 1/30/20, Markus Winand wrote:
>>
>> Unfortunately, the “what would PostgreSQL do” approach doesn’t provide
>> guidance here.
>
> Maybe it does. PostgreSQL doesn't allow typeless columns, but it does
6 matches
Mail list logo