diff options
| author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-07-09 14:46:46 +0400 |
|---|---|---|
| committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-07-09 14:46:46 +0400 |
| commit | 024dba64b64f395151f6b95650e8ee69a1591428 (patch) | |
| tree | 1d80637254b45550c8fcffe6c715050b6c1c4a0b /mysql-test/r/having.result | |
| parent | 0d80d45a6dce3c9c4169895c009b141a07e8e907 (diff) | |
| parent | 013136364c95b7bcc5a987dd301b042f31dab1f9 (diff) | |
| download | mariadb-git-024dba64b64f395151f6b95650e8ee69a1591428.tar.gz | |
5.1-bugteam->trunk-merge merge
Diffstat (limited to 'mysql-test/r/having.result')
| -rw-r--r-- | mysql-test/r/having.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/having.result b/mysql-test/r/having.result index c69de0f307b..daf043860a4 100644 --- a/mysql-test/r/having.result +++ b/mysql-test/r/having.result @@ -532,3 +532,19 @@ Warnings: Warning 1292 Truncated incorrect INTEGER value: 'd' DROP TABLE t1,t2; End of 5.0 tests +# +# Bug#54416 MAX from JOIN with HAVING returning NULL with 5.1 and Empty set +# +CREATE TABLE t1 (f1 INT(11), f2 VARCHAR(1), PRIMARY KEY (f1)); +INSERT INTO t1 VALUES (1,'f'); +CREATE TABLE t2 (f1 INT(11), f2 VARCHAR(1)); +INSERT INTO t2 VALUES (2,'m'); +INSERT INTO t2 VALUES (3,'m'); +INSERT INTO t2 VALUES (11,NULL); +INSERT INTO t2 VALUES (12,'k'); +SELECT MAX(t1.f1) field1 +FROM t1 JOIN t2 ON t2.f2 LIKE 'x' +HAVING field1 < 7; +field1 +DROP TABLE t1,t2; +End of 5.1 tests |