MySQL Forums
Forum List  »  InnoDB

Re: potential bug and/or not understanding behavior
Posted by: Peter Brawley
Date: August 21, 2022 10:34PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: potential bug and/or not understanding behavior
60
August 21, 2022 10:34PM


Sorry, only registered users may post in this forum.

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.