autcommit vs. manual commit behavior

[Aaron Couts]

Hello,

I've noticed some behavior that indicates a difference between autocommit and manual commit. I'm working on mysql v4.0.21 and v4.1.18, on Redhat Enterprise Linux v3.0, using InnoDB tables.

If I have two mysql sessions open, here's what happens:

Scenario 1:
Session 1: Autocommit == 0. I make a change to a record and commit manually.
Session 2: I can't see the change in the record unless I quit and log back into mysql.

Scenario 2:
Session 1: Autocommit == 1. I make a change to a record.
Session 2: I can see the change immediately.

I see the same behavior when session 1 is a perl script rather than a mysql session.

Is this a known issue? Is there a workaround in v4, or does v5 resolve this? I have been searching for this issue but have not been able to find it online or in the mysql documentation.

Thanks,
Aaron