Unexpected Nested Query Result[BUG]

[ghost]

Describe the bug
The result of a query is different when that same query becomes a part of a nested query.

Or for query issues:

1. Run the query 'SELECT Customer Name FROM staples GROUP BY 1 LIMIT 1'
2. See correct output with type keyword
3. Run the query 'SELECT* FROM (SELECT Customer Name FROM staples GROUP BY 1 LIMIT 1)'
4. See unexpected result with type Double

Expected behavior
The outputs are the same if the queries are grouped by the column name. However, the two queries should still have the same output regardless of grouping as the query in step 1 has an expected output.

Screenshots
Expected output:

Actual ouput:

[chloe-zh]

I am not able to reproduce this error, instead I think the behavior is proper:

POST _plugins/_sql
{
  "query": "SELECT * FROM (SELECT FlightNum FROM opensearch_dashboards_sample_data_flights GROUP BY 1 LIMIT 1) as flights"
}

# result:
{
  "schema": [
    {
      "name": "FlightNum",
      "type": "keyword"
    }
  ],
  "datarows": [
    [
      "00882F6"
    ]
  ],
  "total": 1,
  "size": 1,
  "status": 200
}