Smart Rename Filtered Index

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Smart Rename Filtered Index

Postby danfountain » Mon Mar 25, 2013 4:00 pm

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: Select all
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: Select all
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
danfountain
 
Posts: 8
Joined: Mon Jun 25, 2012 9:43 am

Postby danfountain » Wed Mar 27, 2013 10:16 am

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
danfountain
 
Posts: 8
Joined: Mon Jun 25, 2012 9:43 am

Postby eddie davis » Wed Mar 27, 2013 5:25 pm

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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests

cron