matrixone [Bug]: `approx_count` error during bvt test with race enabled

Is there an existing issue for the same bug?

[X] I have checked the existing issues.

Environment

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

Actual Behavior

https://github.com/matrixorigin/matrixone/actions/runs/7041645633/job/19164955745

multi-cn-e2e-with-race-linux-x86-reports.zip

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

Nov 30 '23 09:11 sukki37

repro: https://github.com/matrixorigin/matrixone/actions/runs/7046745646/job/19179630428

Nov 30 '23 16:11 sukki37

暂无进展

Dec 21 '23 10:12 zengyan1

暂无进展

Dec 26 '23 10:12 zengyan1

暂无进展

Dec 29 '23 10:12 zengyan1

本周请假

Jan 03 '24 14:01 zengyan1

暂无进展

Jan 08 '24 11:01 zengyan1

暂无进展

Jan 11 '24 12:01 zengyan1

暂无进展

Jan 16 '24 10:01 zengyan1

暂无进展

Jan 22 '24 10:01 zengyan1

暂无进展

Jan 25 '24 10:01 zengyan1

暂无进展

Jan 30 '24 10:01 zengyan1

暂无进展

Feb 02 '24 10:02 zengyan1

暂无进展

Feb 07 '24 13:02 zengyan1

暂无进展

Feb 21 '24 10:02 zengyan1

暂无进展

Feb 26 '24 10:02 zengyan1

暂无进展

Feb 29 '24 10:02 zengyan1

暂无进展

Mar 05 '24 10:03 zengyan1

暂无进展

Mar 08 '24 10:03 zengyan1

暂无进展

Mar 13 '24 10:03 zengyan1

暂无进展

Mar 18 '24 10:03 zengyan1

暂无进展

Mar 21 '24 10:03 zengyan1

暂无进展

Mar 27 '24 10:03 zengyan1

暂无进展

Apr 01 '24 11:04 zengyan1

暂无进展

Apr 08 '24 10:04 zengyan1

暂无进展

Apr 11 '24 11:04 zengyan1

计划修复S-1后开始处理这个issue

Apr 16 '24 10:04 zengyan1

修复S-1后开始处理这个issue

Apr 19 '24 11:04 zengyan1

https://github.com/matrixorigin/matrixone/issues/12993, count(*) 优化完成后，approx_count可以直接改写为count

Apr 25 '24 10:04 zengyan1

count(*)优化仍需修改，合入后可解决

Apr 30 '24 11:04 zengyan1

https://github.com/matrixorigin/matrixone/pull/14774 已合入

May 06 '24 11:05 zengyan1