no such function: cat

(1) By James (jgpage) on 2024-07-02 15:46:10 [link] [source]

I am trying to chase down the cause of this error:

sqlite> select cat('a','b') as xx; Parse error: no such function: cat select cat('a','b') as xx; ^--- error here

I have run this statement successfully in the past, so something has changed.

I am running Win11 Home. SQlite is installed in c:SQLite which is the last item in PATH.

Any suggestions? Is there a preferred installation?

TIA.

(2) By Aask (AAsk1902) on 2024-07-02 16:08:54 in reply to 1 [link] [source]

Did you run this in the past (and recollection is failing you)?

select concat('a','b') as xx;

(3) By James (jgpage) on 2024-07-02 16:22:44 in reply to 2 [source]

I did find a typo - cat vs. concat. The concat works.

I am using two different systems. and sqlite3 command works.

I use SqliteStudio as the GUI. which works on system a, but not system b.

I suspect a configuration difference, but I have not tracked it down yet.

Thanks

(4) By James (jgpage) on 2024-07-02 19:41:36 in reply to 3 [link] [source]

Finally found the underlying issue. The sqlite3.dll component is shipped by a number of products (python, Libre Office, MySQL, etc.) including SqliteStudio. I ended up renaming the version shipped with SqliteStudio so that it would find the version in PATH (c:\sqlite).

Problem went away.