diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2014-03-16 13:59:44 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2014-03-16 13:59:44 +0100 |
| commit | e772cbd7b774add42821c33b13ea052f8c9e2e6e (patch) | |
| tree | 0411c732161ad4fc4f49a02ee78abaa6632c6d4d /mysql-test/t/join_outer.test | |
| parent | 8428c116c7cc1fb6a04345637a10084810874dd8 (diff) | |
| parent | d7304375e5e0ce30979c2b92e70eb0effaa30a25 (diff) | |
| download | mariadb-git-e772cbd7b774add42821c33b13ea052f8c9e2e6e.tar.gz | |
5.1 merge
Diffstat (limited to 'mysql-test/t/join_outer.test')
| -rw-r--r-- | mysql-test/t/join_outer.test | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index 01f1980b4c1..ce13842357a 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -1160,6 +1160,36 @@ EXECUTE prep_stmt; DROP TABLE t1; +--echo # +--echo # Bug#13068506 - QUERY WITH GROUP BY ON NON-AGGR COLUMN RETURNS +--echo # WRONG RESULT +--echo # + +CREATE TABLE t1 (i1 int); +INSERT INTO t1 VALUES (100), (101); + +CREATE TABLE t2 (i2 int, i3 int); +INSERT INTO t2 VALUES (20,1),(10,2); + +CREATE TABLE t3 (i4 int(11)); +INSERT INTO t3 VALUES (1),(2); + +let $query= SELECT ( + SELECT MAX( t2.i2 ) + FROM t3 RIGHT JOIN t2 ON ( t2.i3 = 2 ) + WHERE t2.i3 <> t1.i1 +) AS field1 +FROM t1; + +--echo +--eval $query; +--echo +--eval $query GROUP BY field1; + +--echo +drop table t1,t2,t3; + +--echo # End of test for Bug#13068506 --echo End of 5.1 tests |