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/r/subselect_no_semijoin.result | |
| 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/r/subselect_no_semijoin.result')
| -rw-r--r-- | mysql-test/r/subselect_no_semijoin.result | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/mysql-test/r/subselect_no_semijoin.result b/mysql-test/r/subselect_no_semijoin.result index 774c18020d8..3896adbfdd2 100644 --- a/mysql-test/r/subselect_no_semijoin.result +++ b/mysql-test/r/subselect_no_semijoin.result @@ -7112,9 +7112,10 @@ INSERT INTO t1 VALUES (1),(2); CREATE TABLE t2 (f2 INT, KEY(f2)); INSERT INTO t2 VALUES (3); CREATE ALGORITHM=MERGE VIEW v2 AS SELECT * FROM t2; +SELECT ( SELECT MIN(t2.f2) FROM t1 ) AS sq FROM t2 GROUP BY sq; +ERROR 42000: Can't group on 'sq' SELECT ( SELECT MIN(v2.f2) FROM t1 ) AS sq FROM v2 GROUP BY sq; -sq -3 +ERROR 42000: Can't group on 'sq' SELECT * FROM v2 where ( SELECT MIN(v2.f2) FROM t1 ) > 0; f2 3 @@ -7122,9 +7123,10 @@ SELECT count(*) FROM v2 group by ( SELECT MIN(v2.f2) FROM t1 ); count(*) 1 delete from t1; +SELECT ( SELECT MIN(t2.f2) FROM t1 ) AS sq FROM t2 GROUP BY sq; +ERROR 42000: Can't group on 'sq' SELECT ( SELECT MIN(v2.f2) FROM t1 ) AS sq FROM v2 GROUP BY sq; -sq -NULL +ERROR 42000: Can't group on 'sq' drop view v2; drop table t1,t2; # |