non-transactional changed tables couldn't be rolled back

Bug #746720 reported by Barry Leslie
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
New
Undecided
Unassigned

Bug Description

If you insert or update a non transaction table out side of a transaction and then start
a transaction using a transaction table which is then rolled back you get the warning:

Warning (Code 1196): Some non-transactional changed tables couldn't be rolled back

This is because the "transaction.stmt.reset()" was not called after the first implicit transaction.

Example:
Start the server with --plugin-add=pbms

pbms_metadata is a non transaction system table.

drizzle> create table t4(c1 int) engine = "InnoDB";
drizzle> warnings
drizzle> delete from pbms_metadata;
drizzle> begin;
drizzle> insert into t4 values(2);
drizzle> rollback

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.