https://bugs.documentfoundation.org/show_bug.cgi?id=105112
--- Comment #10 from Lionel Elie Mamane <[email protected]> ---
(In reply to robert from comment #3)
> (In reply to Tor Lillqvist from comment #2)
>> I guess those function aren't available in Firebird. Are they in HSQLDB? If
>> not, I would say it is not a bug that they aren't in Firebird either.
>> Firebird is supposed to be a replacement for HSQLDB to the extent possible,
>> not for some external maximally-featured database accessed through Base.
>> The GUI to create queries probably shows such functions because *some*
>> external databases that Base might connect to will have them?
> No, the GUI shows only the functions, which are available in databases.
That is not true, at least not to the granularity of each function, function by
function.
> If I open, for example, a Base-file connected to dBase there are no functions
> available.
Yes, *no* functions is a supported state.
> If I connect it to a Calc-table there are some functions.
In my testing, in LibreOffice 5.4.3.2 (TDF deb amd64 build) there is _no_
function available.
> The following function are the functions for internal HSQLDB:
> COUNT | MIN | MAX | SUM | AVG | SOME | EVERY | VAR_POP | VAR_SAMP |
> STDDEV_POP
> | STDDEV_SAMP
In my testing, in LibreOffice 5.4.3.2 (TDF deb amd64 build), the GUI proposes:
Average, Count, Maximum, Minimum, Sum, Every, Any, Some, STDDEV_POP,
STDDEV_SAMP, VAR_SAMP, VAR_POP, Collect, Fusion, Intersection, Group
And Collect, Fusion, Intersection and Group DO NOT WORK in embedded HSQLDB.
Meaning, we have the _same_ situation with HSQLDB than you describe with
Firebird. You say it is a "regression" in the switch from HSQLDB from Firebird,
in my testing it is not.
> Don't know where ANY, COLLECT,FUSION, INTERSECTION had come from.
> Not from HSQLDB. Must be coded in the driver, which connects to Firebird.
No, they are proposed with _all_ databases that are tagged to support _any_
aggregate function. The LibreOffice GUI either displays _NO_ aggregate function
or displays _this_ _whole_ _set_, no more no less.
--
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
