Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ESQL: more than two EVAL expressions using previous new evaluations will fail #99576

Closed
astefan opened this issue Sep 14, 2023 · 2 comments · Fixed by #99601
Closed

ESQL: more than two EVAL expressions using previous new evaluations will fail #99576

astefan opened this issue Sep 14, 2023 · 2 comments · Fixed by #99601
Assignees
@astefan
Labels
:Analytics/ES|QL AKA ESQL >bug Team:QL (Deprecated) Meta label for query languages team

Comments

@astefan
Copy link
Contributor

astefan commented Sep 14, 2023

Description

FROM test | eval x1 = pow(emp_no, 1), x2 = pow(x1, 1), x3 = pow(x2, 2)

or

FROM test | eval x1 = substring(ip1, 3), x2 = substring(x1, 2), x3 = substring(x2, 2)

or

FROM test | eval x1 = concat(ip1, ip2), x2 = concat(x1, "--"), x3 = concat(x2, "**")

will fail with

                "type": "verification_exception",
                "reason": "Found 1 problem\nline 1:65: Unknown column [x2], did you mean [x1]?"

Spawned from #99472
@astefan astefan self-assigned this Sep 14, 2023
@elasticsearchmachine elasticsearchmachine added the Team:QL (Deprecated) Meta label for query languages team label Sep 14, 2023
@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/es-ql (Team:QL)

@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/elasticsearch-esql (:Query Languages/ES|QL)

@astefan astefan changed the title ESQL: more than two EVAL expression using previous newly evaluations will fail ESQL: more than two EVAL expressions using previous new evaluations will fail Sep 14, 2023
@astefan astefan mentioned this issue Sep 14, 2023
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@astefan astefan

Labels
:Analytics/ES|QL AKA ESQL >bug Team:QL (Deprecated) Meta label for query languages team
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

ESQL: continue resolving attributes for Eval astefan/elasticsearch
2 participants
@astefan @elasticsearchmachine