diff options
| author | unknown <igor@rurik.mysql.com> | 2004-09-07 19:46:09 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2004-09-07 19:46:09 -0700 |
| commit | 3be674036fa9adc961a3100ea69dd7c7fa6675e4 (patch) | |
| tree | 6b4d2d0566207823bf99bb46602fc6d497449426 /mysql-test | |
| parent | 49d90b09f558b30adf1578dfcaf7d094e51609bd (diff) | |
| download | mariadb-git-3be674036fa9adc961a3100ea69dd7c7fa6675e4.tar.gz | |
func_group.test, func_group.result:
Added test case for bug #5406.
opt_sum.cc:
Fixed bug #5406.
sql/opt_sum.cc:
Fixed bug #5406.
mysql-test/r/func_group.result:
Added test case for bug #5406.
mysql-test/t/func_group.test:
Added test case for bug #5406.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_group.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/func_group.test | 16 |
2 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index 06259ff4931..011a47874c2 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -684,3 +684,12 @@ max(a) 2 deallocate prepare stmt1; drop table t1; +CREATE TABLE t1 (a int primary key); +INSERT INTO t1 VALUES (1),(2),(3),(4); +SELECT MAX(a) FROM t1 WHERE a > 5; +MAX(a) +NULL +SELECT MIN(a) FROM t1 WHERE a < 0; +MIN(a) +NULL +DROP TABLE t1; diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index 74f4c1bad44..7f48f2b92bd 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -418,3 +418,19 @@ execute stmt1; execute stmt1; deallocate prepare stmt1; drop table t1; + +# +# Bug #5406 min/max optimization for empty set +# + +CREATE TABLE t1 (a int primary key); +INSERT INTO t1 VALUES (1),(2),(3),(4); + +SELECT MAX(a) FROM t1 WHERE a > 5; +SELECT MIN(a) FROM t1 WHERE a < 0; + +DROP TABLE t1; + + + + |