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.]