Skip to content

Investigate intermittent SQL references tests in full suite #2949

Description

@Widthdom

During validation for MCP env-limit issues #2861, #2895, #2899, and #2900, dotnet test CodeIndex.sln --no-restore intermittently reported failures in existing SQL reference tests, while the same tests passed when rerun individually.

Observed full-suite failures included:

  • ReferenceExtractorTests.Extract_SQL_CreateIndexCapturesOnTableReference once during a full run; reran individually and passed on net8/net9.
  • QueryCommandRunnerTests.RunReferences_ExactJson_SqlMultilineSingleQuotedStringsStayOpaque with KeyNotFoundException at QueryCommandRunnerTests.cs:19256; reran with the related filter and passed on net8/net9.
  • QueryCommandRunnerTests.RunReferences_ExactJson_SqlMergeTempTargetWithoutIntoResolvesTargetAndSource with KeyNotFoundException at QueryCommandRunnerTests.cs:18541; reran with the related filter and passed on net8/net9.
  • QueryCommandRunnerTests.RunReferences_ExactJson_SqlNonAsciiBareIdentifiersStayWhole expected 7 / actual 6 at QueryCommandRunnerTests.cs:18938; reran with the related filter and passed on net8/net9.

This looks unrelated to the MCP environment-limit changes and may be full-suite ordering, shared state, or parallel execution sensitivity.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions