microsoft / microsoft/DacFx

Add computed columns support to System-versioned temporal tables

Open
#207 11 comments 5 reactions 0 assignees View on GitHub
enhancement
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

- SqlPackage or DacFx Version: Any
- .NET Framework (Windows-only) or .NET Core: Any
- Environment (local platform and source/target platforms):

**Steps to Reproduce:**

1. Create a temporal system versioning table with computed column
2. Try to deploy it.
3. You will see the "System-versioned temporal tables with computed columns are not supported." even though this is supported in SQL server.

**Did this occur in prior versions? If not - which version(s) did it work in?**

(DacFx/SqlPackage/SSMS/Azure Data Studio)

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the deployment described in the issue: create a SQL Server system-versioned temporal table with a computed column and deploy it. Trace the temporal-table validation that reports computed columns as unsupported, then verify that deployment succeeds for this schema without breaking existing temporal-table checks.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.