diff options
| author | unknown <igor@olga.mysql.com> | 2007-01-26 17:10:45 -0800 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2007-01-26 17:10:45 -0800 |
| commit | 1495924319c1b6fab0261a7206e872f43f0c4857 (patch) | |
| tree | c6913f1f16af767947932cddd38f22dc4edfaebb /mysql-test/r/subselect3.result | |
| parent | 4f118f1d76948b7f84f4497297d6f3b1f91b8fd2 (diff) | |
| download | mariadb-git-1495924319c1b6fab0261a7206e872f43f0c4857.tar.gz | |
Fixed bug #24420.
Objects of the classes Item_func_is_not_null_test and Item_func_trig_cond
must be transparent for the method Item::split_sum_func2 as these classes
are pure helpers. It means that the method Item::split_sum_func2 should
look at those objects as at pure wrappers.
mysql-test/r/subselect3.result:
Added a test case for bug #24420.
mysql-test/t/subselect3.test:
Added a test case for bug #24420.
Diffstat (limited to 'mysql-test/r/subselect3.result')
| -rw-r--r-- | mysql-test/r/subselect3.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/subselect3.result b/mysql-test/r/subselect3.result index 07ff17c9df9..29143b9e504 100644 --- a/mysql-test/r/subselect3.result +++ b/mysql-test/r/subselect3.result @@ -629,3 +629,19 @@ cc NULL NULL aa 1 1 bb NULL NULL drop table t1,t2; +create table t1 (a int, b int); +insert into t1 values (0,0), (2,2), (3,3); +create table t2 (a int, b int); +insert into t2 values (1,1), (3,3); +select a, b, (a,b) in (select a, min(b) from t2 group by a) Z from t1; +a b Z +0 0 0 +2 2 0 +3 3 1 +insert into t2 values (NULL,4); +select a, b, (a,b) in (select a, min(b) from t2 group by a) Z from t1; +a b Z +0 0 0 +2 2 0 +3 3 1 +drop table t1,t2; |