Bug #72970 Data types entered manually in Data Type combo box are not validated correctly.
Submitted: 12 Jun 2014 1:21 Modified: 30 Jun 2014 22:53
Reporter: Javier Treviño Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S3 (Non-critical)
Version:1.3.0 OS:Any
Assigned to: CPU Architecture:Any

[12 Jun 2014 1:21] Javier Treviño
Description:
A bug seems to have been introduced in 1.3.0 in the Export Data dialog, now some Data types like enums or sets entered manually in Data Type combo box are not validated correctly.

How to repeat:
1. Open MySQL for Excel
2. Select any connection and schema
3. On a Excel worksheet, select some data suitable for exporting, make sure one of the columns have text values suitable for an enum or set, preferably make sure only 2-3 distinct values are in the column's data.
4. Click on Export Data.
5. Select the column from step 3 and click in the Data Type combo box's text area, clear its contents and type in manually the type declaration asan enum or a set (e.g. "enum('male','female')")
6. Tab out of the Data Type combo box, and note a warning appears stating the type entered is not a valid MySQL data type.
[12 Jun 2014 1:26] Javier Treviño
Posted by developer:
 
Fixed a bug in the Export Data dialog where data types containing parenthesis entered manually in the Data Type combo box for new columns were not validated correctly.
[30 Jun 2014 22:53] Philip Olson
Fixed as of the upcoming MySQL for Excel 1.3.1 release, and here's the changelog entry:

For new columns, the "Export Data" dialog would not accept manually typed
in data types that contained a parenthesis, such as "ENUM".

Thank you for the bug report.