SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 30549: SAS SPD Server giving incorrect results for a LIKE statement with a escape clause

DetailsHotfixAboutRate It
Prior to SAS SPD Server 4.4 TSM3, if you issued a SELECT statement containing a LIKE
clause, the results returned were incorrect. Here is an example of code that would
produce incorrect results:

   proc sql;
      select * from libname.table where x like 'abc\_xyz' escape '\';
   quit;

If you issued the same code through a query with explicit pass-through, you would 
receive a parsing error.

Changes have been made in SPD Server 4.4 TSM3 so that the server can handle the 
SQL and return correct results, but SQL generated by SPD Server with a LIKE and 
ESCAPE clause will still fail with a parsing error.


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SPDSScalable Performance Data ServerTru64 UNIX4.44.43.0 TS M0
Solaris for x644.44.43.0 TS M0
HP-UX IPF4.44.43.0 TS M0
64-bit Enabled Solaris4.44.43.0 TS M0
64-bit Enabled HP-UX4.44.43.0 TS M0
64-bit Enabled AIX4.44.43.0 TS M0
Windows4.44.43.0 TS M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.