[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: Time-values won't be written to table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128698

Alex Thurgood <iplaw67 at tuta.io> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #1 from Alex Thurgood <iplaw67 at tuta.io> ---
Reproduced with

Version: 6.3.2.2
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
Threads CPU : 4; OS : Mac OS X 10.15.1; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

Not just a Win problem.

I set up table in mysql as follows via the LO GUI:

ID (INT) AUTOINCREMENT NOT NULL
timing TIME NULL


Then I saved the table in LO, and double clicked on it to enter data.

I could enter a first recordset, for example, I entered 17:45:32 successfully.
When I attempted to enter a second recordset, it didn't matter which time I
entered, I always get a 00:00:00 display.

If I then connect to the mysql instance via the command line interface, and
modify or update the recordset, and refresh the table data in LO, I see the
amended data.

If I try to edit an existing record, I once again get a 00:00:00 result which
is committed to the database.

==>> regression

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191112/14d55a26/attachment.html>