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 @m0_57849461 , 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. You can self-configure the PR merge rules for this repository. For more details, please refer to Here.

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 .

环境：openEuler 20.03 aarch64
转测包：openGauss7.0.0.B020
构建提交：93bfec54
验证实例：single_node，端口 5832
验证内容：

1. EXPLAIN VERBOSE 优化为空的 RECORD 子查询，执行成功；
2. EXPLAIN PERFORMANCE 执行成功；
   未出现 failed to find plan for subquery/CTE。
   结果：通过。

测试版本

openGauss7.0.0.B020

操作系统和硬件信息

2403 arm

测试环境

企业版单机

操作步骤

连接数据库执行
explain select * from information_schema.parameters where specific_name = null ; -- 执行正常
explain analyze select * from information_schema.parameters where specific_name = null ; -- 执行正常
explain verbose select * from information_schema.parameters where specific_name = null ; -- 执行成功
explain performance select * from information_schema.parameters where specific_name = null ; -- 执行成功

验证结果

通过