[Libreoffice-bugs] [Bug 119139] New: Mysql timestamp fields not displayed in table data entry mode with jdbc-connector

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119139
           Summary: Mysql timestamp fields not displayed in table data
                    entry mode with jdbc-connector
           Product: LibreOffice
           Version: 6.0.5.2 release
          Hardware: All
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: iplaw67 at tuta.io

Description:
Mysql timestamp fields are not displayed in table data entry mode after
double-clicking on a table.

In comparison, using the native mysql connector extension shows the timestamp
fields.

Setting the connection parameter string zeroDateTimeBehavior=convertToNull
doesn't have any effect on the display, even after a shutdown and relaunch of
LO.

Steps to Reproduce:
1. Create a mysql table containing a NOT NULL timestamp field with DEFAULT
CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

2. For example, use the following DDL in the Tools > SQL dialog or via the
mysql command line:

create table ts7 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, fname
VARCHAR(50), ts7 TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP);

3. Refresh the list of tables in the LO UI
4. Double-click on the table ts7 to open the data entry mode
5. Notice that the timestamp field is not displayed.
6. ANy attempt to enter data in the fname field will generate an error
indicating that required data for the missing ts field has not been entered !


Actual Results:
1. Create a mysql table containing a NOT NULL timestamp field with DEFAULT
CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

2. For example, use the following DDL in the Tools > SQL dialog or via the
mysql command line:

create table ts7 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, fname
VARCHAR(50), ts7 TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP);

3. Refresh the list of tables in the LO UI
4. Double-click on the table ts7 to open the data entry mode
5. Notice that the timestamp field is not displayed.
6. ANy attempt to enter data in the fname field will generate an error
indicating that required data for the missing ts field has not been entered !


Expected Results:
The timestamp field should be displayed in the UI and allow data entry.


Reproducible: Always


User Profile Reset: No



Additional Info:
Mysql Connector J : 5.1.36

-- 
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/aab7c1d1/attachment.html>