pull_request.yml

name: PullRequest
on:
  pull_request:
    branches:
      - '**'
    paths-ignore:
      - '**.md'
env:
  DOTNET_SKIP_FIRST_TIME_EXPERIENCE: true
  DOTNET_CLI_TELEMETRY_OPTOUT: true
  DOTNET_NOLOGO: true
  PIPELINE_WORKSPACE: true
  checkoutFetchDepth: 2
  buildConfiguration: 'Debug'
  skipTests: false
  deterministicTests: true
  autoCommitGreenTests: true
  uploadTestResults: true
jobs:
  Preconditions:
    runs-on: ubuntu-latest
    outputs:
      lastCommitIsAutoCommit: ${{ steps.GetHeadCommitInfo.outputs.lastCommitIsAutoCommit }}
      lastCommitCreatedBeforeSeconds: ${{ steps.GetHeadCommitInfo.outputs.lastCommitCreatedBeforeSeconds }}
    steps:
      - name: 'General Information'
        shell: pwsh
        run: |
          echo 'EventName: ${{ github.event_name }}'
      - name: Checkout
        uses: actions/checkout@v5
        with:
          fetch-depth: ${{ env.checkoutFetchDepth }}
      - name: 'Get Head Commit Info'
        id: GetHeadCommitInfo
        shell: pwsh
        run: |
          git log -${{ env.checkoutFetchDepth }} --pretty=%B
          
          $headCommitMessage = git log -1 --skip "$(${{ env.checkoutFetchDepth }} - 1)" --pretty=%B
          echo "headCommitMessage: = $headCommitMessage"
          
          $headCommitAuthorName = git log -1 --skip "$(${{ env.checkoutFetchDepth }} - 1)" --pretty=%an
          echo "headCommitAuthorName: = $headCommitAuthorName"

          $headCommitAuthorEmail = git log -1 --skip "$(${{ env.checkoutFetchDepth }} - 1)" --pretty=%ae
          echo "headCommitAuthorEmail: = $headCommitAuthorEmail"

          $headCommitDateTime = Get-Date (git log -1 --skip "$(${{ env.checkoutFetchDepth }} - 1)" --pretty=%ci)
          echo "headCommitDateTime: = $headCommitDateTime"

          $lastCommitIsAutoCommit = $headCommitAuthorEmail -eq 'github-actions@github.com' -and $headCommitMessage -eq '[GitHub Actions] Update green tests.'
          echo "lastCommitIsAutoCommit=$lastCommitIsAutoCommit" >> $env:GITHUB_OUTPUT
          echo "lastCommitIsAutoCommit: = $lastCommitIsAutoCommit"

          $lastCommitCreatedBeforeSeconds = [int]((Get-Date) - $headCommitDateTime).TotalSeconds
          echo "lastCommitCreatedBeforeSeconds=$lastCommitCreatedBeforeSeconds" >> $env:GITHUB_OUTPUT
          echo "lastCommitCreatedBeforeSeconds: = $lastCommitCreatedBeforeSeconds"
  Changes:
    runs-on: ubuntu-latest
    outputs:
      jet: ${{ steps.Decide.outputs.jet }}
      libred: ${{ steps.Decide.outputs.libred }}
    steps:
      - name: Checkout
        uses: actions/checkout@v5
        with:
          fetch-depth: 0
      - name: 'Filter Changed Paths'
        id: Filter
        uses: dorny/paths-filter@v4
        with:
          filters: |
            # Anything here rebuilds the world, so it belongs to both sides.
            shared: &shared
              - '.github/workflows/**'
              - 'Directory.Build.props'
              - 'Version.props'
              - 'global.json'
              - 'nuget.config'
              - 'NuGet.config'
              - 'Key.snk'
              - 'EFCore.Jet.sln'
              - 'src/Directory.Build.props'
              - 'test/Directory.Build.props'
              - 'test/Shared/**'
            jet:
              - *shared
              - 'src/Shared/**'
              - 'src/EFCore.Jet/**'
              - 'src/EFCore.Jet.Data/**'
              - 'src/EFCore.Jet.Odbc/**'
              - 'src/EFCore.Jet.OleDb/**'
              - 'test/EFCore.Jet.Data.Tests/**'
              - 'test/EFCore.Jet.FunctionalTests/**'
              - 'test/EFCore.Jet.IntegrationTests/**'
              - 'test/EFCore.Jet.Tests/**'
              - 'test/JetProviderExceptionTests/**'
            libred:
              - *shared
              - 'src/LibRed/**'
              - 'test/LibRed.Ado.Tests/**'
              - 'test/LibRed.Core.Tests/**'
              - 'test/LibRed.EFCore.Tests/**'
              - 'test/LibRed.Engine.Tests/**'
              - 'test/EFCore.LibRed.FunctionalTests/**'
              # LibRed.Ado references EFCore.Jet.Data and LibRed.EFCore references EFCore.Jet, so a
              # change on the Jet side has to re-run LibRed. The reverse is not true: nothing under
              # src/LibRed is referenced by the Jet provider.
              - 'src/EFCore.Jet/**'
              - 'src/EFCore.Jet.Data/**'
              # Northwind.accdb lives here and every LibRed suite links to it as its fixture.
              - 'test/JetProviderExceptionTests/**'
      - name: 'Decide What To Run'
        id: Decide
        shell: pwsh
        run: |
          # A published release (or any event that isn't a push/PR) has no meaningful diff to filter
          # against, so it runs everything.
          $runEverything = '${{ github.event_name }}' -notin @('push', 'pull_request')

          $jet = $runEverything -or ('${{ steps.Filter.outputs.jet }}' -eq 'true')
          $libred = $runEverything -or ('${{ steps.Filter.outputs.libred }}' -eq 'true')

          echo "jet=$($jet.ToString().ToLowerInvariant())" >> $env:GITHUB_OUTPUT
          echo "libred=$($libred.ToString().ToLowerInvariant())" >> $env:GITHUB_OUTPUT

          echo "runEverything: $runEverything"
          echo "jet: $jet"
          echo "libred: $libred"
  BuildAndTest:
    needs:
      - Preconditions
      - Changes
    if: (needs.Preconditions.outputs.lastCommitIsAutoCommit != 'true' || needs.Preconditions.outputs.lastCommitCreatedBeforeSeconds > 300) && needs.Changes.outputs.jet == 'true'
    strategy:
      fail-fast: false
      matrix:
        aceVersion:
          - 2010
          - 2016
        aceArchitecture:
          - x64
          - x86
        dataAccessProviderType:
          - ODBC
          - OLE DB
        os:
          - windows-latest
    runs-on: ${{ matrix.os }}
    steps:
      - name: Checkout
        uses: actions/checkout@v5
      # Defender scans every .accdb these suites write; see the action for the measurement.
      - name: Exclude test files from Defender
        uses: ./.github/actions/exclude-defender
      - name: Set additional variables
        shell: pwsh
        run: |
          $os = '${{ matrix.os }}'.Split('-')[0]
          echo "os=$os" >> $env:GITHUB_ENV

          $dotnetInstallDirectory = '.\.dotnet_${{ matrix.aceArchitecture }}'
          echo "dotnetInstallDirectory=$dotnetInstallDirectory" >> $env:GITHUB_ENV
          
          $dotnetExecutable = Join-Path $dotnetInstallDirectory 'dotnet.exe'
          echo "dotnetExecutable=$dotnetExecutable" >> $env:GITHUB_ENV
          
          $aceUrls = @{
            '2010' = @{
              'x64' = 'https://cirrusredorg.github.io/EntityFrameworkCore.Jet/AccessDatabaseEngine_2010_x64.exe'
              'x86' = 'https://cirrusredorg.github.io/EntityFrameworkCore.Jet/AccessDatabaseEngine_2010_x86.exe'
              'silent' = '/passive /quiet /norestart REBOOT=ReallySuppress'
            }
           '2016' = @{
              'x64' = 'https://cirrusredorg.github.io/EntityFrameworkCore.Jet/AccessDatabaseEngine_2016_x64.exe'
              'x86' = 'https://cirrusredorg.github.io/EntityFrameworkCore.Jet/AccessDatabaseEngine_2016_x86.exe'
              'silent' = '/passive /quiet /norestart REBOOT=ReallySuppress'
            }
          }
          
          $aceUrl = $aceUrls['${{ matrix.aceVersion }}']['${{ matrix.aceArchitecture }}']
          echo "aceUrl=$aceUrl" >> $env:GITHUB_ENV
          
          $aceSilentInstallArgument = $aceUrls['${{ matrix.aceVersion }}']['silent']
          echo "aceSilentInstallArgument=$aceSilentInstallArgument" >> $env:GITHUB_ENV
          
          $defaultConnection = '${{ matrix.dataAccessProviderType }}' -eq 'ODBC' ? 'DBQ=Jet.accdb' : 'Data Source=Jet.accdb;Persist Security Info=False;'
          echo "defaultConnection=$defaultConnection" >> $env:GITHUB_ENV

          $matrixId = '${{ matrix.aceVersion }}-${{ matrix.aceArchitecture }}-' + '${{ matrix.dataAccessProviderType }}'.Replace(' ', '') + '-${{ matrix.os }}'
          echo "matrixId=$matrixId" >> $env:GITHUB_ENV
      - name: Output Variables
        shell: pwsh
        run: |
          echo "os: ${{ env.os }}"
          echo "buildConfiguration: ${{ env.buildConfiguration }}"
          echo "aceVersion: ${{ matrix.aceVersion }}"
          echo "aceArchitecture: ${{ matrix.aceArchitecture }}"
          echo "aceUrl: ${{ env.aceUrl }}"
          echo "aceSilentInstallArgument: ${{ env.aceSilentInstallArgument }}"
          echo "dataAccessProviderType: ${{ matrix.dataAccessProviderType }}"
          echo "defaultConnection: ${{ env.defaultConnection }}"
          echo "matrixId: ${{ env.matrixId }}"
          echo "skipTests: ${{ env.skipTests }}"
          echo "dotnetInstallDirectory: ${{ env.dotnetInstallDirectory }}"
          echo "dotnetExecutable: ${{ env.dotnetExecutable }}"

          echo "github.event_name: ${{ github.event_name }}"
          echo "github.repository: ${{ github.repository }}"
      - name: .NET Information Before SDK Install
        shell: pwsh
        run: try { & '${{ env.dotnetExecutable }}' --info } catch { echo 'No ${{ matrix.aceArchitecture }} .NET SDK installed.' }
      - name: Install .NET SDK
        shell: pwsh
        run: |
          function Retry-Command {
              [CmdletBinding()]
              Param(
                [Parameter(Position=0, Mandatory=$true)]
                [ScriptBlock]$ScriptBlock,
          
                [Parameter(Position=1, Mandatory=$false)]
                [int]$Maximum = 5,
          
                [Parameter(Mandatory=$false)]
                [switch]$ExponentialBackoff
              )
          
              $attempt = 0
          
              do {
                if ($attempt -gt 0 -and $ExponentialBackoff) {
                  Start-Sleep -Seconds ([Math]::Pow(2, $attempt) - 1)          
                }
          
                $attempt++
                try {
                  $ScriptBlock.Invoke()
                  return
                } catch {
                  Write-Error $_.Exception.InnerException.Message -ErrorAction Continue
                }
              } while ($attempt -lt $Maximum)
          
              throw 'Max retries exceeded.'
          }
          
          Retry-Command {
              &([ScriptBlock]::Create((Invoke-WebRequest -UseBasicParsing 'https://dot.net/v1/dotnet-install.ps1'))) -JSonFile global.json -Architecture '${{ matrix.aceArchitecture }}' -InstallDir '${{ env.dotnetInstallDirectory }}' -Verbose
          } -Maximum 10 -ExponentialBackoff
      - name: .NET Information After SDK Install
        shell: pwsh
        run: try { & '${{ env.dotnetExecutable }}' --info } catch { echo 'No ${{ matrix.aceArchitecture }} .NET SDK installed.' }
      - name: ACE Information Before ACE Install
        shell: pwsh
        run: |
          'DAO:'
          Get-ChildItem 'HKLM:\SOFTWARE\Classes\DAO.DBEngine*' | Select-Object
          
          'OLE DB:'
          foreach ($provider in [System.Data.OleDb.OleDbEnumerator]::GetRootEnumerator())
          {
              $v = New-Object PSObject        
              for ($i = 0; $i -lt $provider.FieldCount; $i++) 
              {
                  Add-Member -in $v NoteProperty $provider.GetName($i) $provider.GetValue($i)
              }
              $v
          }
      - name: Install Access Database Engine
        shell: pwsh
        run: |
          $setupFileName = 'AccessDatabaseEngine_${{ matrix.aceVersion }}_${{ matrix.aceArchitecture }}.exe'
          Invoke-WebRequest '${{ env.aceUrl }}' -OutFile $setupFileName
          & ".\$setupFileName" ${{ env.aceSilentInstallArgument }} | Out-Default
      - name: ACE Information After ACE Install
        shell: pwsh
        run: |
          'DAO:'
          Get-ChildItem 'HKLM:\SOFTWARE\Classes\DAO.DBEngine*' | Select-Object
          
          'OLE DB:'
          foreach ($provider in [System.Data.OleDb.OleDbEnumerator]::GetRootEnumerator())
          {
              $v = New-Object PSObject        
              for ($i = 0; $i -lt $provider.FieldCount; $i++) 
              {
                  Add-Member -in $v NoteProperty $provider.GetName($i) $provider.GetValue($i)
              }
              $v
          }
      - name: Build Solution
        shell: pwsh
        run: |
          & '${{ env.dotnetExecutable }}' build --configuration '${{ env.buildConfiguration }}'
      - name: 'Run Tests: EFCore.Jet.Data.Tests'
        if: always() && env.skipTests != 'true'
        shell: pwsh
        run: |
          $env:EFCoreJet_DefaultConnection = '${{ env.defaultConnection }}'
          # No --verbosity detailed: it dumps every test's captured output (EF logs the compiled shaper
          # expression tree per query under the Query category), which ran to ~62,000 lines in 43s per shard
          # and got truncated by GitHub anyway. Nothing consumes it - the green-tests extraction parses the
          # trx, and crash detection looks for Sequence_* blame dumps - so it cost console I/O for a log too
          # big to read. On these sequential suites those writes sit directly on the critical path.
          & '${{ env.dotnetExecutable }}' test .\test\EFCore.Jet.Data.Tests --configuration '${{ env.buildConfiguration }}' -p:FixedTestOrder=${{ env.deterministicTests }} --logger trx --blame-hang-timeout 3m
      - name: 'Run Tests: EFCore.Jet.Tests'
        if: always() && env.skipTests != 'true'
        shell: pwsh
        run: |
          $env:EFCoreJet_DefaultConnection = '${{ env.defaultConnection }}'
          & '${{ env.dotnetExecutable }}' test .\test\EFCore.Jet.Tests --configuration '${{ env.buildConfiguration }}' -p:FixedTestOrder=${{ env.deterministicTests }} --logger trx --blame-hang-timeout 3m
      - name: 'Run Tests: EFCore.Jet.FunctionalTests (Shard 1 - Query Core)'
        if: always() && env.skipTests != 'true'
        shell: pwsh
        run: |
          $shardDir = '.\test\EFCore.Jet.FunctionalTests\TestResults\shard1'

          for ($i = 0; $i -lt 3; $i++) {
            if (Test-Path $shardDir -PathType Container) {
              Get-ChildItem $shardDir | Remove-Item -Recurse -Force
            }

            $env:EFCoreJet_DefaultConnection = '${{ env.defaultConnection }}'
            & '${{ env.dotnetExecutable }}' test .\test\EFCore.Jet.FunctionalTests --configuration '${{ env.buildConfiguration }}' -p:FixedTestOrder=${{ env.deterministicTests }} --logger trx --blame-hang-timeout 3m --results-directory $shardDir --filter "FullyQualifiedName~.FunctionalTests.Query.&FullyQualifiedName!~.FunctionalTests.Query.Associations.&FullyQualifiedName!~.FunctionalTests.Query.Translations."

            #
            # Check for test runner crashes:
            #

            $currentTestRunTrx = Get-ChildItem $shardDir -Filter '*.trx' | Sort-Object LastWriteTime | Select-Object -Last 1
            if ($null -eq $currentTestRunTrx) {
                echo 'Test runner log file is missing.'
                exit 3
            }

            $currentTestRunDir = Join-Path $shardDir $currentTestRunTrx.BaseName
            if (Test-Path $currentTestRunDir) {
              if ($null -ne (Get-ChildItem $currentTestRunDir -Filter 'Sequence_*' -Recurse)) {
                # Split string because searching the log for that phrase should only show actual crashes and not this line.
                echo ('Test runner cras' + 'hed.')
                continue
              }
            }

            echo 'Test runner ran until the end.'
            break
          }

          $establishedGreenTestsFilePath = ".\test\EFCore.Jet.FunctionalTests\GreenTests\ace_${{ matrix.aceVersion }}_$('${{ matrix.dataAccessProviderType }}'.Replace(' ', '').ToLowerInvariant())_${{ matrix.aceArchitecture }}.txt"
          $failIfKeepsCrashing = Test-Path $establishedGreenTestsFilePath

          if ($i -ge 3 -and $failIfKeepsCrashing) {
            echo 'Test runner keeps crashing.'
            exit 2
          }
          exit 0
      - name: 'Run Tests: EFCore.Jet.FunctionalTests (Shard 2 - Query Associations and Translations)'
        if: always() && env.skipTests != 'true'
        shell: pwsh
        run: |
          $shardDir = '.\test\EFCore.Jet.FunctionalTests\TestResults\shard2'

          for ($i = 0; $i -lt 3; $i++) {
            if (Test-Path $shardDir -PathType Container) {
              Get-ChildItem $shardDir | Remove-Item -Recurse -Force
            }

            $env:EFCoreJet_DefaultConnection = '${{ env.defaultConnection }}'
            & '${{ env.dotnetExecutable }}' test .\test\EFCore.Jet.FunctionalTests --configuration '${{ env.buildConfiguration }}' -p:FixedTestOrder=${{ env.deterministicTests }} --logger trx --blame-hang-timeout 3m --results-directory $shardDir --filter "FullyQualifiedName~.FunctionalTests.Query.Associations.|FullyQualifiedName~.FunctionalTests.Query.Translations."

            #
            # Check for test runner crashes:
            #

            $currentTestRunTrx = Get-ChildItem $shardDir -Filter '*.trx' | Sort-Object LastWriteTime | Select-Object -Last 1
            if ($null -eq $currentTestRunTrx) {
                echo 'Test runner log file is missing.'
                exit 3
            }

            $currentTestRunDir = Join-Path $shardDir $currentTestRunTrx.BaseName
            if (Test-Path $currentTestRunDir) {
              if ($null -ne (Get-ChildItem $currentTestRunDir -Filter 'Sequence_*' -Recurse)) {
                # Split string because searching the log for that phrase should only show actual crashes and not this line.
                echo ('Test runner cras' + 'hed.')
                continue
              }
            }

            echo 'Test runner ran until the end.'
            break
          }

          $establishedGreenTestsFilePath = ".\test\EFCore.Jet.FunctionalTests\GreenTests\ace_${{ matrix.aceVersion }}_$('${{ matrix.dataAccessProviderType }}'.Replace(' ', '').ToLowerInvariant())_${{ matrix.aceArchitecture }}.txt"
          $failIfKeepsCrashing = Test-Path $establishedGreenTestsFilePath

          if ($i -ge 3 -and $failIfKeepsCrashing) {
            echo 'Test runner keeps crashing.'
            exit 2
          }
          exit 0
      - name: 'Run Tests: EFCore.Jet.FunctionalTests (Shard 3 - Non-Query)'
        if: always() && env.skipTests != 'true'
        shell: pwsh
        run: |
          $shardDir = '.\test\EFCore.Jet.FunctionalTests\TestResults\shard3'

          for ($i = 0; $i -lt 3; $i++) {
            if (Test-Path $shardDir -PathType Container) {
              Get-ChildItem $shardDir | Remove-Item -Recurse -Force
            }

            $env:EFCoreJet_DefaultConnection = '${{ env.defaultConnection }}'
            & '${{ env.dotnetExecutable }}' test .\test\EFCore.Jet.FunctionalTests --configuration '${{ env.buildConfiguration }}' -p:FixedTestOrder=${{ env.deterministicTests }} --logger trx --blame-hang-timeout 3m --results-directory $shardDir --filter "FullyQualifiedName!~.FunctionalTests.Query."

            #
            # Check for test runner crashes:
            #

            $currentTestRunTrx = Get-ChildItem $shardDir -Filter '*.trx' | Sort-Object LastWriteTime | Select-Object -Last 1
            if ($null -eq $currentTestRunTrx) {
                echo 'Test runner log file is missing.'
                exit 3
            }

            $currentTestRunDir = Join-Path $shardDir $currentTestRunTrx.BaseName
            if (Test-Path $currentTestRunDir) {
              if ($null -ne (Get-ChildItem $currentTestRunDir -Filter 'Sequence_*' -Recurse)) {
                # Split string because searching the log for that phrase should only show actual crashes and not this line.
                echo ('Test runner cras' + 'hed.')
                continue
              }
            }

            echo 'Test runner ran until the end.'
            break
          }

          $establishedGreenTestsFilePath = ".\test\EFCore.Jet.FunctionalTests\GreenTests\ace_${{ matrix.aceVersion }}_$('${{ matrix.dataAccessProviderType }}'.Replace(' ', '').ToLowerInvariant())_${{ matrix.aceArchitecture }}.txt"
          $failIfKeepsCrashing = Test-Path $establishedGreenTestsFilePath

          if ($i -ge 3 -and $failIfKeepsCrashing) {
            echo 'Test runner keeps crashing.'
            exit 2
          }
          exit 0
      - name: 'Rename Test Results'
        if: always() && env.skipTests != 'true'
        shell: pwsh
        run: |
          Get-ChildItem -Filter '*.trx' -Recurse | Sort-Object LastWriteTime | ForEach { Rename-Item $_.FullName "ace_${{ matrix.aceVersion }}_$('${{ matrix.dataAccessProviderType }}'.Replace(' ', '').ToLowerInvariant())_${{ matrix.aceArchitecture }}_$($_.Name)" -Verbose }
      - name: 'Upload Test Results'
        if: always() && env.skipTests != 'true' && env.uploadTestResults == 'true'
        uses: actions/upload-artifact@v6
        with:
          name: test-results_${{ env.matrixId }}
          path: |
            test\EFCore.Jet.Data.Tests\TestResults\*.trx
            test\EFCore.Jet.FunctionalTests\TestResults\**\*.trx
            test\EFCore.Jet.Tests\TestResults\*.trx
      - name: 'Check Tests: EFCore.Jet.FunctionalTests'
        if: env.skipTests != 'true'
        shell: pwsh
        run: |
          # Collect and merge test results from all shards.
          $testResultsDir = '.\test\EFCore.Jet.FunctionalTests\TestResults'
          $allTrxFiles = @(Get-ChildItem $testResultsDir -Filter '*.trx' -Recurse)

          if ($allTrxFiles.Count -eq 0) {
              echo 'No test result files found.'
              exit 3
          }

          $allNodes = @()
          foreach ($trxFile in $allTrxFiles) {
              $allNodes += (Select-Xml -Path $trxFile.FullName -XPath "//ns:UnitTestResult" -Namespace @{"ns"="http://microsoft.com/schemas/VisualStudio/TeamTest/2010"}).Node
          }

          $allTestsFilePath = Join-Path $testResultsDir 'combined_All.txt'
          $allNodes | Sort-Object -Property testName -CaseSensitive | ForEach-Object { "$($_.outcome -eq 'Passed' ? 'P' : $_.outcome -eq 'NotExecuted' ? 'N' : $_.outcome -eq 'Failed' ? 'F' : 'U') $($_.testName)" } | Set-Content $allTestsFilePath

          $greenTestsFilePath = Join-Path $testResultsDir 'combined_Passed.txt'
          Get-Content $allTestsFilePath | Where-Object { $_.StartsWith('P ') } | ForEach-Object { $_.Substring(2) } | Set-Content $greenTestsFilePath

          # Compare test file against previously committed file.
          $establishedGreenTestsFilePath = ".\test\EFCore.Jet.FunctionalTests\GreenTests\ace_${{ matrix.aceVersion }}_$('${{ matrix.dataAccessProviderType }}'.Replace(' ', '').ToLowerInvariant())_${{ matrix.aceArchitecture }}.txt"

          if (Test-Path $establishedGreenTestsFilePath) {
              $diffResult = Compare-Object (Get-Content $establishedGreenTestsFilePath) (Get-Content $greenTestsFilePath)

              $notGreenAnymore = $diffResult | Where-Object { $_.SideIndicator -eq '<=' } | Select-Object -ExpandProperty InputObject
              if ($null -ne $notGreenAnymore) {
                  echo "`nThe following $(@($notGreenAnymore).Length) tests passed in previous runs, but didn't pass in this run:`n"
                  $notGreenAnymore
                  exit 1
              }

              echo 'All tests that passed in previous runs still passed in this run.'

              $newlyGreenTests = $diffResult | Where-Object { $_.SideIndicator -eq '=>' } | Select-Object -ExpandProperty InputObject
              if ($newlyGreenTests.Length -gt 0) {
                Copy-Item $greenTestsFilePath $establishedGreenTestsFilePath -Force -Verbose

                echo "`nThe following new tests passed that did not pass before:`n"
                $newlyGreenTests

                $commitGreenTestsFile = $establishedGreenTestsFilePath
                echo "commitGreenTestsFile=$commitGreenTestsFile" >> $env:GITHUB_ENV
              }
          }
          echo 'Check succeeded.'
      - name: 'Upload Green Tests'
        if: env.commitGreenTestsFile != '' && env.autoCommitGreenTests == 'true'
        uses: actions/upload-artifact@v6
        with:
          name: green-tests_${{ env.matrixId }}
          path: ${{ env.commitGreenTestsFile }}
  LibRed:
    needs:
      - Preconditions
      - Changes
    if: (needs.Preconditions.outputs.lastCommitIsAutoCommit != 'true' || needs.Preconditions.outputs.lastCommitCreatedBeforeSeconds > 300) && needs.Changes.outputs.libred == 'true'
    strategy:
      fail-fast: false
      matrix:
        os:
          - ubuntu-latest
          - windows-latest
          - macos-latest
    runs-on: ${{ matrix.os }}
    steps:
      - name: Checkout
        uses: actions/checkout@v5
      # Defender scans every .accdb these suites write; see the action for the measurement.
      - name: Exclude test files from Defender
        uses: ./.github/actions/exclude-defender
      - name: Install .NET SDK
        uses: actions/setup-dotnet@v5
        with:
          global-json-file: global.json
      - name: .NET Information
        run: dotnet --info
      - name: 'Run Tests: LibRed.Engine.Tests'
        if: env.skipTests != 'true'
        run: dotnet test ./test/LibRed.Engine.Tests --configuration ${{ env.buildConfiguration }} -p:FixedTestOrder=${{ env.deterministicTests }} --blame-hang-timeout 3m

  # The rest of the LibRed suites cross-check LibRed's output against the real engine over OLE DB,
  # so unlike the job above they do need Windows with ACE installed.
  LibRedAccess:
    needs:
      - Preconditions
      - Changes
    if: (needs.Preconditions.outputs.lastCommitIsAutoCommit != 'true' || needs.Preconditions.outputs.lastCommitCreatedBeforeSeconds > 300) && needs.Changes.outputs.libred == 'true'
    strategy:
      fail-fast: false
      matrix:
        aceVersion:
          - 2016
    runs-on: windows-latest
    steps:
      - name: Checkout
        uses: actions/checkout@v5
      # Defender scans every .accdb these suites write; see the action for the measurement.
      - name: Exclude test files from Defender
        uses: ./.github/actions/exclude-defender
      - name: Install .NET SDK
        uses: actions/setup-dotnet@v5
        with:
          global-json-file: global.json
      - name: Install Access Database Engine
        shell: pwsh
        run: |
          $setupFileName = 'AccessDatabaseEngine_${{ matrix.aceVersion }}_x64.exe'
          Invoke-WebRequest "https://cirrusredorg.github.io/EntityFrameworkCore.Jet/$setupFileName" -OutFile $setupFileName
          & ".\$setupFileName" /passive /quiet /norestart REBOOT=ReallySuppress | Out-Default
      - name: 'ACE Information'
        shell: pwsh
        run: |
          foreach ($provider in [System.Data.OleDb.OleDbEnumerator]::GetRootEnumerator())
          {
              $v = New-Object PSObject
              for ($i = 0; $i -lt $provider.FieldCount; $i++)
              {
                  Add-Member -in $v NoteProperty $provider.GetName($i) $provider.GetValue($i)
              }
              $v
          }
      - name: 'Run Tests: LibRed.Core.Tests'
        if: env.skipTests != 'true'
        shell: pwsh
        run: dotnet test .\test\LibRed.Core.Tests --configuration '${{ env.buildConfiguration }}' -p:FixedTestOrder=${{ env.deterministicTests }} --blame-hang-timeout 5m
      - name: 'Run Tests: LibRed.Ado.Tests'
        if: always() && env.skipTests != 'true'
        shell: pwsh
        run: dotnet test .\test\LibRed.Ado.Tests --configuration '${{ env.buildConfiguration }}' -p:FixedTestOrder=${{ env.deterministicTests }} --blame-hang-timeout 5m
      - name: 'Run Tests: LibRed.EFCore.Tests'
        if: always() && env.skipTests != 'true'
        shell: pwsh
        run: dotnet test .\test\LibRed.EFCore.Tests --configuration '${{ env.buildConfiguration }}' -p:FixedTestOrder=${{ env.deterministicTests }} --blame-hang-timeout 5m

  LibRedFunctional:
    needs:
      - Preconditions
      - Changes
    # Non-blocking for now: the suite sits at ~278 failures out of ~36,000 run, so it would be red on
    # every push and quickly learn to be ignored. It still runs on every push and the log is there to
    # read. Drop this line once the remaining failures are fixed or skipped.
    continue-on-error: true
    if: (needs.Preconditions.outputs.lastCommitIsAutoCommit != 'true' || needs.Preconditions.outputs.lastCommitCreatedBeforeSeconds > 300) && needs.Changes.outputs.libred == 'true'
    strategy:
      fail-fast: false
      matrix:
        os:
          - ubuntu-latest
          - windows-latest
          - macos-latest
    runs-on: ${{ matrix.os }}
    steps:
      - name: Checkout
        uses: actions/checkout@v5
      # Defender scans every .accdb these suites write; see the action for the measurement.
      - name: Exclude test files from Defender
        uses: ./.github/actions/exclude-defender
      - name: Install .NET SDK
        uses: actions/setup-dotnet@v5
        with:
          global-json-file: global.json
      # No Access engine on ANY leg now. Windows used to install ACE as a control, on the reasoning that a
      # test failing only off Windows would be a real cross-platform gap - but all three legs have since
      # agreed exactly (35,578 passed / 179 failed / 2,016 skipped), so nothing here needs ACE and the
      # control has served its purpose. LibRedAccess still installs it, which is where the cross-checks
      # against the real engine belong.
      - name: 'Run Tests: EFCore.LibRed.FunctionalTests'
        if: env.skipTests != 'true'
        run: dotnet test test/EFCore.LibRed.FunctionalTests --configuration ${{ env.buildConfiguration }} -p:FixedTestOrder=${{ env.deterministicTests }} --blame-hang-timeout 10m
  MergeArtifacts:
    needs: BuildAndTest
    if: always()
    outputs:
      testResultsAvailable: ${{ steps.MergeTestResults.conclusion == 'success' }}
      greenTestsAvailable: ${{ steps.MergeGreenTests.conclusion == 'success' }}
    runs-on: ubuntu-latest
    steps:
      - name: 'Check Test Results Artifacts'
        id: CheckTestResultsArtifacts
        uses: actions/github-script@v8
        with:
          script: |
            var allArtifacts = await github.rest.actions.listWorkflowRunArtifacts({
               owner: context.repo.owner,
               repo: context.repo.repo,
               run_id: '${{ github.run_id }}',
            });
            
            var artifacts = allArtifacts.data.artifacts.filter((artifact) => {
              return artifact.name.startsWith("test-results_");
            });
            
            if (artifacts.length > 0) {
              core.setOutput('artifactsAvailable', 'true');
              console.log('Test results artifacts found.');
            }
      - name: 'Merge Test Results'
        id: MergeTestResults
        if: steps.CheckTestResultsArtifacts.outputs.artifactsAvailable == 'true'
        uses: actions/upload-artifact/merge@v6
        with:
          name: test-results
          pattern: test-results_*
          delete-merged: true
      - name: 'Check Green Tests Artifacts'
        id: CheckGreenTestsArtifacts
        uses: actions/github-script@v8
        with:
          script: |
            var allArtifacts = await github.rest.actions.listWorkflowRunArtifacts({
               owner: context.repo.owner,
               repo: context.repo.repo,
               run_id: '${{ github.run_id }}',
            });
            
            var artifacts = allArtifacts.data.artifacts.filter((artifact) => {
              return artifact.name.startsWith("green-tests_");
            });
            
            if (artifacts.length > 0) {
              core.setOutput('artifactsAvailable', 'true');
              console.log('Green Tests Artifacts found.');
            }
      - name: 'Merge Green Tests'
        id: MergeGreenTests
        if: steps.CheckGreenTestsArtifacts.outputs.artifactsAvailable == 'true'
        uses: actions/upload-artifact/merge@v6
        with:
          name: green-tests
          pattern: green-tests_*
          delete-merged: true
  CheckArtifacts:
    needs:
      - BuildAndTest
      - MergeArtifacts
    if: always()
    runs-on: ubuntu-latest
    outputs:
      hasGreenTestsArtifacts: ${{ steps.CheckGreenTestsArtifacts.outputs.hasGreenTestsArtifacts == 'true' }}
    steps:
