1CREATE TABLE t1(a DECIMAL NOT NULL) ENGINE=InnoDB;
2CREATE TABLE t2(
3b INT,
4c INT UNSIGNED NOT NULL,
5d FLOAT,
6PRIMARY KEY(b)
7) ENGINE=InnoDB;
8CREATE VIEW v AS SELECT * FROM t2;
9INSERT INTO t2 VALUES (1, 0, 0);
10UPDATE v SET d=3 WHERE c < ALL(SELECT b FROM t1);
11DROP VIEW v;
12DROP TABLE t1, t2;
13