Skip to content

Dacpac parsing fails when a Database View has STRING_SPLIT #848

@smo7sin

Description

@smo7sin

**Describe the bug**
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

  1. Create a Database1
  2. Add a Table1 with columns
  3. Create a View as follows:
    CREATE VIEW [dbo].[View1] AS SELECT Id, s.Value Schedule FROM [Table1] t CROSS APPLY STRING_SPLIT(t.Name, ';') s
  4. Create a dacpac of Database1
  5. Ssdt Parser will give a null reference exception

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots

Image

Environment (please complete the following information):

  • Database: [e.g. SQLite]
  • Nuget Package and version: [e.g. SQLProvider 1.5.12]
  • Dotnet or .NET Framework and version [e.g. dotnet 8]

Additional context
Add any other context about the problem here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions