diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2017-07-12 15:54:04 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-07-12 17:46:27 +0200 |
| commit | 181d9d2892739629382727cf956364106c947ea2 (patch) | |
| tree | 4116ea810625a942cbcd99d84107db78768b8c47 /mysql-test/r/group_by.result | |
| parent | 05b678bc8c166c9015ca3dc3ccd9e9c89094f3ca (diff) | |
| download | mariadb-git-181d9d2892739629382727cf956364106c947ea2.tar.gz | |
MDEV-13180 Unused left join causes server crash
already fixed by be55bbc2b20
just add a test case
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 7744d98bc11..b948c9a6f88 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -2545,6 +2545,14 @@ select from t4; ERROR 42S22: Reference 'field7' not supported (reference to group function) drop table t1, t2, t3, t4; +create table t1 (i1 int); +insert into t1 values (1); +create table t2 (i int); +insert into t2 values (2); +select 1 from t1 left join t2 b on b.i = (select max(b.i) from t2); +1 +1 +drop table t1, t2; create table t1 (c1 int, c2 int); create table t2 (c1 int, c2 int); select t1.c1 as c1, t2.c2 as c1 from t1, t2 where t1.c1 < 20 and t2.c2 > 5 group by t1.c1, t2.c2 having t1.c1 < 3; |