Bug #87788 | Special characters in first field name when creating table using CSV file | ||
---|---|---|---|
Submitted: | 18 Sep 2017 7:56 | Modified: | 19 Sep 2017 13:29 |
Reporter: | Hassan Naqvi | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
Version: | 6.3.9 | OS: | Microsoft Windows (Microsoft Windows 7 Enterprise Service Pack 1) |
Assigned to: | CPU Architecture: | Any | |
Tags: | WBBugReporter |
[18 Sep 2017 7:56]
Hassan Naqvi
[18 Sep 2017 12:32]
Chiranjeevi Battula
Hello Hassan, Thank you for the bug report. I could not repeat the issue at our end using with MySQL workbench 6.3.9 versions. Could you please provide repeatable test case (exact steps, sample CSV file, screenshot etc. - please make it as private if you prefer) to confirm this issue at our end? Thanks, Chiranjeevi.
[19 Sep 2017 11:13]
Hassan Naqvi
sample csv
Attachment: test1.csv (application/vnd.ms-excel, text), 100 bytes.
[19 Sep 2017 11:13]
Hassan Naqvi
sample csv
Attachment: test2.csv (application/vnd.ms-excel, text), 102 bytes.
[19 Sep 2017 11:13]
Hassan Naqvi
sample csv
Attachment: test3.csv (application/vnd.ms-excel, text), 105 bytes.
[19 Sep 2017 11:39]
Hassan Naqvi
Steps to recreate: ================= First File: ========== - Right click on schema name and select Table Data Import Wizard - Enter CSV file path (test1.csv) or select using Browse button. Press Next - On the next screen, Select Create New Table. I didn't change given table name. - Next, Next, Next, Finished. Second File: =========== - Right-clicked on newly created table's name and selected Table Data Import Wizard from popup menu. - Enter CSV file path (test2.csv) or select using Browse button. Press Next - On the next screen, Select Use existing table (test1). I didn't change given table name. - Next, Next, Next, oh no! There is an error!!! (...Finished.) Temporary Solution: ================== - Right click table name (test1), select Alter table from popup menu. - Select first column in the table (id), select the entire content of form field column name (just above collation form field). IMPORTANT! Either double click to select entire content or use Select All from popup menu or use Ctrl+a when cursor is inside the column name form field. Selecting only 'i' and 'd' won't work. - Delete and rewrite same field name again -- 'id' and Apply - Repeat 'Second File' steps and there will be no error this time.
[19 Sep 2017 12:04]
Hassan Naqvi
Before trying to import second file for the first time, try this... Copy and paste both select statements in Workbench. SELECT `id` FROM `test1`; <<< Error Code: 1054. Unknown column 'id' in 'field list' SELECT `id` FROM `test1`; <<< This works.
[19 Sep 2017 13:29]
Chiranjeevi Battula
Hello Hassan, Thank you for the feedback and testcase. Verified this behavior on MySQL Workbench in 6.3.9 version. Thanks, Chiranjeevi.
[19 Sep 2017 13:30]
Chiranjeevi Battula
Screenshot
Attachment: Bug_87788.JPG (image/jpeg, text), 81.19 KiB.