Skip to content

SQL: selecting a literal and an aggregate generates an error #41411

@astefan

Description

@astefan
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)

Metadata

Metadata

Assignees

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions