Skip to content

Columnstore index build error #719

@jvdslikke

Description

@jvdslikke
  • SqlPackage or DacFx Version: I don't know, how to find out? I only use dotnet build.
  • .NET Framework (Windows-only) or .NET Core: .NET Core 10.0.100-rc.1.25451.107 (from dotnet --version)
  • Environment (local platform and source/target platforms): Microsoft.Build.Sql 2.0.0

Steps to Reproduce:

  1. Create new SQL Project: dotnet new sqlproj -n ProductsTutorial
  2. Add table with columnstore index:
CREATE TABLE [dbo].[Product](
    [ProductID] [int] IDENTITY(1,1) NOT NULL,
    [ProductName] [nvarchar](200) NOT NULL,
    index ix clustered columnstore
);
  1. Build with: dotnet build
  2. Observe the error: product.sql(4,5,4,5): Build error SQL46010: Incorrect syntax near 'index'.

Did this occur in prior versions? If not - which version(s) did it work in? I don't know

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions