Comment 1 for bug 890404

Mark Callaghan (mdcallag) wrote :

Testcase after porting this to the facebook patch -->

--source include/have_innodb_plugin.inc

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

CREATE TABLE t3 (a INT primary key, b text) ENGINE=InnoDB;
INSERT INTO t3 VALUES (1,'');

SET autocommit=1;
SET innodb_fake_changes=1;

--error ER_ERROR_DURING_COMMIT
UPDATE t3 set b=lpad('b',11000,'c') where a=1;