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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
