Cannot publish update to Graph Edges
- 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
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