VIEW CHECK OPTION malfunctions with multi UPDATE

  --source include/have_innodb.inc

  CREATE TABLE t1 (id INT, x INT) ENGINE=InnoDB;

  CREATE TABLE t2 (id INT, a INT) ENGINE=InnoDB;

  CREATE TABLE t3 (id INT) ENGINE=InnoDB;

  INSERT INTO t1 VALUES (1,100),(2,200);

  INSERT INTO t2 VALUES (1,1),(2,2),(3,3);

  INSERT INTO t3 VALUES (1),(2);

  CREATE VIEW v AS SELECT t2.* FROM t2 JOIN t3 ON t2.id = t3.id

    WHERE t2.a < 1000 WITH CHECK OPTION;

  --error 0,ER_VIEW_CHECK_FAILED

  UPDATE t1, v SET v.a= v.a + t1.x;

  SELECT * FROM t2;

  --error 0,ER_VIEW_CHECK_FAILED

  UPDATE t1, v SET v.a= 5 ORDER BY t1.x;

  SELECT * FROM t2;

  --error 0,ER_VIEW_CHECK_FAILED

  UPDATE t1, v SET v.a= v.a + t1.x ORDER BY t1.x;

  SELECT * FROM t2;

  DROP VIEW v; DROP TABLE t1, t2, t3;