opensearch-project / opensearch-project/sql
[BUG] IS NOT NULL with alias throws SemanticCheckException
Open
@anirudha is already working on this.
Since Jan 4, 2022.
bug
enhancement
Priority-High
SQL
- Dominant language
- Java
- Stars
- 176
- Forks
- 229
- Avg merge
- 2d 21h
- Merged PRs (30d)
- 43
Description
Describe the bug
Using IS NOT NULL with alias throws SemanticCheckException.
To Reproduce
Sample query:
SELECT dest_city_name AS dc
FROM all_flights
WHERE dc IS NOT NULL
Expected behavior
Should be same as query:
SELECT dest_city_name AS dc
FROM all_flights
WHERE dest_city_name IS NOT NULL
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.