Parsing Errors with Clustered Columnstore Index

delvs1977

Hi Everyone,

When I link SQL Source Control 5.3 to a in memory, clustered columntore index in SQL Server 2016 I receive an error when I try to "Get Latest".

For example, I have
Create table dbo.SomeTable
(
Field1 BIGINT,
CONSTRAINT [PrimaryKey] PRIMARY KEY NONCLUSTERED ([Field1]),
INDEX [SomeTableCCI] CLUSTERED COLUMNSTORE
)
WITH
(
MEMORY_OPTIMIZED = ON
)
GO;

The source control tool generates the SQL perfectly. I commit it using GIT. Then, when I re-load SQL Server Management Studio (SSMS) and try to get latest, it throws an error -- "There was an error parsing the file .....".

When I go to source control, copy and paste the file into SSMS the SQL syntax is correct. If I remove the line "INDEX [SomeTableCCI] CLUSTERED COLUMNSTORE" and re-commit it into source control then try to "get latest" it processes the table correctly. I am unable to create an index on a table that is in memory. I really want to use in memory clustered columnstore and my syntax is correct.

Is there a patch for this available? or a setting where I can have it ignore parse errors? Please help...thanks!

Sergio R

Hi,

This issue has been fixed in version 5.4.1 of SQL Source Control.

Thank you,