2315898 - A query with hash vector aggregate could return wrong results - SAP ASE

• A join query with group by clause may return an incorrect result set if a scalar/vector aggregate operator is placed under a join operator.
• here is the query which returns 0 row, but it should return 2 rows

if bs_11 of TEST_BS and pt_01 of TEST_PT are tinyint, smallint, numeric(9) or decimal(9).

1> select BS.bs_04 , BS.bs_11
2>   from TEST_PT PT , TEST_BS BS
3>  where BS.bs_11 = 17
4>    and BS.bs_11 = PT.pt_01
5>    and PT.pt_02 = 3
6>  group by BS.bs_04, BS.bs_11
7> go
bs_04  bs_11
------ -----

(0 rows affected)

if bs_11 of TEST_BS and pt_01 of TEST_PT are int, numeric(10) or decimal(10), the above query returns 2 rows correctly.

1> select BS.bs_04 , BS.bs_11
2>   from TEST_PT PT , TEST_BS BS
3>  where BS.bs_11 = 17
4>    and BS.bs_11 = PT.pt_01
5>    and PT.pt_02 = 3
6>  group by BS.bs_04, BS.bs_11
7> go
bs_04  bs_11
------ -----------
010             17
009             17

(2 rows affected)

Hash aggregate, join operator, scalar, vector, HashvectAgg operator, NLJ operator, CR726439, CR#726439, 726439 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed