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:
None 
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
Description:
Sometimes SQL Editor tab is executing queries on different schema that is bolded (selected) in the schema list pane. The problem is very big, if you have for example a lot of schemas on single instance that differs only in schema name, you can accidentaly execute query on wrong schema.

How to repeat:
Can't find correct steps to reproduce it, but I very often switch active schema, through: use _schema_name;
[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.