Bug #77739 Table Import Wizard Bug
Submitted: 15 Jul 2015 20:35 Modified: 17 Oct 2015 22:43
Reporter: David E Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.3 CE, 6.3.4 OS:Windows
Assigned to: CPU Architecture:Any

[15 Jul 2015 20:35] David E
Description:
The table data import wizard fails to import data into an existing table.

How to repeat:
Choose CSV data to load, select existing table. After import reports success, check table to find no additions. Dialogue also reports that a new table has been created which is incorrect.
[16 Jul 2015 5:41] MySQL Verification Team
Hello David,

Thank you for the report.
I couldn't repeat this issue on Win7 with 6.3.4 version with dummy schema and data. Could you please indicate exact WB version you are using, if possible pls provide exact steps tried, dump file and table schema you are using for this.

Thanks,
Umesh
[16 Jul 2015 17:38] David E
6.3.4.0 build 828

Looks like the issue is with the DECIMAL columns, if I set them to single digits it imports fine, schema and sample data below

note it still reports that the table has been created when it fact it already exists

id	int(11)	NO	PRI
name	varchar(255)	NO	
address	varchar(255)	NO	
city	varchar(255)	NO	
state	varchar(2)	NO	
zip	varchar(5)	NO	
country	varchar(255)	NO	
phone	varchar(255)	YES	
website	varchar(255)	YES	
lat	decimal(18,12)	NO	
lng	decimal(18,12)	NO	
active	tinyint(1)	NO

name,address,city,state,zip,country,phone,website,lat,lng,active
Another Name,Another Address,Another City,NJ,22222,United States,123456789,www.example.com,30.01,90.22,1
Another Name2,Another Address2,Another City2,NJ,33333,United States,234567890,www.example.com,32.01,55.24,1
[16 Jul 2015 17:39] David E
Dummy Table Import Data

Attachment: Dummy Table Import Data.csv (text/comma-separated-values), 281 bytes.

[16 Jul 2015 17:41] David E
Dummy Table

Attachment: Dummy Table.sql (application/octet-stream, text), 2.54 KiB.

[17 Jul 2015 6:05] MySQL Verification Team
Thank you for the feedback and requested details.
Verified this on Win7 with WB 6.3.4.

Thanks,
Umesh
[17 Oct 2015 22:43] Philip Olson
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.5 release, and here's the changelog entry:

The Table Data Import wizard failed to import data into an existing table
when a DECIMAL column was used.

Thank you for the bug report.