diff options
author | Igor Babaev <igor@askmonty.org> | 2019-05-06 11:14:39 -0700 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2019-05-06 11:14:39 -0700 |
commit | fd386e39cd384cd738231c0c65f7d3dee4eac7c9 (patch) | |
tree | 2e473fab422de6a1bcb22acfd037aa1934625d6b /mysql-test/main/union.result | |
parent | b8259e4b599e0968ebe8c9ae11e8855f42b188f5 (diff) | |
download | mariadb-git-fd386e39cd384cd738231c0c65f7d3dee4eac7c9.tar.gz |
MDEV-18689 Simple query with extra brackets stopped working
Parenthesis around table names and derived tables should be allowed
in FROM clauses and some other context as it was in earlier versions.
Returned test queries that used such parenthesis in 10.3 to their
original form. Adjusted test results accordingly.
Diffstat (limited to 'mysql-test/main/union.result')
-rw-r--r-- | mysql-test/main/union.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/union.result b/mysql-test/main/union.result index a0421bae922..559eafc2282 100644 --- a/mysql-test/main/union.result +++ b/mysql-test/main/union.result @@ -2034,14 +2034,14 @@ SET @@global.slow_query_log= @old_slow_query_log; CREATE TABLE t1 (a int); CREATE TABLE t2 (b int); CREATE TABLE t3 (c int); -SELECT a FROM t1 UNION SELECT b FROM t2 JOIN t3 ON ( t2.b = t3.c ); +SELECT a FROM t1 UNION SELECT b FROM t2 JOIN (t3) ON ( t2.b = t3.c ); a DROP TABLE t1, t2, t3; CREATE TABLE t1 (pk int NOT NULL); CREATE TABLE t2 (pk int NOT NULL, fk int NOT NULL); -SELECT t1.pk FROM t1 LEFT JOIN t2 ON (t1.pk = t2.fk) +SELECT t1.pk FROM t1 LEFT JOIN (t2) ON (t1.pk = t2.fk) UNION -SELECT t1.pk FROM t1 LEFT JOIN t2 ON (t1.pk = t2.fk); +SELECT t1.pk FROM t1 LEFT JOIN (t2) ON (t1.pk = t2.fk); pk DROP TABLE t1,t2; create table t1 (a int); |