Smart Rename Filtered Index
I have found a little bug in smart rename. On the object i rename i have a filtered index that looks like this:
CREATE UNIQUE NONCLUSTERED INDEX [IX_UNQ_Name] ON [Config].[tbl_Users] ( [Name] ASC ) WHERE ([Name] IS NOT NULL) WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
However when it recreates the index on a smart rename (its dropped at the start) it does this:
CREATE UNIQUE NONCLUSTERED INDEX [IX_UNQ_Name] ON [dbo].[tblmi_Usersx] ([Name]) WITH (FILLFACTOR=100, PAD_INDEX=ON) ON [PRIMARY]
Missing the most the where clause. This causes my rename script to fail.