https://bugs.documentfoundation.org/show_bug.cgi?id=133510
Robert Großkopf <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #9 from Robert Großkopf <[email protected]> ---
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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
