Operational Defect Database

BugZero found this defect 130 days ago.

Microsoft SQL Server | 2782283

Consider the following scenario: - You create a table that has a full-text index. - The full-text index fragment is partitioned because it's too large. - You clone the database and then run DBCC CHECKDB to check the clone database. In this scenario, the command fails and the following error 2601 occurs: Msg 2601, Level 14, State 1, Line <LineNumber> Cannot insert duplicate key row in object '<ObjectName>' with unique index '<IndexName>'. The duplicate key value is <KeyValue>.

Last update date:

1/11/2024

Affected products:

SQL Server 2022 on Linux

SQL Server 2022 on Windows

Affected releases:

build lower than 16.0.4105.2

Fixed releases:

16.0.4105.2

Description:

Consider the following scenario: - You create a table that has a full-text index. - The full-text index fragment is partitioned because it's too large. - You clone the database and then run DBCC CHECKDB to check the clone database. In this scenario, the command fails and the following error 2601 occurs: Msg 2601, Level 14, State 1, Line <LineNumber> Cannot insert duplicate key row in object '<ObjectName>' with unique index '<IndexName>'. The duplicate key value is <KeyValue>.

Additional Resources / Links

Share:

BugZero® Risk Score

What's this?

Coming soon

Status

Unavailable

Learn More

Search:

...