Red Gate forums :: View topic - Smart Rename Filtered Index
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

Smart Rename Filtered Index

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
danfountain



Joined: 25 Jun 2012
Posts: 8

PostPosted: Mon Mar 25, 2013 4:00 pm    Post subject: Smart Rename Filtered Index Reply with quote

Hi,

I have found a little bug in smart rename. On the object i rename i have a filtered index that looks like this:

Code:
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:

Code:
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.

Many thanks

Dan
Back to top
View user's profile Send private message
danfountain



Joined: 25 Jun 2012
Posts: 8

PostPosted: Wed Mar 27, 2013 10:16 am    Post subject: Reply with quote

Sorry just to clarify (sorry i cut the wrong bit out of a script).

The names of the indexes should be the same. The only bit which is causing a problem is the missing where clause.

The first part is what the index currently looks like. The second part is what is attempted to be put back on by rename on the renamed table.

Dan
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Wed Mar 27, 2013 5:25 pm    Post subject: Reply with quote

Hi

Thank you for your forum post and sorry that you have encountered a problem.

I was able to recreate the bug using your example, therefore I have submitted a bug report, the bug report reference is SP-4661.

At this time I have no further information as to when this bug will be fixed, but I will be maintaining what our bug tracking system calls a 'watch' on the bug report submitted. This means I will be able to update this forum post when the bug is fixed at some point in the future.

Thank you for bringing this problem to our attention.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group