[BUG] Analyzer should report error for mismatch between select and group by items

[GumpacG]

What is the bug?
Analyzer does not report a SemanticCheckException when there is a mismatch between select and group by items.

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

1. Query SELECT str0 FROM calcs GROUP BY str1;

What is the expected behavior?
A SemanticCheckException should be thrown with the message "Expression [str0] that contains non-aggregated column is not present in group by clause" as shown in the test should_report_error_for_mismatch_between_select_and_group_by_items in https://github.com/opensearch-project/sql/blob/2.x/sql/src/test/java/org/opensearch/sql/sql/parser/AstAggregationBuilderTest.java.

What is your host/environment?

• OS: macOS
• Version: OpenSearch 2.x

Do you have any additional context?
The test should be enabled once this has been fixed/implemented.

[Yury-Fridlyand]

mysql> SELECT str0 FROM calcs GROUP BY str1;
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'TDVT.calcs.str0' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

[dai-chen]

Duplicate as #258 ?

[Yury-Fridlyand]

Duplicate as #258 ?

Oh, may be. I'm not sure, need to test/debug both.