[Bug]: The results of the func_aggr_count BVT are inconsistent between macOS and Linux.

[aptend]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

d29d785

Other Environment Information

- mac: Darwin MacBook-Pro.local 25.2.0 Darwin Kernel Version 25.2.0: Tue Nov 18 21:08:48 PST 2025; root:xnu-12377.61.12~1/RELEASE_ARM64_T8132 arm64

- linux: Linux host-10-222-1-52 6.12.63+deb13-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.12.63-1 (2025-12-30) x86_64 GNU/Linux

Actual Behavior

2026-02-04 11:58:09 ERROR RSRow:58 - The value of [row:0,column:2] does not equal with each other,one is [0.0],but the other is [4.978063099199145E-9]
2026-02-04 11:58:09 ERROR Executor:315 - [/Users/aptend/code/matrixone/test/distributed/cases/function/func_aggr_count.test][row:204][select i, count(*), std(s1/s2) from bug22555 group by i order by i;] was executed failed, con[id=0, user=dump, pwd=111].
2026-02-04 11:58:09 ERROR Executor:319 - [EXPECT RESULT]:
➤ i[5,16,0]  ¦  count(*)[-5,64,0]  ¦  std(s1 / s2)[8,54,0]  𝄀
1  ¦  4  ¦  0.0  𝄀
2  ¦  4  ¦  0.0  𝄀
3  ¦  4  ¦  0.0
2026-02-04 11:58:09 ERROR Executor:320 - [ACTUAL RESULT]:
➤ i[5,16,0]  ¦  count(*)[-5,64,0]  ¦  std(s1 / s2)[8,54,0]  𝄀
1  ¦  4  ¦  4.978063099199145E-9  𝄀
2  ¦  4  ¦  8.960595038883635E-10  𝄀
3  ¦  4  ¦  NaN

Expected Behavior

No response

Steps to Reproduce

create table bug22555 (i smallint, s1 smallint, s2 smallint, o1 double, o2 double, e1 decimal, e2 decimal);
insert into bug22555 values (1,53,78,53,78,53,78),(2,17,78,17,78,17,78),(3,18,76,18,76,18,76);
insert into bug22555 values (1,53,78,53,78,53,78),(2,17,78,17,78,17,78),(3,18,76,18,76,18,76);
insert into bug22555 values (1,53,78,53,78,53,78),(2,17,78,17,78,17,78),(3,18,76,18,76,18,76);
insert into bug22555 values (1,53,78,53,78,53,78),(2,17,78,17,78,17,78),(3,18,76,18,76,18,76);


On MacOS:

mysql> select i, count(*), std(s1/s2) from bug22555 group by i order by i;
+------+----------+-----------------------------+
| i    | count(*) | std(s1 / s2)                |
+------+----------+-----------------------------+
|    1 |        4 |  0.000000004978063099199145 |
|    2 |        4 | 0.0000000008960595038883635 |
|    3 |        4 |                         NaN |
+------+----------+-----------------------------+


On Linux:


MySQL [db]> select i, count(*), std(s1/s2) from bug22555 group by i order by i;
+------+----------+--------------+
| i    | count(*) | std(s1 / s2) |
+------+----------+--------------+
|    1 |        4 |            0 |
|    2 |        4 |            0 |
|    3 |        4 |            0 |
+------+----------+--------------+

Additional information

No response