MySQL Bugs: #85341: Table data import wizard

Bug #85341	Table data import wizard
Submitted:	7 Mar 2017 10:28	Modified:	23 Nov 2018 13:42
Reporter:	Mirosław Sosna	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.9	OS:	Ubuntu (16.04)
Assigned to:		CPU Architecture:	Any

Description:
If column name has white space import wizard return error on create tabel 

Starting...
Prepare Import...
Prepare Import done
Import data file....

Traceback (most recent call last):
  File "/usr/share/mysql-workbench/libraries/workbench/wizard_progress_page_widget.py", line 192, in thread_work
    self.func()
  File "/usr/lib/mysql-workbench/modules/sqlide_power_import_wizard.py", line 125, in start_import
    retval = self.module.start(self.stop)
  File "/usr/lib/mysql-workbench/modules/sqlide_power_import_export_be.py", line 271, in start
    ret = self.start_import()
  File "/usr/lib/mysql-workbench/modules/sqlide_power_import_export_be.py", line 408, in start_import
    if not self.prepare_new_table():
  File "/usr/lib/mysql-workbench/modules/sqlide_power_import_export_be.py", line 237, in prepare_new_table
    self._editor.executeManagementCommand(""" CREATE TABLE %s (%s)""" % (self._table_w_prefix, ", ".join(["`%s` %s" % (col['name'], col["type"]) for col in self._mapping])), 1)
DBError: ("Incorrect column name 'w ws '", 1166)
ERROR: Import data file: ("Incorrect column name 'w ws '", 1166)
Failed

How to repeat:
file.csv

" W o ws";"w ws ";"hmm"
1;"monday";1
2;"Tuesday";1
3;"Wednesday";1
4;"Thursday";1
5;"Friday";1
6;"Saturday";1

Hello Mirosław,

Thank you for the bug report.
Could you please provide repeatable test case (exact steps, create table statement, sample csv data etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Thank you for the bug report. 
Bug confirmed as per description.

Posted by developer:
 
Works as expected. 
With MySQL Server as per documentation:
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
"Database, table, and column names cannot end with space characters."
After removing the space character from the end of the second column,
import will succeed.