Bug #13635 | Setting variables does not work as expected | ||
---|---|---|---|
Submitted: | 30 Sep 2005 7:33 | Modified: | 30 Sep 2005 12:05 |
Reporter: | John Beasley | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Query Browser | Severity: | S2 (Serious) |
Version: | 1.1.15 (and .14) | OS: | Windows (XP Pro SP2) |
Assigned to: | Mike Lischke | CPU Architecture: | Any |
[30 Sep 2005 7:33]
John Beasley
[30 Sep 2005 12:05]
Mike Lischke
This is not a bug. QB uses dynamich connections when executing a query (in opposition to the MySQL shell). So once the query is finished all things that are connection specific are gone, including variables. In order to avoid that start a transaction. In this situation the connection stays constant until the transaction is committed. Mike