[Libreoffice-bugs] [Bug 119135] New: The TIMESTAMP configuration in a table in mysql using Base, doesn't work. Over and Over the data type is modified to DATETIME.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119135
           Summary: The TIMESTAMP configuration in a table in mysql using
                    Base, doesn't work. Over and Over the data type is
                    modified to DATETIME.
           Product: LibreOffice
           Version: 5.4.7.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: hedelao at gmail.com

Description:
Every time I modify a table, using BASE over Mysql, the data type of a
TIMESTAMP field is modified to DATETIME. No matter how many times I have tried,
when I modify the table it changes back to DATETIME.

Steps to Reproduce:
1. Use as data engine MYSQL 5.7.23
2. Open BASE
3. Create a table configuring a given field as TIMESTAMP.
4. Close the table. 
5. Open to edit the same table.
6. Modify it and save it.
7. The TIMESTAMP has changed to DATETIME

Actual Results:
1. Use as data engine MYSQL 5.7.23
2. Open BASE and create a database
3. Create a table configuring a given field as TIMESTAMP.
4. Close the table. 
5. Open to edit the same table.
6. Modify it and save it.
7. The TIMESTAMP has changed to DATETIME

Expected Results:
The field changes from TIMESTAMP to DATETIME and TIMESTAMP doesn't works.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Remain the configuration of TIMESTAMP unless I want to modify it.

-- 
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/20180807/793b01e7/attachment.html>