[Bug]: Project API load() method is not correctly resolving dependencies

[niveathika]

Description

SQL testcase failing to resolve dependency time module

https://github.com/ballerina-platform/ballerina-lang/actions/runs/7170430688/job/19523715953

Steps to Reproduce

No response

Affected Version(s)

No response

OS, DB, other environment details and versions

No response

Related area

-> Compilation

Related issue(s) (optional)

No response

Suggested label(s) (optional)

No response

Suggested assignee(s) (optional)

No response

[niveathika]

Here the resolution happens sucessfully after the first attempt.

https://github.com/ballerina-platform/ballerina-lang/actions/runs/7172073878/job/19541598996?pr=41867

This is after disabling one test. Another is failing

[ShammiL]

This failure in resolving the time module, which is a dependency of the sql module, is due to the time module not been detected when creating the dependencyGraph.

Further investigating revealed that the time module is not added to the dependency-graph.json of ballerina/sql:1.11.2 pack as the scope of the time module dependency is taken as TEST_ONLY during the dependency resolution test.

[github-actions]

This issue is NOT closed with a proper Reason/ label. Make sure to add proper reason label before closing. Please add or leave a comment with the proper reason label now.

      - Reason/EngineeringMistake - The issue occurred due to a mistake made in the past.
      - Reason/Regression - The issue has introduced a regression.
      - Reason/MultipleComponentInteraction - Issue occured due to interactions in multiple components.
      - Reason/Complex - Issue occurred due to complex scenario.
      - Reason/Invalid - Issue is invalid.
      - Reason/Other - None of the above cases.