https://bugs.documentfoundation.org/show_bug.cgi?id=105140
Bug ID: 105140
Summary: HSQLDB: Aggregate functions don't work - COLLECT,
FUSION, INTERSECTION
Product: LibreOffice
Version: Inherited From OOo
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rob...@familiegrosskopf.de
Created attachment 130193
--> https://bugs.documentfoundation.org/attachment.cgi?id=130193&action=edit
Open the database. 3 queries - all do not work because the functions aren't
supported.
While testing queries for Firebird I have reported bug105112. The behavior
there is similar to the behavior of HSQLDB:
There are functions you could chose in the GUI, which are unknown in the
internal database. For HSQLDB these functions are COLLECT, FUSION and
INTERSECTION.
There has been a report (bug90686) closed as RESOLVED NOTABUG. A better
solution would be only to show the functions, which will be available for the
internal database. Users, who have the first contact with Base, will use the
internal database and don't know much about functions. For those people the GUI
is created.
People, who will connect Base with an external database, will have more
experience. The will know how to write down a special function in SQL directly
and don't need the creation through GUI.
Currently we have a GUI, that should make it easier for users, but confuses
with special functions, which (could be I 'm not right) are special
ORACLE-functions.
1. Solution: Put away COLLECT, FUSION and INTERSECTION
2. Solution: For internal database only show the functions, which will work
with them, so a special GUI for HSQLDB and Firebird is needed.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
