summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/r/innodb_multi_update.result
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2020-12-14 18:25:08 +0100
committerSergei Golubchik <serg@mariadb.org>2020-12-19 11:44:42 +0100
commita587ded283d8abd1f20258b283911abe759f5f64 (patch)
treed9c40466c58df8661bd11de698b4eee101cfac30 /mysql-test/suite/innodb/r/innodb_multi_update.result
parent5785de72ac85ba37eda837c691aaf9a9195ba45d (diff)
downloadmariadb-git-a587ded283d8abd1f20258b283911abe759f5f64.tar.gz
MDEV-24346 valgrind error in main.precedence
in queries like create view v1 as select 2 like 1 escape (3 in (select 0 union select 1)); select 2 union select * from v1; Item_func_like::escape was left uninitialized, because Item_in_optimizer is const_during_execution() but not actually const_item() during execution. It's not, because const subquery evaluation was disabled for derived. Practically it only needs to be disabled for multi-update that runs fix_fields() before all tables are locked.
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb_multi_update.result')
-rw-r--r--mysql-test/suite/innodb/r/innodb_multi_update.result1
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb_multi_update.result b/mysql-test/suite/innodb/r/innodb_multi_update.result
index 64f9ebc2fc2..93bd4e6716c 100644
--- a/mysql-test/suite/innodb/r/innodb_multi_update.result
+++ b/mysql-test/suite/innodb/r/innodb_multi_update.result
@@ -81,4 +81,5 @@ CREATE TABLE t1(f1 INT) ENGINE=INNODB;
INSERT INTO t1 VALUES(1);
UPDATE (SELECT ((SELECT 1 FROM t1), 1) FROM t1 WHERE (SELECT 1 FROM t1)) x, (SELECT 1) AS d SET d.f1 = 1;
ERROR 21000: Operand should contain 1 column(s)
+UPDATE (SELECT ((SELECT 1 FROM t1),1) = (1,1) FROM t1 WHERE (SELECT 1 FROM t1)) x, t1 AS d SET d.f1 = 1;
DROP TABLE t1;