SUPPORT / SAMPLES & SAS NOTES
Problem Note 65947: A FedSQL procedure hash join incorrectly returns zero rows in SAS® Cloud Analytic Services (CAS)
 |  |  |  |  |
In CAS, a PROC FedSQL hash join that joins a CAS view with an in-line view incorrectly returns zero rows.
Here is an example of a join that would trigger the issue:
data mycas.x;
x='abcdefghijklmnopqrstuvwxyz';
run;
x='abcdefghijklmnopqrstuvwxyz';
run;
* Create a CAS view against the table. ;
proc cas;
view name='v' tables={{name='x'}};
quit;
proc cas;
view name='v' tables={{name='x'}};
quit;
* Join the view with a subquery that produces an intermediate result. ;
* The join should return 1 row. ;
proc cas;
fedsql.execdirect query="
select
*
from
v, (select distinct * from x) x
where
v.x = x.x";
quit;
* The join should return 1 row. ;
proc cas;
fedsql.execdirect query="
select
*
from
v, (select distinct * from x) x
where
v.x = x.x";
quit;
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Microsoft Windows 10 | 3.4 | Viya | ||
| Microsoft Windows Server 2012 Datacenter | 3.4 | Viya | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 3.4 | Viya | ||||
| Microsoft Windows Server 2012 R2 Std | 3.4 | Viya | ||||
| Microsoft Windows Server 2012 Std | 3.4 | Viya | ||||
| Microsoft Windows Server 2016 | 3.4 | Viya | ||||
| Microsoft Windows Server 2019 | 3.4 | Viya | ||||
| Linux for x64 | 3.4 | Viya | ||||