[Libreoffice-bugs] [Bug 130596] FIREBIRD (internal): Parameter doesn't work with COALESCE and numeric fieldtypes

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130596

Drew Jensen <drewjensen.inbox at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW
                 CC|                            |drewjensen.inbox at gmail.com

--- Comment #1 from Drew Jensen <drewjensen.inbox at gmail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200211/3ebc2780/attachment.htm>