From de745ecf29721795710910a19bd0ea3389da804c Mon Sep 17 00:00:00 2001 From: Oleksandr Byelkin Date: Tue, 22 May 2018 19:08:39 +0200 Subject: MDEV-11953: support of brackets in UNION/EXCEPT/INTERSECT operations --- mysql-test/main/deadlock_innodb.result | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/main/deadlock_innodb.result') diff --git a/mysql-test/main/deadlock_innodb.result b/mysql-test/main/deadlock_innodb.result index af78a6aa9d5..fca0ff6be0c 100644 --- a/mysql-test/main/deadlock_innodb.result +++ b/mysql-test/main/deadlock_innodb.result @@ -72,7 +72,7 @@ insert into t1 values(0, 0), (300, 300); insert into t2 values(0, 0), (1, 20), (2, 30); commit; connection con1; -select a,b from t2 UNION SELECT id, x from t1 FOR UPDATE; +select a,b from t2 UNION (SELECT id, x from t1 FOR UPDATE); a b 0 0 20 1 -- cgit v1.2.1