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

SQL: Implement ISNULL(expr1, expr2) variant of COALESCE #35781

Closed
matriv opened this issue Nov 21, 2018 · 1 comment
Closed

SQL: Implement ISNULL(expr1, expr2) variant of COALESCE #35781

matriv opened this issue Nov 21, 2018 · 1 comment
Assignees
@matriv
Labels
:Analytics/SQL SQL querying >enhancement v6.6.0 v7.0.0-beta1

Comments

@matriv
Copy link
Contributor

matriv commented Nov 21, 2018

Implement ISNULL variant of COALESCE which takes only 2 arguments
and is used by MS-SQL server.

Relates to #34956
@matriv matriv self-assigned this Nov 21, 2018
@elasticmachine
Copy link
Collaborator

Pinging @elastic/es-search

matriv added a commit to matriv/elasticsearch that referenced this issue Nov 21, 2018
@matriv
SQL: Implement ISNULL(expr1, expr2)
ee291b8 
Add ISNULL as an alias of IFNULL as they have the
same behaviour. Add basic test and docs.

Closes: elastic#35781
matriv added a commit to matriv/elasticsearch that referenced this issue Nov 21, 2018
@matriv
SQL: Implement ISNULL(expr1, expr2)
c4ade5c 
Add ISNULL as an alias of IFNULL as they have the
same behaviour. Add basic test and docs.

Closes: elastic#35781
@matriv matriv mentioned this issue Nov 21, 2018
Merged
matriv added a commit that referenced this issue Nov 21, 2018
@matriv
SQL: Implement ISNULL(expr1, expr2) (#35793)
d95d885 
Add ISNULL as an alias of IFNULL as they have the
same behaviour. Add basic test and docs.

Closes: #35781
matriv added a commit that referenced this issue Nov 21, 2018
@matriv
SQL: Implement ISNULL(expr1, expr2) (#35793)
e393543 
Add ISNULL as an alias of IFNULL as they have the
same behaviour. Add basic test and docs.

Closes: #35781
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@matriv matriv

Labels
:Analytics/SQL SQL querying >enhancement v6.6.0 v7.0.0-beta1
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@colings86 @matriv @elasticmachine