Microsoft KB Archive/68259

PRSQL9012031: GP-Fault in SAF with smallint ID Number: Q68259

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9012031

SYMPTOMS A table that has a column defined as “smallint” will GP-fault SAF when the following query is run:

SELECT col1        /* col1 is defined as smallint */ FROM mytable COMPUTE MAX(col1)  /* or, COMPUTE MIN(col1) */ In addition to the above situation, this error will also occur in SAF when using the MIN and MAX functions on columns defined as “tinyint”. However, the other row-aggregate functions (SUM, AVG, and COUNT) work correctly in both ISQL and SAF.

RESOLUTION Microsoft has confirmed this to be a problem in SQL version 1.1. This problem has been corrected in an updated version of SAF that is available from Microsoft Product Support Services. For more information, contact your authorized Network Specialist, [or Microsoft Inside Sales at (800) 227-4679.]