diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2017-07-06 23:26:18 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-07-06 23:47:38 +0200 |
| commit | 6b99859fff6b8c0a52ea45965834c9c3fdfc4cb3 (patch) | |
| tree | d28e5f54a500f279b3353107215fd33c3d32fd7e /mysql-test/t/subselect.test | |
| parent | 89dc445a55156881318ca94ce042dbaf98e53e26 (diff) | |
| download | mariadb-git-6b99859fff6b8c0a52ea45965834c9c3fdfc4cb3.tar.gz | |
after-merge fix for a7ed4644a6f
(10.0+ changes, as specified in the MDEV)
and remove unused variable (compiler warning)
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index c9b2d88e9c4..7b18e6b4cf5 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -6002,11 +6002,17 @@ INSERT INTO t2 VALUES (3); CREATE ALGORITHM=MERGE VIEW v2 AS SELECT * FROM t2; +--error ER_WRONG_GROUP_FIELD +SELECT ( SELECT MIN(t2.f2) FROM t1 ) AS sq FROM t2 GROUP BY sq; +--error ER_WRONG_GROUP_FIELD SELECT ( SELECT MIN(v2.f2) FROM t1 ) AS sq FROM v2 GROUP BY sq; SELECT * FROM v2 where ( SELECT MIN(v2.f2) FROM t1 ) > 0; SELECT count(*) FROM v2 group by ( SELECT MIN(v2.f2) FROM t1 ); delete from t1; +--error ER_WRONG_GROUP_FIELD +SELECT ( SELECT MIN(t2.f2) FROM t1 ) AS sq FROM t2 GROUP BY sq; +--error ER_WRONG_GROUP_FIELD SELECT ( SELECT MIN(v2.f2) FROM t1 ) AS sq FROM v2 GROUP BY sq; drop view v2; |