Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.0
-
None
Description
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
|
CREATE TABLE t2 (b INT, c INT, KEY(b)) ENGINE=InnoDB PARTITION BY HASH(c) PARTITIONS 2;
|
CREATE ALGORITHM = MERGE VIEW v AS SELECT a, b FROM t1 STRAIGHT_JOIN t2 WHERE b = 'foo' WITH CHECK OPTION;
|
|
INSERT INTO t1 VALUES (1),(2);
|
INSERT IGNORE INTO t2 VALUES (2,2),('three',3),(4,4);
|
UPDATE v SET a = NULL ORDER BY a, b;
|
above will be error with prepared statements due to check at the end of multi_update_precheck()