Re: [sqlite] Improper error message

we just need an "obfuscated SQL" competition... -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of petern Sent: Tuesday, February 20, 2018 7:43 PM To: SQLite mailing list Subject: Re: [sqlite] Improper error message Further t

Re: [sqlite] Improper error message

Further to the earlier replies, here is a funny SQLite demo of function, keyword, and column names that is informative about the possibilities. sqlite> .load distinct.so sqlite> SELECT DISTINCT "distinct"() "distinct" WHERE [distinct] NOT NULL; distinct "fn distinct was called" distinct.c

Re: [sqlite] Improper error message

Hello, On 2018-02-20 23:59, Etienne Sanchez wrote: Some other DBMS such as Postgres and SQL-Server implement the functions "left" and "right". SQLite does not. But why do I get confusing error messages when I (mistakenly) attempt to use them? To illustrate my point: select foo('abc', 2)

Re: [sqlite] Improper error message

On 2/20/18, Etienne Sanchez wrote: > > As for "left", it's maybe due to the ambiguity with "left join", but then > what about "right"? (There is no ambiguity with "right join" since it is > not supported.) "left" and "right" are keywords in SQL. SQLite understands the

[sqlite] Improper error message

Hi, Some other DBMS such as Postgres and SQL-Server implement the functions "left" and "right". SQLite does not. But why do I get confusing error messages when I (mistakenly) attempt to use them? To illustrate my point: select foo('abc', 2) Error: no such function: foo select left('abc', 2)