isnan need to be supported

[wangsimo0]

Feature request

for double data type, it will be better to have a function isnan.

description

Tests whether a value is equal to the special value "NaN", signifying "not a number".

syntax

isnan(exp)

in which, exp represents an expression that evaluates to a numeric, and returns a boolean.

examples

SELECT isnan(cast('NaN' as double)); 
true
SELECT isnan(10); 
false

[kateshaowanjou]

@Tianpingan Can you leave a comment here so I can assign this one to you? :)

[Tianpingan]

here

[Tianpingan]

@Tianpingan Can you leave a comment here so I can assign this one to you? :)

here~

[xuzifu666]

@wangsimo0 hi，can assign this issue to me？

[github-actions]

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!