#      - name: 'Debug'
#        shell: pwsh
#        env:
#          NEEDS_CONTEXT: ${{ toJson(needs) }}
#        run: |
#          echo $env:NEEDS_CONTEXT
      - name: 'Download Green Tests'
        if: needs.MergeArtifacts.outputs.greenTestsAvailable == 'true'
        uses: actions/download-artifact@v7
        with:
          name: green-tests
          path: green-tests
      - name: 'Check Green Tests Artifacts'
        id: CheckGreenTestsArtifacts
        shell: pwsh
        run: |
          dir -Recurse | Select-Object -ExpandProperty FullName

          $hasGreenTestsArtifacts = (Test-Path 'green-tests') -and (Get-ChildItem 'green-tests').Length -gt 0
          echo "hasGreenTestsArtifacts=$hasGreenTestsArtifacts" >> $env:GITHUB_OUTPUT
          echo "hasGreenTestsArtifacts: $hasGreenTestsArtifacts"
  Status:
    needs: CheckArtifacts
    if: always() && needs.CheckArtifacts.result == 'success' && needs.CheckArtifacts.outputs.hasGreenTestsArtifacts != 'true'
    runs-on: ubuntu-latest
    steps:
      - name: 'Final Status'
        shell: pwsh
        run: |
          echo 'All workflows succeeded.'
          exit 0