Re: potential bug and/or not understanding behavior
In both WB and the mysql client program ...
drop table if exists a1;
create table a1( foo int primary key, bar char(2) );
insert into a1 set foo=2,bar='xx';
start transaction;
update a1 set bar = 'qy' where foo = 2;
SELECT * FROM information_schema.innodb_trx;
... returns one row. Then ...
commit;
SELECT * FROM information_schema.innodb_trx;
returns 0 rows.
Edited 1 time(s). Last edit at 08/22/2022 09:11AM by Peter Brawley.
Subject
Views
Written By
Posted
902
August 21, 2022 07:26PM
381
August 21, 2022 09:01PM
517
August 21, 2022 10:07PM
357
August 21, 2022 10:21PM
Re: potential bug and/or not understanding behavior
623
August 21, 2022 10:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.