Operational Defect Database

BugZero found this defect 459 days ago.

Microsoft SQL Server | 2116348

Fixes error 692 that occurs when you create a non-clustered index under the following scenario: - A clustered index already exists in the table. - You create a non-clustered index that has the resumable option. - The non-clustered index has an INCLUDE clause that has the key columns from the clustered index but in a different order. Error message: Msg 692, Level 22, State 1, line <LineNumber> Internal error. Buffer provided to write a fixed column value is too large. Run DBCC CHECKDB to check for any corruption. NOTE Specifying the included columns in the same order as in the clustered index or removing them from the INCLUDE clause can prevent the error.

Last update date:

2/16/2023

Affected products:

SQL Server 2019 on Linux

SQL Server 2019 on Windows

Affected releases:

build lower than 15.0.4298.1

Fixed releases:

15.0.4298.1

Description:

Fixes error 692 that occurs when you create a non-clustered index under the following scenario: - A clustered index already exists in the table. - You create a non-clustered index that has the resumable option. - The non-clustered index has an INCLUDE clause that has the key columns from the clustered index but in a different order. Error message: Msg 692, Level 22, State 1, line <LineNumber> Internal error. Buffer provided to write a fixed column value is too large. Run DBCC CHECKDB to check for any corruption. NOTE Specifying the included columns in the same order as in the clustered index or removing them from the INCLUDE clause can prevent the error.

Additional Resources / Links

Share:

BugZero® Risk Score

What's this?

Coming soon

Status

Unavailable

Learn More

Search:

...