-- @owner: zhanghuan
-- @date: 2024-06-19
-- @testpoint: 入参范围的测试,数据类型转换
--step1:入参范围的测试,数据类型转换; expect:执行成功
select listagg(1.0E128) within group(order by 1);
+-----------------------------------------------------------------------------------------------------------------------------------+
| listagg |
+-----------------------------------------------------------------------------------------------------------------------------------+
| 100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
+-----------------------------------------------------------------------------------------------------------------------------------+
select listagg(1.0E128) within group(order by 1.0);
+-----------------------------------------------------------------------------------------------------------------------------------+
| listagg |
+-----------------------------------------------------------------------------------------------------------------------------------+
| 100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
+-----------------------------------------------------------------------------------------------------------------------------------+
select listagg(1.79E+308*2) within group(order by 1.0E128*1.2);
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| listagg |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 358000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
select listagg(1.79E+308+1) within group(order by 1.0E128+1);
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| listagg |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 179000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
select listagg(1.79+308+1) within group(order by 1.0128+1);
+---------+
| listagg |
+---------+
| 310.79 |
+---------+
select listagg(1.79+308+1) within group(order by 1);
+---------+
| listagg |
+---------+
| 310.79 |
+---------+