diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2015-01-25 16:16:25 +0100 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2015-01-25 16:16:25 +0100 |
| commit | fb71449b10100e9a0f887b1585000fbfab294f3c (patch) | |
| tree | 4af39c47d7a291b60721f6468648f49af0f5d85d /mysql-test/r/group_by_innodb.result | |
| parent | d1c4ff2b2cd54886087b6b879a6ea23f66d6582f (diff) | |
| download | mariadb-git-fb71449b10100e9a0f887b1585000fbfab294f3c.tar.gz | |
MDEV-5719: Wrong result with GROUP BY and LEFT OUTER JOINmariadb-10.0.16
Merged revision 5224 from mysql-5.6 and added a test case.
..
revno: 5224
committer: Sergey Glukhov <sergey.glukhov@oracle.com>
branch nick: mysql-5.6
timestamp: Wed 2013-06-19 14:24:08 +0400
message:
Bug#16620047 INCORRECT QUERY RESULT (AFTER SERVER UPGRADE)
Diffstat (limited to 'mysql-test/r/group_by_innodb.result')
| -rw-r--r-- | mysql-test/r/group_by_innodb.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/group_by_innodb.result b/mysql-test/r/group_by_innodb.result index 4b5d9990c51..1098579a82d 100644 --- a/mysql-test/r/group_by_innodb.result +++ b/mysql-test/r/group_by_innodb.result @@ -57,3 +57,26 @@ i GROUP_CONCAT( d1, d2 ORDER BY d1, d2 ) NULL 11.1,22.2 DROP TABLE t1; End of 5.5 tests +# +# MDEV-5719: Wrong result with GROUP BY and LEFT OUTER JOIN +# +CREATE TABLE t1 (oidGroup INT, oid INT PRIMARY KEY)ENGINE=INNODB; +INSERT INTO t1 VALUES (1,1),(1,2),(1,3),(1,4); +CREATE TABLE t2 (oid INT PRIMARY KEY)ENGINE=INNODB; +INSERT INTO t2 VALUES (3); +SELECT a.oidGroup, a.oid, b.oid FROM t1 a LEFT JOIN t2 b ON +a.oid=b.oid WHERE a.oidGroup=1; +oidGroup oid oid +1 1 NULL +1 2 NULL +1 3 3 +1 4 NULL +SELECT a.oidGroup, a.oid, b.oid FROM t1 a LEFT JOIN t2 b ON +a.oid=b.oid WHERE a.oidGroup=1 GROUP BY a.oid; +oidGroup oid oid +1 1 NULL +1 2 NULL +1 3 3 +1 4 NULL +DROP TABLE t1, t2; +# End of tests |