https://bugs.documentfoundation.org/show_bug.cgi?id=133510
--- Comment #3 from Cecil Carpenter <csc...@gmail.com> ---
How to make Base fail with Time field in a MySQL DB.
(1) Create a table column of type Time in an MySQL table with format HH:MM:SS.
(2) Create a stored procedure that totals the time for all the rows that have
time date entered.
(3) Create a Base form for this MySQL table.
(4) In the Base Form, choose Column for the Time column.
(5) The only option that includes the 3 elements of time (HH:MM:SS) is
13:45:00.
(6) Choose 13:45:00.
(7) Enter data in a number of rows where the the hours a zero, the minutes are
less than 60, and the seconds are also less than 60.
(8) Execute the stored procedure that calculates the total time.
(9) The results calculated are incorrect because the time is being shifted as
well as being calculated incorrectly.
--
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
