sql
sql copied to clipboard
[BUG] Test aggregation_cant_merge_indexScan_with_project fails
What is the bug? The test aggregation_cant_merge_indexScan_with_project fails when it is enabled.
How can one reproduce the bug? Steps to reproduce the behavior:
- Run the test
aggregation_cant_merge_indexScan_with_project
in https://github.com/opensearch-project/sql/blob/2.x/opensearch/src/test/java/org/opensearch/sql/opensearch/planner/logical/OpenSearchLogicOptimizerTest.java - See an
AssertionFailedError
with actual beingOpenSearchLogicalIndexAgg(relationName=schema, filter==(intV, 1), aggregatorList=[AVG(intV)], groupByList=[longV], sortList=null)
What is the expected behavior?
Expected is LogicalAggregation(aggregatorList=[AVG(intV)], groupByList=[longV])
What is your host/environment?
- OS: macOS
- Version: OpenSearch 2.4.0
- Plugins: OpenSearch SQL 2.x
Do you have any additional context? The test should be enabled once this is fixed.