starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

[function]The result of abs('') is wrong

Open lvchenyang-maker opened this issue 3 years ago • 0 comments

Steps to reproduce the behavior (Required)

select abs('');

abs函数不支持date 、datetime但是计算时会有隐式转换, date: abs(CAST(1: k1 AS LARGEINT)) datatime:abs(CAST(2: k2 AS DOUBLE))建议优化 image

Expected behavior (Required)

mysql 5.7 0

Real behavior (Required)

null

StarRocks version (Required)

  • You can get the StarRocks version by executing SQL select current_version()
+----------------------+
| current_version()    |
+----------------------+
| MAIN-RELEASE 9cada5e |
+----------------------+

lvchenyang-maker avatar Sep 22 '22 13:09 lvchenyang-maker