PRSQL9103011: Duplicate Values with a Unique Clustered Index

ID Number: Q70831

1.10

OS/2

buglist1.10 fixlist1.11

Summary:

PROBLEM ID: PRSQL9103011

SYMPTOMS

An update within a transaction is allowed to create a duplicate

value on a column with a unique clustered index. In addition,

paging errors occur on the index.

CAUSE

This problem is a result of using a clustered index on the table

referenced within the transaction.

WORKAROUND

Drop and re-create the index to remove the paging errors. Use a

nonclustered index instead of a clustered index to avoid this

problem.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version

1.1. This problem has been corrected in SQL Server version 1.11,

which is available from Microsoft Product Support Services. For

more information, contact your primary support provider.