diff options
| author | unknown <igor@olga.mysql.com> | 2006-12-13 00:39:13 -0800 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2006-12-13 00:39:13 -0800 |
| commit | 2f78d5ca81e39c55aa918758a1f9b4e46ce76d74 (patch) | |
| tree | c4a565af72d4013055969672539b96fb64e4e886 /mysql-test/t/ps.test | |
| parent | 22192d083ace932c5ee2c29b550012648ebf245e (diff) | |
| download | mariadb-git-2f78d5ca81e39c55aa918758a1f9b4e46ce76d74.tar.gz | |
Fixed bug #25027.
Removed an assertion that was not valid for the cases where the query
in a prepared statement contained a single-row non-correlated
subquery that was used as an argument of the IS NULL predicate.
mysql-test/r/ps.result:
Added a test case for bug #25027.
mysql-test/t/ps.test:
Added a test case for bug #25027.
Diffstat (limited to 'mysql-test/t/ps.test')
| -rw-r--r-- | mysql-test/t/ps.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test index 547f9a766d1..9386436a1fd 100644 --- a/mysql-test/t/ps.test +++ b/mysql-test/t/ps.test @@ -1563,4 +1563,22 @@ execute sq; deallocate prepare no_index; deallocate prepare sq; +# +# Bug 25027: query with a single-row non-correlated subquery +# and IS NULL predicate +# + +CREATE TABLE t1 (a int); +INSERT INTO t1 VALUES (1), (2); +CREATE TABLE t2 (b int); +INSERT INTO t2 VALUES (NULL); + +SELECT a FROM t1 WHERE (SELECT b FROM t2) IS NULL; +PREPARE stmt FROM 'SELECT a FROM t1 WHERE (SELECT b FROM t2) IS NULL'; + +EXECUTE stmt; + +DEALLOCATE PREPARE stmt; +DROP TABLE t1,t2; + --echo End of 5.0 tests. |