Schema Compare failed: Unexpected exception ...: Unable to cast object of type 'System.Boolean' to type 'System.Int32'.
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 460
- Forks
- 29
- Avg merge
- 4d 9h
- Merged PRs (30d)
- 7
Description
This bug was first reported on ADS platform. But after an initial triage and testing, it seems to be an issue emanating from the DacFx side of the code.
** copy of the original bug https://github.com/microsoft/azuredatastudio/issues/24551
- Azure Data Studio Version:1.46.0
- OS Version: Windows 10 Enterprise - 10.0.19044
I have two Synapse Serverless Instances DWH Prod & UAT.
I am trying to compare schemas. Loading the servers as Source and destination Yields:
Schema Compare failed: Unexpected exception caught during population of target model: Unable to cast object of type 'System.Boolean' to type 'System.Int32'.
Unexpected exception caught during population of source model: Unable to cast object of type 'System.Boolean' to type 'System.Int32'.
Note:
- There are no boolean or bit fields in these serverless db instances.
- Error occurs in about 3 seconds
- All my (6) other Serverless synapse dbs work fine.
**
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the linked Azure Data Studio report and reproduce Schema Compare against the failing Synapse Serverless source and destination instances, comparing them with the six working databases. Trace the DacFx-side model population indicated by the error and confirm completion when both models load and schema comparison no longer raises the Boolean-to-Int32 cast exception.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, csharp, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100