This issue requires an assignee. Since you haven't specified one, we've assigned TestManager as the default assignee for this issue.


Welcome To openGauss Community
Hey @liuzhen001 , 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: StorageEngine, AI, CM, CloudNative, SecurityTechnology, SQLEngine ,
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: @Igali, @bihua111, @cailei19, @h_ray, @levy53071, @libiao2024, @lihaixiao, @mrzack, @wangfeihuo, @wuyuechuan, @xiong_xjun, @zhangfengzhi123, @zhangxubo, @zhangzq131, @zjh_hw .


This issue requires an assignee. Since you haven't specified one, we've assigned TestManager as the default assignee for this issue.


回归版本:7.0.0B020
回归结论:回归通过
回归过程:



测试类型
SQL功能
测试版本
7.0.0LTS
问题描述
操作系统和硬件信息
2403arm
测试环境
企业版主备
被测功能
预置条件
操作步骤
--1、创建并切换到SQL server兼容库
drop database if exists db_1117642;
create database db_1117642 dbcompatibility 'D';
\c db_1117642;
--参数含有null值
select DATEADD(null,1,'2023/3/31');
select DATEADD(qq,null,'2023/3/31');
select DATEADD(qq,1,null);
--number为空
select DATEADD(qq,'','2023/3/31');
预期输出
datepart为null报错,其余正常输出
实际输出
日志信息
提单组织
测试团队
测试代码