Bug #67483 Can't edit data from table outside current default schema

• Submitted: 6 Nov 2012 11:40
• Modified: 9 Jan 2015 9:50
• Reporter: Maciej Klepaczewski
• Status: Not a Bug
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.44
• OS: Windows (Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit)
• CPU Architecture: Any
• Tags: WBBugReporter

[6 Nov 2012 11:40] Maciej Klepaczewski

Description:
When selecting data from schema different than current default (like 'SELECT * FROM my_schema.my_table') SQL editor won't allow user to edit data in the table.

----- Developer Notes -----

MySQL Workbench CE for Windows version 5.2.44  revision 9933
Configuration Directory: C:\Users\Lucek\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7  Service Pack 1 (build 7601), 64-bit
CPU: 6x AMD Phenom(tm) II X6 1100T Processor, 8.0 GiB RAM
Active video adapter (0): NVIDIA GeForce GTX 460 SE
Installed video RAM: 1024 MB
Current video mode: 1920 x 1200 x 4294967296 colors
Used bit depth: 32
Driver version: 8.17.12.8026
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: Polish (Poland)

How to repeat:
create database a;
create table a.x ( id integer not null);
select * from a.x;

One can't edit rows data.

[10 Dec 2012 18:10] Ruben Dario Morquecho Valdez

Thanks for report this bug.

Bug is being analyzing.