>> The following sql is supposedly valid:
>>
>> select 1 in (1)'hello';
>
> Apparently this gets interpreted as
>
> select (1 in (1)) as "hello";
>
>("as" is optional), under SQLite's long-standing policy of
> accepting single and double quotes more or less
> interchangeably.
Hmm, I'd not have
wcl...@gfs-hofheim.de wrote:
> The following sql is supposedly valid:
>
> select 1 in (1)'hello';
Apparently this gets interpreted as
select (1 in (1)) as "hello";
("as" is optional), under SQLite's long-standing policy of accepting single and
double quotes more or less interchangeably.
--
Hi,
I spotted this while looking into something else for Alexey:
The following sql is supposedly valid:
select 1 in (1)'hello';
where as
select * from t where 1 in (1)'hello';
returns "Error: near "'hello'": syntax error" (which I would expect!)
This occurs on v3.6.22, but I haven't
3 matches
Mail list logo
