Red Gate forums :: View topic - Filtered index syntax error: WHERE and WITH clauses swapped
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Data Compare 10
SQL Data Compare 10 forum

Filtered index syntax error: WHERE and WITH clauses swapped

 Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
shawnC



Joined: 22 Nov 2011
Posts: 7
PostPosted: Mon Oct 29, 2012 11:08 am    Post subject: Filtered index syntax error: WHERE and WITH clauses swapped Reply with quote
SQL Data Compare 10.2.3.5 (and earlier) generates incorrect syntax for restoring filtered indexes that have a FILLFACTOR clause

The WHERE and WITH clauses are the wrong way around

What is generated:

Code:
CREATE UNIQUE NONCLUSTERED INDEX [IXU_Foo] ON [Data].[Bar] ([BarID], [BarName]) WITH (FILLFACTOR=90)  WHERE ([BarName] IS NOT NULL) ON [PRIMARY]


This means that I have to use SQL Compare to fix the schema after synchronizing data and can't trust SQL Data Compare

Can this be fixed please?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
PostPosted: Tue Oct 30, 2012 3:39 pm    Post subject: Reply with quote
I'm sorry you have encountered this issue. I will be responding to you via email with the information relevant to troubleshooting this problem.

Thanks!
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
Back to top
View user's profile Send private message
shawnC



Joined: 22 Nov 2011
Posts: 7
PostPosted: Tue Oct 30, 2012 5:16 pm    Post subject: Reply with quote
Note: this *only* happens when you use a filtered index.

Using a WITH clause alone works OK. But not when you have a WITH and WHERE clause.

So there's no confusion...
_________________
http://stackexchange.com/users/13638/gbn
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
PostPosted: Tue Oct 30, 2012 5:39 pm    Post subject: Reply with quote
Thank you. I have logged a bug with our development team ( SDC-1502 ).
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
Back to top
View user's profile Send private message
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