Skip to content

Columnstore index build error #719

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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