https://bugs.documentfoundation.org/show_bug.cgi?id=130596
Drew Jensen <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW
CC| |[email protected]
--- Comment #1 from Drew Jensen <[email protected]> ---
Tested with Ubuntu 18.04 and LO 6.2.4 and 6.4
I can confirm that the named parameter function is not working properly in the
COALESCE function.
It may be for all functions. I also tried using a parameter in the SUBSTRING
function with this query:
SELECT substring( "Name" from 1 for :testDec ) FROM "Table1"
and received a slightly different error:
Error code: 1
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -804
*Data type unknown
caused by
'isc_dsql_prepare'
while this query:
SELECT cast( :testInt as integer) AS "Int" FROM "Table1"
returns the original error (from the coalesce) of:
SQL Status: HY004
Incorrect type for setString
I don't think the data type listed in the subject is important but will try a
few other functions before I change that.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
