diff options
| author | unknown <sanja@montyprogram.com> | 2014-01-29 00:19:53 +0200 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2014-01-29 00:19:53 +0200 |
| commit | 84e7f2c23b471ed2a870572b418372c5aa9243c9 (patch) | |
| tree | 307e53d79e42f4b2eff175b9db80e32f79e9ab78 /mysql-test/r/ps.result | |
| parent | 6b6d40fa6ca1fe36f2a51c2723c58dfb3fc025bb (diff) | |
| parent | 08293a35e663f79a95b9e6c719bd45b7c5870d57 (diff) | |
| download | mariadb-git-84e7f2c23b471ed2a870572b418372c5aa9243c9.tar.gz | |
merge of MDEV-5369 (5.3->5.5)
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 cc348e849e3..70fc9177cfc 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 |