Comment 1 for bug 534806

Revision history for this message
Jay Pipes (jaypipes) wrote :

After much ado, Eric and I have narrowed this down to a reproduceable test case. Yeah! \o/. It turns out that AUTOCOMMIT=0 and LIMIT 0 together are the culprit, and the following test case will hit always assert:

SET AUTOCOMMIT = 0;
CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY);
COMMIT;
UPDATE t1 SET id = 2 WHERE id != 2 LIMIT 0;
SAVEPOINT A;