Edit: WARNING: The title was edited, it was about HSQLDB previously
linux fedora 33
Table t_test with 2 columns, one is ID [INTEGER], the other is number TEXT [VARCHAR]
The name field contains values like:
1/2012 2/2012 1/2013
I’m trying to use query:
SELECT "number", LOCATE( '/', "number" ) FROM "t_test"
but I get error:
The data content could not be loaded. /builddir/build/BUILD/libreoffice-184.108.40.206/connectivity/source/commontools/dbtools.cxx:751
Error code firebird_sdbc error: *Dynamic SQL Error *SQL error code = -804 *Function unknown *LOCATE caused by 'isc_dsql_prepare' /builddir/build/BUILD/libreoffice-220.127.116.11/connectivity/source/drivers/firebird/Util.cxx:68
I tried to use " ’ and  as delimiters, but none works. What I’m doing wrong?
I used this  as reference describing formatting of LOCATE