Object Level Recovery restoring filtered indexes missing index WHERE clause (205203)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Object Level Recovery restoring filtered indexes missing index WHERE clause
Description

When restoring a table with a filtered index using Object Level Recovery, the filtered index is restored but missing the WHERE clause, rendering the filtered index as a nonfiltered index.
e.g.
Original:
CREATE INDEX [IX_Filtered] ON [dbo].[OLR_Test]
(
[Value] ASC
)
WHERE ([Value]>(50))
WITH (PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON
)
ON [PRIMARY]
GO

Generated by OLR:
CREATE INDEX [IX_Filtered] ON [dbo].[OLR_Test]
(
[Value] ASC
)
WITH (PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON
)
ON [PRIMARY]
GO
Cause

Product Defect
Resolution

WORKAROUND:
Contact Support to acquire a patch for LiteSpeed 8.2

STATUS:
Will be fixed in the future release.
Defect ID

CR119598

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title