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: | |
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
[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.