diff options
| author | Igor Babaev <igor@askmonty.org> | 2022-07-11 16:57:37 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2023-03-15 17:35:22 -0700 |
| commit | 88ca62dc689fa66d798c129a101069946acc828c (patch) | |
| tree | 2ed5405f9a24f2ca16e7e99cf097d6f3771d3619 /mysql-test/main/derived_cond_pushdown.test | |
| parent | 3a9358a4106a1bd0ae2414f6f0bda50afdd65f0a (diff) | |
| download | mariadb-git-88ca62dc689fa66d798c129a101069946acc828c.tar.gz | |
MDEV-28965 Assertion failure when preparing UPDATE with derived table in WHERE
This patch fixes not only the assertion failure in the function
Field_iterator_table_ref::set_field_iterator() but also:
- fixes the problem of forced materialization of derived tables used
in subqueries contained in WHERE clauses of single-table and multi-table
UPDATE and DELETE statements
- fixes the problem of MDEV-17954 that prevented execution of multi-table
DELETE statements if they use in their WHERE clauses references to
the tables that are updated.
The patch must be considered a complement to the patch for MDEV-28883.
Approved by Oleksandr Byelkin <sanja@mariadb.com>
Diffstat (limited to 'mysql-test/main/derived_cond_pushdown.test')
| -rw-r--r-- | mysql-test/main/derived_cond_pushdown.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/derived_cond_pushdown.test b/mysql-test/main/derived_cond_pushdown.test index 26b44488e1d..47c1f9c20f2 100644 --- a/mysql-test/main/derived_cond_pushdown.test +++ b/mysql-test/main/derived_cond_pushdown.test @@ -2219,7 +2219,7 @@ DROP TABLE t1; CREATE TABLE t1 (f1 text, f2 int); INSERT INTO t1 VALUES ('x',1), ('y',2); -CREATE VIEW v1 AS SELECT f2 FROM ( SELECT f2 FROM t1 ) AS t; +CREATE VIEW v1 AS SELECT f2 FROM ( SELECT f2 FROM t1 GROUP BY f2) AS t; let $q1 = UPDATE v1, t1 SET t1.f1 = 'z' WHERE v1.f2 < 2 AND t1.f2 = v1.f2; eval $q1; |