Incorrect textualization of SQL Implicit Pass-Through queries occurs when you combine multiple inner joins with the UNION operator.

Because of incorrect textualization of PROC SQL Implicit Pass-Through, the following query may fail with a parse error:

   data a; x=42; run;
   data b; x=42; run;

   proc sql;
   select * from
   (
      (
        (select a.x from a inner join b on a.x=b.x)
      union
        (select a.x from a inner join b on a.x=b.x)
      )
      union
      (select a.x from a inner join b on a.x=b.x)
   );
   quit;

The failure of SQL Implicit Pass-Through will cause all rows to be returned to SAS for processing, which could result in poor performance.

The problem has been observed with SAS® Scalable Performance Data Server and with MySQL database.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: