Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Dacfx fails to publish the dacpac while creating the non-clustered index when table has disabled clustered index #386

Closed
ssreerama opened this issue Jan 30, 2024 · 0 comments
Assignees
Labels
bug Something isn't working fixed-pending-release Fix in upcoming release
Milestone

Comments

@ssreerama
Copy link

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

As per the docs we cannot Create non-clustered index when the table has its Clustered index disabled. But when the source database has both indexes and cluster is disabled, extracting the dacpac and publishing ii is failing. As the deployment plan has the steps for creating clustered index and then disabling it and later it tries to create the non-clustered index.

Steps to Reproduce:

  1. Create a table and create clustered index and non-clustered indices
  2. Disable the clustered index (Engine will automatically disables the non-clustered index)
  3. Extract the dacpac
  4. Publish the dacpac to a new database, publish fails due to clustered index was created and disabled first and then creating non-cluster index fails.

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

(DacFx/SqlPackage/SSMS/Azure Data Studio)

@ssreerama ssreerama added the bug Something isn't working label Jan 30, 2024
@ssreerama ssreerama self-assigned this Jan 30, 2024
@ssreerama ssreerama changed the title Dacfx failing to create the non-clustered index when table has disabled clustered index Dacfx fails to publish the dacpac while creating the non-clustered index when table has disabled clustered index Jan 30, 2024
@ssreerama ssreerama added the fixed-pending-release Fix in upcoming release label Feb 8, 2024
@llali llali added this to the 162.2 milestone Feb 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working fixed-pending-release Fix in upcoming release
Projects
None yet
Development

No branches or pull requests

3 participants