[Bug]: mo-tester issue when use ceil function.

[Ariznawlll]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Expected Behavior

Steps to Reproduce

in mo-tester:
./run.sh -n -g /matrixone/test/distributed/cases/function/func_math.sql -


m genrs
 
drop table if exists ceil;
create table ceil(id int,d int,dl double,fl float,de decimal);
insert into ceil values(1,5,5,-5.5,-5.5);
insert into ceil values(2,-2,18446744073709551614,-2.5,-5.2);
insert into ceil values(2,-1,18446744073709551614,1.23,-1.23);
insert into ceil values(2,-1,1844674407370955161,1.23,-1.23);
insert into ceil values(2,-1,-9223372036854775808,1.23,-1.23);
insert into ceil values(2,-1,-184467440737095516,1.23,-1.23);
insert into ceil values(2,-1,-922337203685477580,1.23,-1.23);
insert into ceil values(2,-1,-922337203685477580,1.23,-1.23);
insert into ceil values(2,-1,-99999999999999999.9,1.23,-1.23);
insert into ceil values(2,-1,-99999999999999999.9,1.23,-1.23);

-- @case
-- @desc:test for abs
-- @label:bvt
select ceil(d),ceil(dl),ceil(fl) from ceil;

drop table t1;
drop table ceil;
drop table abs;

Additional information

No response

[aressu1985]

not working on it

[aptend]

It is suggested to assign an explicit row identifier to enable mo-tester to correctly match corresponding rows between the expected and actual results.

create table ceil(id int primary key,d int,dl double,fl float,de decimal);
insert into ceil values(1,5,5,-5.5,-5.5);
insert into ceil values(2,-2,18446744073709551614,-2.5,-5.2);
insert into ceil values(3,-1,18446744073709551614,1.23,-1.23);
insert into ceil values(4,-1,1844674407370955161,1.23,-1.23);
insert into ceil values(5,-1,-9223372036854775808,1.23,-1.23);
insert into ceil values(6,-1,-184467440737095516,1.23,-1.23);
insert into ceil values(7,-1,-922337203685477580,1.23,-1.23);
insert into ceil values(8,-1,-922337203685477580,1.23,-1.23);
insert into ceil values(9,-1,-99999999999999999.9,1.23,-1.23);
insert into ceil values(10,-1,-99999999999999999.9,1.23,-1.23);

-- @case
-- @desc:test for abs
-- @label:bvt
select id,ceil(d),ceil(dl),ceil(fl) from ceil;