https://bugs.documentfoundation.org/show_bug.cgi?id=133510
Robert Großkopf <rob...@familiegrosskopf.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rob...@familiegrosskopf.de
--- Comment #9 from Robert Großkopf <rob...@familiegrosskopf.de> ---
The stored procedure shouldn't be a problem. It is working in MySQL directly,
not in Base. Base has nothing to do with the calculation: Base will only show
the result it is reading from the database.
So I tried something with a minimalistic table:
3 fields, one with ID, next with title and third with duration.
All this created in Base, connected directly to MariaDB (haven't any MySQL
working here).
I filled in some data and started this query:
SELECT "ID", "title", "duration", ( SELECT SEC_TO_TIME(SUM( TIME_TO_SEC(
"duration" ) ) ) FROM "libretest"."TimeTest" "TimeTest" WHERE "ID" <= "a"."ID"
) "Sum_Duration_Time" FROM "libretest"."TimeTest" "a"
No problem to get the right sum of the duration for all "title". I have to
change the format for the column to [HH]:MM:SS only.
All tested with MariaDB and the direct driver from LO, LO-Version 6.4.6.2 on
OpenSUSE 15.1 64bit rpm Linux.
--
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