https://bugs.documentfoundation.org/show_bug.cgi?id=105112
--- Comment #3 from rob...@familiegrosskopf.de ---
(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. If I
open, for example, a Base-file connected to dBase there are no functions
available. If I connect it to a Calc-table there are some functions.
The following function are the functions for internal HSQLDB:
COUNT | MIN | MAX | SUM | AVG | SOME | EVERY | VAR_POP | VAR_SAMP | STDDEV_POP
| STDDEV_SAMP
Now look on the GUI for Firebird-databases in Base:
EVERY, ANY, SOME, COLLECT, FUSION, INTERSECTION
aren't working with Firebird in a normal way. Don't know where ANY, COLLECT,
FUSION, INTERSECTION had come from. Not from HSQLDB. Must be coded in the
driver, which connects to Firebird.
--
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
