microsoft / microsoft/DacFx

Cannot publish update to Graph Edges

Open
#96 1 comment 2 reactions 0 assignees View on GitHub
bug sql-feature
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

- SqlPackage or DacFx Version: Running 64-bit SqlPackage Version 16.0.5400.1 on .NET Framework

**Steps to Reproduce:**

1. In Visual Studio project: Create a SQL Graph Edge table with zero columns
2. Publish
3. Insert some data into the table
4. In Visual Studio project: Add an index to the Edge table (still zero columns)
5. Publish

The script attempts to move the contents of the table to a temp table. When it does this, there is a script error because the SELECT clause has zero columns (also does not have the $from_id, $to_id) and publish can NEVER complete.

Please note: This is not only blocking, this is a devastating error crippling our whole pipeline.

Contributor guide

Open the contributing guide

Research direction

The issue names no source file or test. Start by reproducing the zero-column SQL Graph Edge table workflow in a Visual Studio project with 64-bit SqlPackage 16.0.5400.1, then trace the publish operation that runs after adding the index. Done means the populated table publishes successfully without a script error.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.