Bug #76504 Copy to Clipboard -> Insert Statement working with obsolete table

• Submitted: 27 Mar 2015 8:52
• Modified: 27 Mar 2015 9:34
• Reporter: Aleksey Aleksey
• Status: Verified
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.2.3.12312 build 2280 (64 bits), 6.2.5
• OS: Windows (7)
• CPU Architecture: Any
• Tags: editor

[27 Mar 2015 8:52] Aleksey Aleksey

Description:
1 Right-click on a schema in Navigator 
2 Drop schema 
3 Create schema by using "Create a new schema by using in the connected server"
4 Tables were created by external application
5 Right-click on a table in Navigator 
6 Copy to Clipboard -> Insert Statement

How to repeat:
1 Right-click on a schema in Navigator 
2 Drop schema 
3 Create schema by using "Create a new schema by using in the connected server"
4 Tables were created by external application
5 Right-click on a table in Navigator 
6 Click "Send to SQL Editor" -> "Insert Statement"
7 The generated statement used the old table structure.

Suggested fix:
update the internal representation of table structure on click of the "Insert Statement" and other similar items in "Send to SQL Editor", might be also in "Copy to Clipboard".

[27 Mar 2015 9:34] MySQL Verification Team

Hello Oleksii Kyslytsyn,

Thank you for the report and repeatable steps.
Confirmed this behavior on Win7 with WB 6.2.5

Thanks,
Umesh

[27 Mar 2015 9:34] MySQL Verification Team

Screenshot..

Attachment: 76504.png (image/png, text), 65.87 KiB.