SQL syntax error when 'updating procedures' during 'make install'
Created by: Matthias May
Hi,
I am trying to set up a caosdb server and during the installation procedure of the caosdb-mysqlbackend, I get the following error:
applying patch ./patch20200710-3.0.0-rc2/patch.sh to caosdb ... [OK]
Updating rules ... [OK]
updating procedures ... ERROR 1064 (42000) at line 2355: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE 0 = 1;
LEAVE retrieveEntityBody;'
END IF;
...' at line 40
make: *** [makefile:33: upgrade] Error 1
Running on Ubuntu 20.04 with MariaDB.
Do you need any more specific information?
Imported comments:
By Timm Fitschen on 2021-02-10T13:05:28.378Z
Background: Actually, MariaDB 10.3 did not allow the (perfectly fine) SELECT 0 WHERE 0 = 1
(for creating an empty result set). MariaDB 10.4 does, but we changed the installation script for compatibility with 10.3.
By Timm Fitschen on 2021-02-10T13:02:23.989Z
@yasofo thank you for your report!
fixed with https://gitlab.com/caosdb/caosdb-mysqlbackend/-/merge_requests/21