|
From: Gerd W. <ger...@t-...> - 2022-08-21 19:44:06
|
Am 20.08.22 um 22:30 schrieb crystal via Squirrel-sql-users: > Hi all- > > It seems that in the same session (i hit new sql tab) even after i click > autocommit off it seems to save the update before it is committed. > > I am also wondering if that is part of the reason why when i run this > query that only one transaction id shows: > > SELECT tx.trx_id > FROM information_schema.innodb_trx tx > WHERE tx.trx_mysql_thread_id = connection_id() > > please check it out and let me know when you have a chance. > Sorry, I can't reproduce or don't understand your problem. Here's what I tried: 1. Switch autocommit off 2. Change some data, then select the data in the same Session --> The change is visible. Open another Session (i.e. another connection) the change is _not_ visible. Whenever I open a new SQL tab (ctrl+n) in the first Session the change is visible there, too. This is because the SQL tab belongs to the first Session and uses the same connection. This behavior is right and as intended. To my understanding it also matches the result of your innodb_trx select statement. Perhaps you expect a SQL tab to use its own connection. This is not what SQL tabs are meant to do. To use another connection you should open a new Session. Gerd |
