Where clause bug?
sqlpadawan
Posts: 6
This afternoon ran a sql data compare using a where clause to filter the data in a table to compare. When I used the deployment wizard, I ended up with sql statements with two where clauses:
EXEC(N'UPDATE [dbo].[Table1] SET [Col1]=5.56, [Col2]=8.55, [Col3]=42.00, [Col4]=''RC '', [Col5]=''2015-07-08 00:00:00.000'', [Col6]=''2015-07-07 20:50:06.193'', [Col7]=2.50 WHERE [Col8] = 9 AND [Col9] = ''XX'' AND [Col10] = 2 AND [Col11] = 19742985 AND (WHERE [Col11] IN ( 2993304, 2993519, 3025220, 3081347, 3085337, 3092625, 3093660, 3156319, 3223346, 3270582, 3341110, 19742985)
This was the where clause in the project to filter the data in the compare: (WHERE [Col11] IN ( 2993304, 2993519, 3025220, 3081347, 3085337, 3092625, 3093660, 3156319, 3223346, 3270582, 3341110, 19742985)
Is this a bug or did I do something wrong?
EXEC(N'UPDATE [dbo].[Table1] SET [Col1]=5.56, [Col2]=8.55, [Col3]=42.00, [Col4]=''RC '', [Col5]=''2015-07-08 00:00:00.000'', [Col6]=''2015-07-07 20:50:06.193'', [Col7]=2.50 WHERE [Col8] = 9 AND [Col9] = ''XX'' AND [Col10] = 2 AND [Col11] = 19742985 AND (WHERE [Col11] IN ( 2993304, 2993519, 3025220, 3081347, 3085337, 3092625, 3093660, 3156319, 3223346, 3270582, 3341110, 19742985)
This was the where clause in the project to filter the data in the compare: (WHERE [Col11] IN ( 2993304, 2993519, 3025220, 3081347, 3085337, 3092625, 3093660, 3156319, 3223346, 3270582, 3341110, 19742985)
Is this a bug or did I do something wrong?
Comments
Thanks for your post!
I will follow up with you via email to resolve this issue.
Warm Regards,
Andrew Pierce
Technical Sales Engineer
Redgate Software