Parsing Errors with Clustered Columnstore Index
delvs1977
Posts: 2
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!
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!
Comments
This issue has been fixed in version 5.4.1 of SQL Source Control.
Thank you,
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools