[BUG] fields is changing the outcome of the following commands that depend on selected fields

[TackAdam]

What is the bug?
When running stats count() operation on a nested parameter the result seems to just return 0. If the field is specified before running the count, it will show the correct value.

How can one reproduce the bug?
Steps to reproduce the behavior:

1. Go to 'OpenSearch Playground:Query Workbench https://playground.opensearch.org/app/opensearch-query-workbench#/
2. Click on PPL and enter the PPL "source = jaeger-span-* |stats count (references.refType)" and hit Run

-Output will be 0

Enter the PPL "source = jaeger-span-* | fields references.refType|stats count (references.refType)" and hit Run

-Output will be 193

What is the expected behavior?
The stats count() should return a consistent value regardless of any preceeding field selection.

What is your host/environment?

• OS: [e.g. iOS]
• Version [e.g. 22]
• Plugins

Do you have any screenshots?
If applicable, add screenshots to help explain your problem.

Do you have any additional context?
Add any other context about the problem.

[LantaoJin]

This may be not a bug of SQL plugin. Regarding to nested field, OpenSearch DSL query will return 0 value too. Try below DSL

GET jaeger-span-*/_search
{
  "size": 0,
  "aggs": {
    "count_refType": {
      "value_count": {
        "field": "references.refType"
      }
    }
  }
}

PPL source = jaeger-span-* | stats count (references.refType) equals to above DSL query. But source = jaeger-span-* | fields references.refType | stats count (references.refType) equals searching keyword patients.name first then aggregate.

[LantaoJin]

Open opensearch-project/OpenSearch#14347 to track

[dblock]

Is this fixed with the related OpenSearch issue @LantaoJin?

[Catch All Triage - Attendees 1, 2, 3, 4, 5]