https://bugs.documentfoundation.org/show_bug.cgi?id=105075
Bug ID: 105075
Summary: Firebird: Limit of query-GUI isn't supported
Product: LibreOffice
Version: 5.4.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 130120
--> https://bugs.documentfoundation.org/attachment.cgi?id=130120&action=edit
Limit doesn't work with Firebird - ROWS isn't supported by GUI and HSQLDB
Open the attached database.
There are different Queries for the limit of a select.
Query_with_GUI_Limit is designed by the GUI but doesn't work.
Firebird doesn't know anything about the command LIMIT.
The other 3 queries
(...First_Skip, ...ROWS, ...ROWS_TO) show the limit, but this won't be
supported by the GUI.
Don't think we could fix this in an easy way. Firebird doesn't work with LIMIT
and HSQLDB doesn't work with ROWS. So we should remove or disable "Limit" and
"Query properties" from the query-design in Firebird.
--
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
