sqlite3 built in function concat is not recognized.

pawelsalawa / sqlitestudio

A free, open source, multi-platform SQLite database manager.

https://sqlitestudio.pl

Other

4.67k stars 571 forks source link

sqlite3 built in function concat is not recognized. #5068

Open Bob3056 opened 2 months ago

Bob3056 commented 2 months ago

Details

[19:23:33] Error while executing SQL query on database 'Test': no such function: concat

Steps to reproduce

SELECT concat( "A", "B" )

Operating system

Windows 10

SQLiteStudio version

3.44

pawelsalawa commented 2 months ago

SQLiteStudio version is 3.4.4, not 3.44. It comes with SQLite version 3.34.1, while the function you mention concat() was introduced in SQLite 3.44.

pawelsalawa commented 2 months ago

You can update SQLite version in your SQLiteStudio installation directory - just download fresh SQLite3 dll file from sqlite.org and replace the one in SQLiteStudio's installation directory.