https://bugs.documentfoundation.org/show_bug.cgi?id=139600
Bug ID: 139600
Summary: Editing SQL correct query generate SQL error if
inserting a parameter
Product: LibreOffice
Version: 6.4.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
I have a bacula installation (mariadb based) I connect correctely with dbbeaver
via JDBC and also with libreofficebase. I finally have to implement this query
written via SQL:
SELECT
MediaId
,VolumeName
,Slot
,VolStatus
,Enabled
,VolBytes
,VolFiles
,VolRetention
,Recycle
,MediaType
,VolType
,VolParts
,LastWritten
,ExpiresIn FROM
(
SELECT
MediaId
,CAST(VolumeName AS VARCHAR(20)) AS VolumeName
,VolStatus
,Enabled
,VolByte
,VolFiles
,VolRetention
,Recycle
,CONCAT ( CASE
WHEN Slot < 13 THEN 'Left '
ELSE 'Right '
END
, Slot ) AS Slot
,CAST( MediaType AS VARCHAR(10)) AS MediaType
,VolType
,VolParts
,LastWritten
,GREATEST(
0
, CAST(UNIX_TIMESTAMP(LastWritten) AS INTEGER)
+ CAST(VolRetention AS INTEGER)
- CAST(UNIX_TIMESTAMP(NOW()) AS INTEGER)) AS ExpiresIn
FROM Media WHERE
InChanger = 1
ORDER by ExpiresIn DESC LIMIT :ask
) AS InsiemeNastri
ORDER BY Slot
The problem is:
If I save the query "as is" or try to run, it fail with a "SQL Syntax Error".
If I substitute the ":ask" parameter with a number (e.g. 6) It works and I can
run the query correctly. If I try to view it in "design mode" it fails with
"SQL Error". I'm going to port the error in hsqldb so I can add the attachment
to this bug
--
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
