azure-pipelines-public.yml

variables:
  - name: _BuildConfig
    value: Release
  - name: _TeamName
    value: AspNetCore
  - name: DOTNET_SKIP_FIRST_TIME_EXPERIENCE
    value: true
  - name: _PublishUsingPipelines
    value: true
  - name: _CosmosConnectionUrl
    value: https://localhost:8081
  - name: _CosmosToken
    value: C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw==
  - name: PostBuildSign
    value: false
  - name: _InternalRuntimeDownloadArgs
    value: ''
  - name: LC_ALL
    value: 'en_US.UTF-8'
  - name: LANG
    value: 'en_US.UTF-8'
  - name: LANGUAGE
    value: 'en_US.UTF-8'
  - template: /eng/common/templates/variables/pool-providers.yml

trigger:
  batch: true
  branches:
    include:
      - main
      - release/*
      - feature/*
      - internal/release/*

pr: none

stages:
- stage: build
  displayName: Build
  jobs:
    - template: eng/common/templates/jobs/jobs.yml
      parameters:
        continueOnError: true
        enableMicrobuild: true
        enablePublishBuildArtifacts: true
        enablePublishBuildAssets: true
        enablePublishUsingPipelines: ${{ variables._PublishUsingPipelines }}
        publishAssetsImmediately: true
        isAssetlessBuild: true
        enableSourceIndex: false
        enableTelemetry: true
        helixRepo: dotnet/efcore
        jobs:
          - job: Windows
            enablePublishTestResults: true
            timeoutInMinutes: 90
            pool:
              name: $(DncEngPublicBuildPool)
              demands: ImageOverride -equals 1es-windows-2022-open
            variables:
              - _InternalBuildArgs: ''
              # Rely on task Arcade injects, not auto-injected build step.
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
            steps:
              - task: NuGetCommand@2
                displayName: 'Clear NuGet caches'
                condition: succeeded()
                inputs:
                  command: custom
                  arguments: 'locals all -clear'
              - script: "echo ##vso[build.addbuildtag]daily-build"
                condition: and(notin(variables['Build.Reason'], 'PullRequest'), ne(variables['IsFinalBuild'], 'true'))
                displayName: 'Set CI tags'
              - script: "echo ##vso[build.addbuildtag]release-candidate"
                condition: and(notin(variables['Build.Reason'], 'PullRequest'), eq(variables['IsFinalBuild'], 'true'))
                displayName: 'Set CI tags'
              - script: eng\common\cibuild.cmd -configuration $(_BuildConfig) -prepareMachine /bl:artifacts\log\$(_BuildConfig)\Build.binlog $(_InternalBuildArgs)
                  $(_InternalRuntimeDownloadArgs) /p:CollectCoverage=true /p:SkipApiBaselineTests=true
                env:
                  Test__Cosmos__DefaultConnection: $(_CosmosConnectionUrl)
                  Test__SqlServer__DefaultConnection: "Data Source="
                name: Build
              - script: .dotnet\dotnet test test\EFCore.ApiBaseline.Tests -p:Configuration=$(_BuildConfig)
                displayName: Test API Baselines
                condition: succeeded()
              - powershell: |
                  $files = Get-ChildItem -Path 'artifacts\coverage' -Filter '*.cobertura.xml' -ErrorAction SilentlyContinue
                  if ($files) {
                    $env:PATH += ";$env:USERPROFILE\.dotnet\tools"
                    dotnet tool update --global dotnet-coverage
                    if ($LASTEXITCODE -ne 0) { dotnet tool install --global dotnet-coverage }
                    dotnet-coverage merge -o 'artifacts\coverage\coverage.cobertura.xml' -f cobertura $files.FullName
                  }
                displayName: Merge coverage reports
                condition: always()
                continueOnError: true
              - task: PublishCodeCoverageResults@2
                displayName: Publish code coverage
                inputs:
                  summaryFileLocation: artifacts/coverage/coverage.cobertura.xml
                condition: always()
                continueOnError: true
              - task: PublishBuildArtifacts@1
                displayName: Upload TestResults
                condition: always()
                continueOnError: true
                inputs:
                  pathtoPublish: artifacts/TestResults/$(_BuildConfig)/
                  artifactName: $(Agent.Os)_$(Agent.JobName) TestResults
                  artifactType: Container
                  parallel: true

          - job: Windows_SqlServer
            displayName: 'Windows SQL Server'
            enablePublishTestResults: true
            timeoutInMinutes: 120
            pool:
              name: $(DncEngPublicBuildPool)
              demands: ImageOverride -equals 1es-windows-2022-open
            variables:
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
            steps:
              - powershell: SqlLocalDB start
                displayName: Start LocalDB
              - script: eng\common\build.cmd -restore -build -test -ci -configuration $(_BuildConfig) -prepareMachine $(_InternalRuntimeDownloadArgs)
                  /p:CollectCoverage=true
                  /p:Projects="$(Build.SourcesDirectory)/test/EFCore.SqlServer.FunctionalTests/EFCore.SqlServer.FunctionalTests.csproj;$(Build.SourcesDirectory)/test/EFCore.SqlServer.HierarchyId.Tests/EFCore.SqlServer.HierarchyId.Tests.csproj;$(Build.SourcesDirectory)/test/EFCore.CrossStore.FunctionalTests/EFCore.CrossStore.FunctionalTests.csproj;$(Build.SourcesDirectory)/test/EFCore.OData.FunctionalTests/EFCore.OData.FunctionalTests.csproj;$(Build.SourcesDirectory)/test/EFCore.AspNet.SqlServer.FunctionalTests/EFCore.AspNet.SqlServer.FunctionalTests.csproj;$(Build.SourcesDirectory)/test/EFCore.VisualBasic.FunctionalTests/EFCore.VisualBasic.FunctionalTests.vbproj;$(Build.SourcesDirectory)/test/EFCore.FSharp.FunctionalTests/EFCore.FSharp.FunctionalTests.fsproj"
                displayName: Test SQL Server
              - powershell: |
                  $files = Get-ChildItem -Path 'artifacts\coverage' -Filter '*.cobertura.xml' -ErrorAction SilentlyContinue
                  if ($files) {
                    $env:PATH += ";$env:USERPROFILE\.dotnet\tools"
                    dotnet tool update --global dotnet-coverage
                    if ($LASTEXITCODE -ne 0) { dotnet tool install --global dotnet-coverage }
                    dotnet-coverage merge -o 'artifacts\coverage\coverage.cobertura.xml' -f cobertura $files.FullName
                  }
                displayName: Merge coverage reports
                condition: always()
                continueOnError: true
              - task: PublishCodeCoverageResults@2
                displayName: Publish code coverage
                inputs:
                  summaryFileLocation: artifacts/coverage/coverage.cobertura.xml
                condition: always()
                continueOnError: true
              - task: PublishBuildArtifacts@1
                displayName: Upload TestResults
                condition: always()
                continueOnError: true
                inputs:
                  pathtoPublish: artifacts/TestResults/$(_BuildConfig)/
                  artifactName: $(Agent.Os)_$(Agent.JobName) TestResults
                  artifactType: Container
                  parallel: true

          - job: macOS
            enablePublishTestResults: true
            pool:
              vmImage: macOS-15
            variables:
              # Rely on task Arcade injects, not auto-injected build step.
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
            steps:
              - script: eng/common/cibuild.sh --configuration $(_BuildConfig) --prepareMachine /bl:artifacts/log/$(_BuildConfig)/Build.binlog $(_InternalRuntimeDownloadArgs) /p:CollectCoverage=true /p:SkipApiBaselineTests=true
                env:
                  Test__Cosmos__DefaultConnection: $(_CosmosConnectionUrl)
                  COMPlus_EnableWriteXorExecute: 0 # Work-around for https://github.com/dotnet/runtime/issues/70758
                name: Build
              - bash: |
                  shopt -s nullglob
                  files=(artifacts/coverage/*.cobertura.xml)
                  if [ ${#files[@]} -gt 0 ]; then
                    export PATH="$PATH:$HOME/.dotnet/tools"
                    dotnet tool update --global dotnet-coverage || dotnet tool install --global dotnet-coverage
                    dotnet-coverage merge -o artifacts/coverage/coverage.cobertura.xml -f cobertura "${files[@]}"
                  fi
                displayName: Merge coverage reports
                condition: always()
                continueOnError: true
              - task: PublishCodeCoverageResults@2
                displayName: Publish code coverage
                inputs:
                  summaryFileLocation: artifacts/coverage/coverage.cobertura.xml
                condition: always()
                continueOnError: true
              - task: PublishBuildArtifacts@1
                displayName: Upload TestResults
                condition: always()
                continueOnError: true
                inputs:
                  pathtoPublish: artifacts/TestResults/$(_BuildConfig)/
                  artifactName: $(Agent.Os)_$(Agent.JobName) TestResults
                  artifactType: Container
                  parallel: true

          - job: Linux
            timeoutInMinutes: 120
            enablePublishTestResults: true
            pool:
              vmImage: ubuntu-22.04
            variables:
              # Rely on task Arcade injects, not auto-injected build step.
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
            steps:
              - script: eng/common/cibuild.sh --configuration $(_BuildConfig) --prepareMachine /bl:artifacts/log/$(_BuildConfig)/Build.binlog $(_InternalRuntimeDownloadArgs) /p:CollectCoverage=true /p:SkipApiBaselineTests=true
                env:
                  Test__Cosmos__DefaultConnection: $(_CosmosConnectionUrl)
                  Test__Cosmos__AuthToken: $(_CosmosToken)
                name: Build
              - bash: |
                  shopt -s nullglob
                  files=(artifacts/coverage/*.cobertura.xml)
                  if [ ${#files[@]} -gt 0 ]; then
                    export PATH="$PATH:$HOME/.dotnet/tools"
                    dotnet tool update --global dotnet-coverage || dotnet tool install --global dotnet-coverage
                    dotnet-coverage merge -o artifacts/coverage/coverage.cobertura.xml -f cobertura "${files[@]}"
                  fi
                displayName: Merge coverage reports
                condition: always()
                continueOnError: true
              - task: PublishCodeCoverageResults@2
                displayName: Publish code coverage
                inputs:
                  summaryFileLocation: artifacts/coverage/coverage.cobertura.xml
                condition: always()
                continueOnError: true
              - task: PublishBuildArtifacts@1
                displayName: Upload TestResults
                condition: always()
                continueOnError: true
                inputs:
                  pathtoPublish: artifacts/TestResults/$(_BuildConfig)/
                  artifactName: $(Agent.Os)_$(Agent.JobName) TestResults
                  artifactType: Container
                  parallel: true

          - job: Helix_Windows
            displayName: 'Helix Windows'
            timeoutInMinutes: 180
            pool:
              name: $(DncEngPublicBuildPool)
              demands: ImageOverride -equals 1es-windows-2022-open
            variables:
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
              - name: _HelixBuildConfig
                value: $(_BuildConfig)
              - name: HelixTargetQueues
                value: Windows.10.Amd64.Open
              - name: _HelixAccessToken
                value: ''
            steps:
              - task: NuGetCommand@2
                displayName: 'Clear NuGet caches'
                condition: succeeded()
                inputs:
                  command: custom
                  arguments: 'locals all -clear'
              - script: restore.cmd -ci /p:configuration=$(_BuildConfig) $(_InternalRuntimeDownloadArgs)
                displayName: Restore packages
              - script: .dotnet\dotnet build eng\helix.proj /restore /t:Test /p:configuration=$(_BuildConfig) /bl:artifacts/log/$(_BuildConfig)/SendToHelix.binlog $(_InternalRuntimeDownloadArgs)
                displayName: Send tests to helix
                env:
                  HelixAccessToken: $(_HelixAccessToken)
                  SYSTEM_ACCESSTOKEN: $(System.AccessToken)

          - job: Helix_Windows_SqlServer
            displayName: 'Helix Windows SQL Server'
            timeoutInMinutes: 180
            pool:
              name: $(DncEngPublicBuildPool)
              demands: ImageOverride -equals 1es-windows-2022-open
            variables:
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
              - name: _HelixBuildConfig
                value: $(_BuildConfig)
              - name: HelixTargetQueues
                value: Windows.11.Amd64.Client.Open
              - name: _HelixAccessToken
                value: ''
            steps:
              - task: NuGetCommand@2
                displayName: 'Clear NuGet caches'
                condition: succeeded()
                inputs:
                  command: custom
                  arguments: 'locals all -clear'
              - script: restore.cmd -ci /p:configuration=$(_BuildConfig) $(_InternalRuntimeDownloadArgs)
                displayName: Restore packages
              - script: .dotnet\dotnet build eng\helix.proj /restore /t:Test /p:configuration=$(_BuildConfig) /bl:artifacts/log/$(_BuildConfig)/SendToHelix.binlog $(_InternalRuntimeDownloadArgs)
                displayName: Send tests to helix
                env:
                  HelixAccessToken: $(_HelixAccessToken)
                  SYSTEM_ACCESSTOKEN: $(System.AccessToken)

          - job: Helix_Windows_Arm64
            displayName: 'Helix Windows ARM64'
            timeoutInMinutes: 180
            pool:
              name: $(DncEngPublicBuildPool)
              demands: ImageOverride -equals 1es-windows-2022-open
            variables:
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
              - name: _HelixBuildConfig
                value: $(_BuildConfig)
              - name: HelixTargetQueues
                value: Windows.11.Arm64.Open
              - name: _HelixAccessToken
                value: ''
            steps:
              - task: NuGetCommand@2
                displayName: 'Clear NuGet caches'
                condition: succeeded()
                inputs:
                  command: custom
                  arguments: 'locals all -clear'
              - script: restore.cmd -ci /p:configuration=$(_BuildConfig) $(_InternalRuntimeDownloadArgs)
                displayName: Restore packages
              - script: .dotnet\dotnet build eng\helix.proj /restore /t:Test /p:configuration=$(_BuildConfig) /bl:artifacts/log/$(_BuildConfig)/SendToHelix.binlog $(_InternalRuntimeDownloadArgs)
                displayName: Send tests to helix
                env:
                  HelixAccessToken: $(_HelixAccessToken)
                  SYSTEM_ACCESSTOKEN: $(System.AccessToken)

          - job: Helix_Windows_Cosmos
            displayName: 'Helix Windows Cosmos'
            timeoutInMinutes: 180
            pool:
              name: $(DncEngPublicBuildPool)
              demands: ImageOverride -equals 1es-windows-2022-open
            variables:
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
              - name: _HelixBuildConfig
                value: $(_BuildConfig)
              - name: HelixTargetQueues
                value: Windows.Server2025.Amd64.Open
              - name: _HelixAccessToken
                value: ''
            steps:
              - task: NuGetCommand@2
                displayName: 'Clear NuGet caches'
                condition: succeeded()
                inputs:
                  command: custom
                  arguments: 'locals all -clear'
              - script: restore.cmd -ci /p:configuration=$(_BuildConfig) $(_InternalRuntimeDownloadArgs)
                displayName: Restore packages
              - script: .dotnet\dotnet build eng\helix.proj /restore /t:Test /p:configuration=$(_BuildConfig) /bl:artifacts/log/$(_BuildConfig)/SendToHelix.binlog $(_InternalRuntimeDownloadArgs)
                displayName: Send tests to helix
                env:
                  HelixAccessToken: $(_HelixAccessToken)
                  SYSTEM_ACCESSTOKEN: $(System.AccessToken)

          - job: Helix_macOS_x64
            displayName: 'Helix macOS x64'
            timeoutInMinutes: 180
            pool:
              name: $(DncEngPublicBuildPool)
              demands: ImageOverride -equals 1es-windows-2022-open
            variables:
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
              - name: _HelixBuildConfig
                value: $(_BuildConfig)
              - name: HelixTargetQueues
                value: OSX.15.Amd64.Open
              - name: _HelixAccessToken
                value: ''
            steps:
              - task: NuGetCommand@2
                displayName: 'Clear NuGet caches'
                condition: succeeded()
                inputs:
                  command: custom
                  arguments: 'locals all -clear'
              - script: restore.cmd -ci /p:configuration=$(_BuildConfig) $(_InternalRuntimeDownloadArgs)
                displayName: Restore packages
              - script: .dotnet\dotnet build eng\helix.proj /restore /t:Test /p:configuration=$(_BuildConfig) /bl:artifacts/log/$(_BuildConfig)/SendToHelix.binlog $(_InternalRuntimeDownloadArgs)
                displayName: Send tests to helix
                env:
                  HelixAccessToken: $(_HelixAccessToken)
                  SYSTEM_ACCESSTOKEN: $(System.AccessToken)

          - job: Helix_macOS_ARM64
            displayName: 'Helix macOS ARM64'
            timeoutInMinutes: 180
            pool:
              name: $(DncEngPublicBuildPool)
              demands: ImageOverride -equals 1es-windows-2022-open
            variables:
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
              - name: _HelixBuildConfig
                value: $(_BuildConfig)
              - name: HelixTargetQueues
                value: OSX.15.ARM64.Open
              - name: _HelixAccessToken
                value: ''
            steps:
              - task: NuGetCommand@2
                displayName: 'Clear NuGet caches'
                condition: succeeded()
                inputs:
                  command: custom
                  arguments: 'locals all -clear'
              - script: restore.cmd -ci /p:configuration=$(_BuildConfig) $(_InternalRuntimeDownloadArgs)
                displayName: Restore packages
              - script: .dotnet\dotnet build eng\helix.proj /restore /t:Test /p:configuration=$(_BuildConfig) /bl:artifacts/log/$(_BuildConfig)/SendToHelix.binlog $(_InternalRuntimeDownloadArgs)
                displayName: Send tests to helix
                env:
                  HelixAccessToken: $(_HelixAccessToken)
                  SYSTEM_ACCESSTOKEN: $(System.AccessToken)

          - job: Helix_Ubuntu_SqlServer
            displayName: 'Helix Ubuntu SQL Server'
            timeoutInMinutes: 180
            pool:
              name: $(DncEngPublicBuildPool)
              demands: ImageOverride -equals 1es-windows-2022-open
            variables:
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
              - name: _HelixBuildConfig
                value: $(_BuildConfig)
              - name: HelixTargetQueues
                value: Ubuntu.2204.Amd64.XL.Open@mcr.microsoft.com/dotnet-buildtools/prereqs:ubuntu-22.04-helix-sqlserver-amd64
              - name: _HelixAccessToken
                value: ''
            steps:
              - task: NuGetCommand@2
                displayName: 'Clear NuGet caches'
                condition: succeeded()
                inputs:
                  command: custom
                  arguments: 'locals all -clear'
              - script: restore.cmd -ci /p:configuration=$(_BuildConfig) $(_InternalRuntimeDownloadArgs)
                displayName: Restore packages
              - script: .dotnet\dotnet build eng\helix.proj /restore /t:Test /p:configuration=$(_BuildConfig) /bl:artifacts/log/$(_BuildConfig)/SendToHelix.binlog $(_InternalRuntimeDownloadArgs)
                displayName: Send tests to helix
                env:
                  HelixAccessToken: $(_HelixAccessToken)
                  SYSTEM_ACCESSTOKEN: $(System.AccessToken)
                  MSSQL_SA_PASSWORD: "PLACEHOLDERPass$$w0rd"

          - job: Helix_Ubuntu_Cosmos
            displayName: 'Helix Ubuntu Cosmos'
            timeoutInMinutes: 180
            pool:
              name: $(DncEngPublicBuildPool)
              demands: ImageOverride -equals 1es-windows-2022-open
            variables:
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
              - name: _HelixBuildConfig
                value: $(_BuildConfig)
              - name: HelixTargetQueues
                value: Ubuntu.2204.Amd64.XL.Open
              - name: _HelixAccessToken
                value: ''
            steps:
              - task: NuGetCommand@2
                displayName: 'Clear NuGet caches'
                condition: succeeded()
                inputs:
                  command: custom
                  arguments: 'locals all -clear'
              - script: restore.cmd -ci /p:configuration=$(_BuildConfig) $(_InternalRuntimeDownloadArgs)
                displayName: Restore packages
              - script: .dotnet\dotnet build eng\helix.proj /restore /t:Test /p:configuration=$(_BuildConfig) /bl:artifacts/log/$(_BuildConfig)/SendToHelix.binlog $(_InternalRuntimeDownloadArgs)
                displayName: Send tests to helix
                env:
                  HelixAccessToken: $(_HelixAccessToken)
                  SYSTEM_ACCESSTOKEN: $(System.AccessToken)

          - job: Helix_Ubuntu
            displayName: 'Helix Ubuntu'
            timeoutInMinutes: 180
            pool:
              name: $(DncEngPublicBuildPool)
              demands: ImageOverride -equals 1es-windows-2022-open
            variables:
              - skipComponentGovernanceDetection: true
              - Codeql.SkipTaskAutoInjection: true
              - name: _HelixBuildConfig
                value: $(_BuildConfig)
              - name: HelixTargetQueues
                value: Ubuntu.2204.Amd64.Open
              - name: _HelixAccessToken
                value: ''
            steps:
              - task: NuGetCommand@2
                displayName: 'Clear NuGet caches'
                condition: succeeded()
                inputs:
                  command: custom
                  arguments: 'locals all -clear'
              - script: restore.cmd -ci /p:configuration=$(_BuildConfig) $(_InternalRuntimeDownloadArgs)
                displayName: Restore packages
              - script: .dotnet\dotnet build eng\helix.proj /restore /t:Test /p:configuration=$(_BuildConfig) /bl:artifacts/log/$(_BuildConfig)/SendToHelix.binlog $(_InternalRuntimeDownloadArgs)
                displayName: Send tests to helix
                env:
                  HelixAccessToken: $(_HelixAccessToken)
                  SYSTEM_ACCESSTOKEN: $(System.AccessToken)
- stage: validate
  displayName: Validate
  dependsOn: build
  condition: always()
  jobs:
  - job: Validate_Job_Results
    displayName: Job Results
    pool:
      name: $(DncEngPublicBuildPool)
      demands: ImageOverride -equals 1es-windows-2022-open
    variables:
      WindowsResult: $[ stageDependencies.build.Windows.result ]
      HelixWindowsResult: $[ stageDependencies.build.Helix_Windows.result ]
      WindowsSqlServerResult: $[ stageDependencies.build.Windows_SqlServer.result ]
      HelixWindowsSqlServerResult: $[ stageDependencies.build.Helix_Windows_SqlServer.result ]
      HelixWindowsCosmosResult: $[ stageDependencies.build.Helix_Windows_Cosmos.result ]
      LinuxResult: $[ stageDependencies.build.Linux.result ]
      HelixUbuntuResult: $[ stageDependencies.build.Helix_Ubuntu.result ]
      HelixUbuntuSqlServerResult: $[ stageDependencies.build.Helix_Ubuntu_SqlServer.result ]
      MacOsResult: $[ stageDependencies.build.macOS.result ]
      HelixMacOsX64Result: $[ stageDependencies.build.Helix_macOS_x64.result ]
      HelixMacOsArm64Result: $[ stageDependencies.build.Helix_macOS_ARM64.result ]
      HelixWindowsArm64Result: $[ stageDependencies.build.Helix_Windows_Arm64.result ]
      HelixUbuntuCosmosResult: $[ stageDependencies.build.Helix_Ubuntu_Cosmos.result ]
    steps:
      - pwsh: |
          $groupResults = @{
              Windows = @("$(WindowsResult)", "$(HelixWindowsResult)")
              Linux = @("$(LinuxResult)", "$(HelixUbuntuResult)")
              MacOS = @("$(MacOsResult)", "$(HelixMacOsX64Result)")
              Arm64 = @("$(HelixWindowsArm64Result)", "$(HelixMacOsArm64Result)")
              Cosmos = @("$(HelixWindowsCosmosResult)", "$(HelixUbuntuCosmosResult)")
              SqlServer = @("$(WindowsSqlServerResult)", "$(HelixWindowsSqlServerResult)", "$(HelixUbuntuSqlServerResult)")
          }

          $failedGroups = @()

          foreach ($groupName in $groupResults.Keys)
          {
              $results = $groupResults[$groupName]
              Write-Host "$groupName results: $($results -join ', ')"

              # Ignore jobs that were skipped (e.g. condition-gated)
              $ran = $results | Where-Object { $_ -ne 'Skipped' }
              if (-not $ran)
              {
                  Write-Host "  -> all jobs skipped, treating group as successful"
                  continue
              }

              # Only 'Succeeded' counts as success. 'SucceededWithIssues' is treated as failure
              # because the jobs run with continueOnError: true, which maps task failures to warnings.
              $hasSuccess = $ran | Where-Object { $_ -eq 'Succeeded' }
              if ($hasSuccess)
              {
                  continue
              }

              $failedGroups += $groupName
          }

          if ($failedGroups.Count -gt 0)
          {
              Write-Error "No jobs succeeded for group(s): $($failedGroups -join ', ')."
              exit 1
          }

          Write-Host 'Group validation passed.'
        displayName: Evaluate grouped job outcomes