https://bugs.freedesktop.org/show_bug.cgi?id=59205
Priority: medium
Bug ID: 59205
Assignee: [email protected]
Summary: ODBC - incorrect display of default inserted MySQL
values using Actual Technologies ODBC driver
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.1.0.0.alpha0+ Master
Component: Database
Product: LibreOffice
Using a locally hosted mysql server.
Table definition :
CREATE TABLE `assistant` (
`assistant_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`assistant` varchar(7) NOT NULL DEFAULT '',
`chg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`assistant_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Connect to the mysql server using Actual Technologies ODBC driver.
Open up the table for editing.
Insert a char string value into the field assistant.
Move down to next tuple.
Insert a second char sting into the field assistant.
Move up to save the data.
Note that LO displays the autoincrement fields as having a value of 0 (zero)
for both entries.
Note that LO displays the chg_date fields as being NULL, with an incorrect date
display (see bug #59200)
Close the table.
Re-open the table. The default values are now correctly displayed.
Alex
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
