V6-SQL-C613 PROC SQL may generate memory errors when using Set Operators

Host specific memory errors may be produced during an optimization phasewhen PROC SQL attempts to eliminate unnecessary SORT steps in conjunction with any of the Set Operators (EXCEPT, EXCEPT ALL, INTERSECT, INTERSECT ALL, UNION or UNION ALL).

The memory errors may include, but are not limited to the following:

    UNIX:
       ERROR: SEGMENTATION VIOLATION CAPTURED IN TASK 'SQL'.
       ERROR: GENERIC CRITICAL ERROR.
    WIN95/WIN3.1:
       ERROR: UNKNOWN EXCEPTION(80000602).
       ERROR: A SEVERE ERROR OCCURRED IN TASK SQL FOR MODULE
              SASSQXO EXECUTING IN MODULE SASSQXO AT ADDRESS ########.
    MVS:
       ERROR: SYSTEM ABEND 0C4 OCCURRED IN FUNCTION ZSORT AT 000372.

This problem is fixed at Release 6.12 TSLEVEL 040 and beyond, and Release 6.09E TSLEVEL 455 and beyond.

System	Release Reported	Release Fixed
AIX/6000	6.11 TS020	6.12 TS045
HP-UX Operating Systems	6.11 TS020	6.12 TS045
IBM OS/2	6.11 TS020	6.12 TS045
Solaris	6.11 TS020	6.12 TS045
Windows 3.11	6.11 TS020	6.12 TS045
AIX/6000	6.12 TS020	6.12 TS045
VM/ESA (CMS)	6.08 TS404	6.09 TS455
OS/390 (MVS)	6.08 TS404	6.09 TS455
OpenVMS VAX	6.08 TS404	6.09 TS455
VSE/ESA (VSE)	6.08 TS404
HP-UX Operating Systems	6.12 TS020	6.12 TS045
IBM OS/2	6.12 TS020	6.12 TS045
Solaris	6.12 TS020	6.12 TS045
OpenVMS Alpha	6.12 TS020	6.12 TS045
Windows 3.11	6.12 TS020	6.12 TS045
Windows NT	6.12 TS020	6.12 TS045
Windows 95	6.12 TS020	6.12 TS045

No Fixes Available