MySQL Bugs: #72842: Saved Edit Data sessions are not restored if data contains dates

Bug #72842	Saved Edit Data sessions are not restored if data contains dates
Submitted:	2 Jun 2014 21:32	Modified:	30 Jun 2014 19:37
Reporter:	Javier Treviño	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S2 (Serious)
Version:	1.2.1	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
When editing a table that contains a column with zero dates, the edit session handles the zero dates correctly, but after saving the Workbook with that open Edit Session and reopening the Workbook, the Edit Session cannot be restored again (fails silently) due to an exception regarding the data with zero dates.

How to repeat:
1. Open MySQL for Excel.
2. Select a connection, schema and a table that contains a column with zero dates (i.e. a datetime column that does now allow null values and where a zero date values "0000-00-00 00:00:00" are inserted).
3. Click on Edit Data.
4. Save the Workbook maintaining the Edit Session open.
5. Close the Workbook.
6. Open the saved Workbook.
7. Open MySQL for Excel
8. The add-in will detect there is an open Edit Session for the active workbook and will ask the user if he wishes to restore the Edit Session, click Restore.
9. Note the Edit Session was not restored, the data is imported but the Edit Session is not restored although there is no error thrown.

Posted by developer:
 
Actually it fails to restore the sessions with any kind of dates, not only zero dates.

Posted by developer:
 
Set the AllowZeroDateTimeValues property value of connections created from stored Edit Sessions being restored to true so they support MySQL zero dates.

Fixed also a bug preventing Edit Sessions from being restored when starting MySQL from Excel on an already opened Excel workbook.

Posted by developer:
 
Fixed, checked using mysql-for-excel-commercial-1.3.1.

Fixed as of the upcoming MySQL for Excel 1.3.1 release, and here's the changelog entry:

Edit Sessions would fail to restore with sessions that contained tables
with zero DateTime values. 

Edit Sessions would also fail to restore when MySQL for Excel was started 
on a currently opened Excel workbook.

Thank you for the bug report.