Full-text indexing bug when used with image columns
grantph
Posts: 7
Hello Support,
I have database table that uses full text indexes on image columns. When using image columns, SQL Server requires a second column indicating the extension. Example: Data image, DataExt char(4)
When SQL Compare generates script to update a second database it writes something like this:
-- Full text information
....
sp_fulltext_column N'[dbo].[t_Table]', N'Data', 'add', 1033
GO
....
This subsequently throws an error as the sp_fulltext_column stored proc is missing a parameter - the extension. It should read:
-- Full text information
....
sp_fulltext_column N'[dbo].[t_Table]', N'Data', 'add', 1033, N'DataExt'
GO
....
I'm running version 3.1.8.276 I have been able to work around the problem by running the script in QA and making manual modifications but its becoming a nuisance bug as our databases grow.
Otherwise, the product has been excellent!
Regards,
Grant.
I have database table that uses full text indexes on image columns. When using image columns, SQL Server requires a second column indicating the extension. Example: Data image, DataExt char(4)
When SQL Compare generates script to update a second database it writes something like this:
-- Full text information
....
sp_fulltext_column N'[dbo].[t_Table]', N'Data', 'add', 1033
GO
....
This subsequently throws an error as the sp_fulltext_column stored proc is missing a parameter - the extension. It should read:
-- Full text information
....
sp_fulltext_column N'[dbo].[t_Table]', N'Data', 'add', 1033, N'DataExt'
GO
....
I'm running version 3.1.8.276 I have been able to work around the problem by running the script in QA and making manual modifications but its becoming a nuisance bug as our databases grow.
Otherwise, the product has been excellent!
Regards,
Grant.
This discussion has been closed.
Comments
Thanks for pointing this out. We are currently working on a fix for this. Full-text indexes work just fine for text, but for image columns, the necessary final parameter is missing in the script produced by SQL Compare.