Microsoft KB Archive/124980

{|
 * width="100%"|

The information in this article applies to:
 * Microsoft SQL Server version 4.2 for OS/2

BUG# OS/2: 1860 (4.2)

SYMPTOMS
Selecting the MAX value from a column that is defined as INT NOT NULL and is the fourth column in a table may result in an access violation on SQL Server.

STATUS
Microsoft has confirmed this to be a problem in SQL Server 4.2 for OS/2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION
The table may be wider than 4 columns, but MAX should be selected from the fourth column and columns 1-3 should be 4 bytes wide.

Here is a brief script to demonstrate the problem:

use pubs go  drop table t1   go   create table t1(c1 int, c2 int, c3 int, c4 int) go  declare @counter int select @counter = 0 while @counter < 400 begin insert t1 values(@counter,@counter,@counter,@counter) select @counter = @counter + 1 end go  select max(c4) from t1   go
 * }

-

Last reviewed: April 30, 1997

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.