Bug #58912 InnoDB unnecessarily avoids update-in-place on column prefix indexes

Description:
This is forked from Bug #55284. The function row_upd_changes_ord_field_binary() returns TRUE if the update vector changes a column that is covered by a prefix index, but does not change the column prefix. In this case, it should return FALSE, so that the record can be updated in place.

It is unclear if this bug used to be a mere performance issue, or if it could cause corruption. When I tested my fix of Bug #55284, this bug caused corruption.

How to repeat:
Set a breakpoint on row_upd_changes_ord_field_binary() and run the following:

CREATE TABLE bug55284 (a BLOB, b TEXT, PRIMARY KEY(a(1))) ENGINE=InnoDB;
INSERT INTO bug55284 VALUES(REPEAT('a',8000),REPEAT('b',8000));
UPDATE bug55284 SET a=REPEAT('a',7999);

Suggested fix:
Pass row_ext_t to row_upd_changes_ord_field_binary() and check whether the index prefixes really change before returning TRUE.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/127361

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/127362

Pushed into mysql-trunk 5.6.2 (revid:vasil.dimov@oracle.com-20110108150732-8qygun7nuaqf9d3u) (version source revid:vasil.dimov@oracle.com-20110108150646-44c9j7ck64ocey31) (merge vers: 5.6.2) (pib:24)

Pushed into mysql-5.5 5.5.9 (revid:vasil.dimov@oracle.com-20110108150508-gpanhz48z8069qot) (version source revid:vasil.dimov@oracle.com-20110108150048-b1y9m8xe72hay0ch) (merge vers: 5.5.9) (pib:24)

Pushed into mysql-5.1 5.1.55 (revid:vasil.dimov@oracle.com-20110108145923-0tjqdpa5w3d6tuwn) (version source revid:vasil.dimov@oracle.com-20110108145923-0tjqdpa5w3d6tuwn) (merge vers: 5.1.55) (pib:24)

Adding to change log:

An UPDATE statement for an InnoDB table could be slower than
necessary if it changed a column covered by a prefix index, but did
not change the prefix portion of the value. The fix improves
performance for InnoDB 1.1 in MySQL 5.5 and higher, and the InnoDB
Plugin for MySQL 5.1.

This introduced a compiler warning which breaks by sandbox build, Bug #59585.

Changelog entry appears in 5.6.2, 5.5.9, 5.1.55.