Percona Server moved to https://jira.percona.com/projects/PS

SELECTs fail if both fake_changes and autocommit enabled

Bug #1067346 reported by Laurynas Biveinis on 2012-10-16

This bug report is a duplicate of: Bug #1382745: CREATE table .. SELECT * from <table> fails if destination table is from other SE that is not aware of fake-changes. Edit Remove

This bug affects 1 person

	Status	Importance	Assigned to
Percona Server moved to https://jira.percona.com/projects/PS	Confirmed	Undecided	Unassigned
5.1	Confirmed	Undecided	Unassigned
5.5	Confirmed	Undecided	Unassigned

--source include/have_innodb_plugin.inc

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;

INSERT INTO t1 VALUES (1);

SET innodb_fake_changes=1;
SELECT * FROM t1; # failed: 1180: Got error 131 during COMMIT

SET innodb_fake_changes=0;
DROP TABLE t1;

This report contains Public information

Everyone can see this information.

You are

Subscribing...

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