Welcome To openGauss Community
Hey @l3007kkk , thanks for your contribution to the community.
Bot Usage Manual
I'm the Bot here serving you. You can find the instructions on how to interact with me at Here . That means you can comment below every pull request or issue to trigger Bot Commands.
Contact Guide
If you have any questions, please contact the SIG: Docs ,
and any of the maintainers: @CarrotGo, @chendong76, @chenxiaobin19, @congzhou2603, @dodders, @hwworkholic, @jemappellehc, @muyulinzhong, @quemingjian, @shenzheng4, @shirley_zhengx, @superlchf, @totaj, @wlff234, @wofanzheng, @ywzq1161327784 ,
and any of the committers: @Evawudonger, @fyq_lpl, @hemiao3787, @hujunjune, @hw_hbj, @lestertt, @libiao2024, @mentoswang, @sunyunyu, @tongdabao, @wangfeihuo, @zhangxubo, @zijianli16 .
回归结论：通过
回归版本：7.0.0-LTS b0019
回归截图：
测试类型
SQL功能
测试版本
7.0.0LTS
问题描述
测试结果与资料不符
操作系统和硬件信息
arm 2203
测试环境
企业版单机
被测功能
to char（numeric，"999,999.99")
to char（numeric，"999,999,999.99")
预置条件
操作步骤
step1 创建A库 SET behavior_compat_options = 'display_leading_zero';
step2 SELECT 'display_on' AS switch_to, '-0.50' AS val, trim(to_char(-0.50::numeric, '999,999.99')) AS fmt1, trim(to_char(-0.50::numeric, '999,999,999.99')) AS fmt2;
预期输出
同资料 纯小数时小数点前带0
实际输出
-.50
日志信息
提单组织
测试团队
测试代码