SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 7.1.244 Pro] - Sudden change of behavior

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 7.1.244 Pro] - Sudden change of behavior
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2165

Post [SA 7.1.244 Pro] - Sudden change of behavior Reply with quote
I expect a change of behavior in SQL Editor when connecting to a MySQL Server. When I issued a USE mydatabase statement in 7.1.228 Pro I could see the context change reflecting in SQL Editor. After upgrading to 7.1.244 this no longer seem to work. Executing the statement returns without any error messages but the context remains unchanged.
Fri Dec 05, 2014 12:45 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
Which connection type are you using? MySQLlib, ODBC, or ADO.NET?
Fri Dec 05, 2014 1:57 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2165

Post Reply with quote
I'm usually using ODBC but this one is not connection type dependent. I experience it with all connection types.
Fri Dec 05, 2014 6:44 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
Thank you. We were able to reproduce that issue, it also affects SQL Server and Sybase ASE connections and isolated to database context switch via code execution now processed by a separate thread in a cloned connection. Hopefully a fix for that will be developed very soon.
Fri Dec 05, 2014 7:24 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2165

Post Reply with quote
Hmm, what do you mean by cloned connection? Is the clone dropped after execution? Isn't that going to negatively affect eg. session/connection dependent user variables (set during execution or in a snippet custom query but not existing afterwards)?
Fri Dec 05, 2014 7:37 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
I'm not sure, but the related ticket has top priority assigned to it.
Fri Dec 05, 2014 8:11 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
Please upgrade to 7.1.246
Mon Dec 08, 2014 3:29 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2165

Post Reply with quote
Problem solved, thank you very much.
Mon Dec 08, 2014 5:17 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.