Bug #68013 | Schema list show different active schema than sql editor | ||
---|---|---|---|
Submitted: | 2 Jan 2013 12:53 | Modified: | 9 Jan 2015 9:50 |
Reporter: | Marcin Szalowicz | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench: SQL Editor | Severity: | S1 (Critical) |
Version: | 5.2.45 | OS: | Any (ubuntu 12.04/amd64) |
Assigned to: | CPU Architecture: | Any | |
Tags: | active schema, sql editor |
[2 Jan 2013 12:53]
Marcin Szalowicz
[2 Jan 2013 12:54]
Marcin Szalowicz
i forgot to mention that such bug didn't exists in 5.2.44
[2 Jan 2013 12:55]
Marcin Szalowicz
topic letter mismatch fix
[2 Jan 2013 13:16]
Marcin Szalowicz
few more things, if i issue use _schema_name; and after that issue: select database(); i got correct active schema. If after that i leave wb and do something else then issue in wb again: select database(); the active schema is changed :(, it looks like something in the background is changing sql editor active schema, but the schema list in the left pane is untouched , so if you will not check the active schema by select database() you can exec query on different schema :/
[2 Jan 2013 13:18]
Marcin Szalowicz
more: schema is chaning every 3-4 minutes, and in my case it's always falling back to the first schema that is visible in the schema list pane
[2 Jan 2013 13:43]
Marcin Szalowicz
to reproduce the bug, use these steps: set wait_timeout = 180; set interactive_timeout = 180; use _some_schema_name; select dabase(); wait 4 minutes select database(); //voila different active schema
[2 Jan 2013 13:44]
Mike Lischke
Just restart the server and issue the "select database()" query again. This will show a different schema then.