Bug #84161 Schemas are displayed twice in schema selection dropdown menu on Data Import

• Submitted: 12 Dec 2016 10:33
• Modified: 30 May 2018 14:26
• Reporter: NOT_FOUND NOT_FOUND
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 6.3.8
• OS: Windows (Microsoft Windows 7 Ultimate N Service Pack 1)
• CPU Architecture: Any
• Tags: WBBugReporter

[12 Dec 2016 10:33] NOT_FOUND NOT_FOUND

Description:
When you display Data Import screen in MySQL Workbench, in the "Default Target Schema" dropdown menu, schemas are displayed twice.

For example, if you have database1, database2 and database3 on your server, the dropdown menu contains :
database1
database2
database3
database1
database2
database3

How to repeat:
- Click on "Data Import/Restore"
- Click on "Import from Self-Contained File" checkbox
- Click on "Default Target Schema"

Suggested fix:
Only display distinct schemas names

[12 Dec 2016 11:01] MySQL Verification Team

Please try version 6.3.8. Thanks.

[12 Dec 2016 12:11] NOT_FOUND NOT_FOUND

The problem is not fixed in 6.3.8 (MySQL server version : 5.7.14)

[12 Dec 2016 12:40] Chiranjeevi Battula

Hello !

Thank you for your feedback.
Verified this behavior on MySQL Workbench in 6.3.8 version.

Thanks,
Chiranjeevi

[12 Dec 2016 12:40] Chiranjeevi Battula

Screenshot

Attachment: 84161.png (image/png, text), 117.27 KiB.

[23 May 2018 13:04] Miguel Tadeu Mota

Posted by developer:
 
Can't repeat any more

[30 May 2018 14:26] Christine Cole

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

The set of default target schemas available to choose from within the
Administration – Data Import/Restore tab showed each schema listed twice
on Windows platforms.

Thank you for the bug report.