Re: potential bug and/or not understanding behavior

[Peter Brawley]

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.