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.

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

[Feature] least and greatest function enhanced #50570

Open
vkingnew opened this issue Sep 2, 2024 · 1 comment
Open

[Feature] least and greatest function enhanced #50570

vkingnew opened this issue Sep 2, 2024 · 1 comment

Comments

@vkingnew
Copy link

vkingnew commented Sep 2, 2024

function least and greateast default operation nulls value ,whether operate nulls value should up
to user .
-- current
select least(1,2,3,NULL) little,greatest(1,2,3,null) big;
image

-- expect:
image
-- desired feature:
least(col1,col2 [ignore|respect] nulls)
greatest(col1,col2 [ignore|respect] nulls)

-- statement example
select least(1,2,3,null ignore nulls) little,greatest(1,2,3,null,IGNORE nulls ) big;
select least(1,2,3,null,respect ignore nulls) little,greatest(1,2,3,null,respect nulls ) big;

@vkingnew vkingnew changed the title [Feature] function least and greateast nulls value operate feature should enhanced [Feature] least and greatest function enhanced Sep 2, 2024
@venkateshdatta1993
Copy link

venkateshdatta1993 commented Sep 11, 2024

@wangsimo0 I am new to this project and I'd like to give this a try.

Could you please assign this to me?

If there any pointers around approach to take or to start on this, please do share your thoughts.

Appreciate your support on this one :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants