Bug #94451 Incorrect database name when importing csv file

• Submitted: 23 Feb 2019 6:52
• Modified: 27 Feb 2019 6:24
• Reporter: Donny Juhari
• Status: Verified
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 8.0.15
• OS: Windows (Microsoft Windows 10 Home Single Language)
• CPU Architecture: Any
• Tags: WBBugReporter

[23 Feb 2019 6:52] Donny Juhari

Description:
14:43:12 [ERR][       pymforms]: Unhandled exception in Python code: 
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_page_widget.py", line 97, in go_next
    self.main.go_next_page()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_form.py", line 76, in go_next_page
    self.pages[index].page_activated(True)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 581, in page_activated
    self.preload_existing_tables()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 599, in preload_existing_tables
    rset = self.main.editor.executeManagementQuery(u"SHOW FULL TABLES FROM `%s`" % self.main.destination_table['schema'], 0)
DBError: ("Incorrect database name ''", 1102)
14:44:07 [ERR][       pymforms]: Unhandled exception in Python code: 
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_page_widget.py", line 97, in go_next
    self.main.go_next_page()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_form.py", line 76, in go_next_page
    self.pages[index].page_activated(True)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 581, in page_activated
    self.preload_existing_tables()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 599, in preload_existing_tables
    rset = self.main.editor.executeManagementQuery(u"SHOW FULL TABLES FROM `%s`" % self.main.destination_table['schema'], 0)
DBError: ("Incorrect database name ''", 1102)

How to repeat:
1. Create schema and table
2. Import data into the table from Result Grid. 
3. When the wizard appears, select the csv fle
4. At select destination window, the error appeared

[27 Feb 2019 6:24] MySQL Verification Team

Hello Donny Juhari,

Thank you for the report.
Verified as described on Win7 with WB 8.0.15.

regards,
Umesh

[15 May 2019 23:11] Ondřej Málek

Works when selected correct Scheme in left pane 'SCHEMAS'.