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/r/ps.result | |
| 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/r/ps.result')
| -rw-r--r-- | mysql-test/r/ps.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result index 234c12955d9..b5a9367c985 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -1514,4 +1514,19 @@ Variable_name Value Slow_queries 1 deallocate prepare no_index; deallocate prepare sq; +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; +a +1 +2 +PREPARE stmt FROM 'SELECT a FROM t1 WHERE (SELECT b FROM t2) IS NULL'; +EXECUTE stmt; +a +1 +2 +DEALLOCATE PREPARE stmt; +DROP TABLE t1,t2; End of 5.0 tests. |