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 @l1azzzy , 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, @ywzq1161327784 ,
and any of the committers: @Igali, @bihua111, @cailei19, @h_ray, @levy53071, @libiao2024, @lihaixiao, @mrzack, @wangfeihuo, @wuyuechuan, @xiong_xjun, @zhangfengzhi123, @zhangxubo, @zjh_hw .

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

自验证通过：

\timing on

DROP SCHEMA IF EXISTS verify_8220 CASCADE;
CREATE SCHEMA verify_8220;
SET search_path=verify_8220;

CREATE TABLE t1(a int, b int);
INSERT INTO t1 SELECT i, i FROM generate_series(1, 100) i;
ANALYZE t1;

SET query_dop=2;
SET enable_force_smp=on;

EXPLAIN (costs off) SELECT * FROM t1;

BEGIN;
SET LOCAL lockwait_timeout='5s';
SET LOCAL statement_timeout='6s';

DECLARE xc NO SCROLL CURSOR FOR SELECT * FROM t1;
MOVE ALL xc;
DROP TABLE t1;
ROLLBACK;