sql> **select 123, max(salary) from test_emp group by gender;**
Server error [Server encountered an error [Cannot find group [123]]. [SqlIllegalArgumentException[Cannot find group [123]]
at org.elasticsearch.xpack.sql.util.Check.notNull(Check.java:36)
at org.elasticsearch.xpack.sql.planner.QueryFolder$FoldAggregate.rule(QueryFolder.java:371)
at org.elasticsearch.xpack.sql.planner.QueryFolder$FoldAggregate.rule(QueryFolder.java:205)
at org.elasticsearch.xpack.sql.tree.Node.lambda$transformUp$11(Node.java:196)
at org.elasticsearch.xpack.sql.tree.Node.transformUp(Node.java:190)
at org.elasticsearch.xpack.sql.tree.Node.transformUp(Node.java:196)
at org.elasticsearch.xpack.sql.planner.QueryFolder$FoldingRule.apply(QueryFolder.java:593)