diff options
| author | unknown <sanja@montyprogram.com> | 2014-02-05 20:35:11 +0200 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2014-02-05 20:35:11 +0200 |
| commit | 52311b72e6aee3fec0dc13f4273138f7aeea7d71 (patch) | |
| tree | cea3548235426688ce80bd07a46c82c24c6ea58a /mysql-test/r/ps.result | |
| parent | f68eac2eadb9bdb3d9c3554b37d6c253f04562d2 (diff) | |
| parent | bfdbb17990b198ff2a7e5eda5e2a365a1c6d8906 (diff) | |
| download | mariadb-git-52311b72e6aee3fec0dc13f4273138f7aeea7d71.tar.gz | |
merge 10.0-base ->10.0
Diffstat (limited to 'mysql-test/r/ps.result')
| -rw-r--r-- | mysql-test/r/ps.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result index bfec91192a9..4ac47bb8554 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -4019,4 +4019,25 @@ c1 NULL 2 DROP TABLE t1,t2; +# +# MDEV-5369: Wrong result (0 instead of NULL) on 2nd execution of +# PS with LEFT JOIN, TEMPTABLE view +# +CREATE TABLE t1 (a INT) ENGINE=MyISAM; +INSERT INTO t1 VALUES (0),(8); +CREATE TABLE t2 (pk INT PRIMARY KEY) ENGINE=MyISAM; +CREATE ALGORITHM=TEMPTABLE VIEW v2 AS SELECT * FROM t2; +SELECT SUM(pk) FROM t1 LEFT JOIN v2 ON a = pk; +SUM(pk) +NULL +PREPARE stmt FROM "SELECT SUM(pk) FROM t1 LEFT JOIN v2 ON a = pk"; +EXECUTE stmt; +SUM(pk) +NULL +EXECUTE stmt; +SUM(pk) +NULL +DEALLOCATE PREPARE stmt; +DROP VIEW v2; +DROP TABLE t1, t2; # End of 5.3 tests |