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/subselect_sj_mat.test | |
| 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/subselect_sj_mat.test')
| -rw-r--r-- | mysql-test/main/subselect_sj_mat.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/subselect_sj_mat.test b/mysql-test/main/subselect_sj_mat.test index ac0baee3728..c66ca575de7 100644 --- a/mysql-test/main/subselect_sj_mat.test +++ b/mysql-test/main/subselect_sj_mat.test @@ -1859,9 +1859,9 @@ drop database mysqltest4; CREATE TABLE t1 (a INT NOT NULL) ENGINE=MyISAM; INSERT INTO t1 VALUES (0),(8); -SELECT a FROM (SELECT DISTINCT * FROM t1) AS sq WHERE a IN (SELECT MIN(t2.a) FROM t1 AS t2); +SELECT a FROM (SELECT DISTINCT * FROM t1) AS sq WHERE a IN (SELECT MIN(t2.a) FROM (t1 AS t2)); PREPARE stmt FROM " -SELECT a FROM (SELECT DISTINCT * FROM t1) AS sq WHERE a IN (SELECT MIN(t2.a) FROM t1 AS t2) +SELECT a FROM (SELECT DISTINCT * FROM t1) AS sq WHERE a IN (SELECT MIN(t2.a) FROM (t1 AS t2)) "; execute stmt; execute stmt; |