[Bug] orca assert failed in test

[gfphoenix78]

Cloudberry Database version

cloudberrydb main branch

What happened

diff -I HINT: -I CONTEXT: -I GP_IGNORE: -U3 /code/gpdb_src/src/test/regress/expected/gporca_optimizer.out /code/gpdb_src/src/test/regress/results/gporca.out
--- /code/gpdb_src/src/test/regress/expected/gporca_optimizer.out	2024-07-30 10:21:47.981978848 +0000
+++ /code/gpdb_src/src/test/regress/results/gporca.out	2024-07-30 10:21:48.318971743 +0000
@@ -11103,6 +11121,28 @@
 create table canSetTag_bug_table as
 SELECT attr, class, (select canSetTag_Func(count(distinct class)::int) from canSetTag_input_data)
    as dclass FROM canSetTag_input_data GROUP BY attr, class distributed by (attr);
+INFO:  GPORCA failed to produce a plan, falling back to planner
+DETAIL:  ../../../../../../src/backend/gporca/libgpopt/include/gpopt/operators/CScalarSortGroupClause.h:100: Failed assertion: EopScalarSortGroupClause == pop->Eopid()
+Stack trace:
+1    0x00007f8107de1787 gpos::CException::Raise + 215
+2    0x00007f81080d0fcd gpopt::CScalarSortGroupClause::Matches + 173
+3    0x00007f81080ea9bb gpopt::CGroupExpression::Matches + 75
+4    0x00007f810810d4dd gpopt::CMemo::FRehash + 1597
+5    0x00007f810810f221 gpopt::CMemo::GroupMerge + 273
+6    0x00007f8107ffee2e gpopt::CEngine::FinalizeExploration + 30
+7    0x00007f81080f868f gpopt::CJobGroupExploration::EevtExploreChildren + 191
+8    0x00007f81080f9076 gpopt::CJobGroupExploration::FExecute + 150
+9    0x00007f81081128e5 gpopt::CScheduler::FExecute + 101
+10   0x00007f810811459a gpopt::CScheduler::ExecuteJobs + 74
+11   0x00007f8108114b56 gpopt::CScheduler::Run + 22
+12   0x00007f8107fffad5 gpopt::CEngine::Optimize + 1381
+13   0x00007f81080d72fe gpopt::COptimizer::PexprOptimize + 62
+14   0x00007f81080d7a95 gpopt::COptimizer::PdxlnOptimize + 853
+15   0x00007f81082654f2 COptTasks::OptimizeTask + 914
+16   0x00007f8107df5e32 gpos::CTask::Execute + 66
+17   0x00007f8107df87e2 gpos::CWorker::Execute + 34
+18   0x00007f8107df4d75 gpos::CAutoTaskProxy::Execute + 101
+19   0x00007f8107dfa5b1 gpos_exec + 609
 drop function canSetTag_Func(x int);
 drop table canSetTag_bug_table;

What you think should happen instead

match the answer file

How to reproduce

https://github.com/cloudberrydb/cloudberrydb/actions/runs/10157883226/job/28096346181?pr=541

Operating System

centos 7.9

Anything else

No response

Are you willing to submit PR?

• Yes, I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct.

[github-actions]

Hey, @gfphoenix78 welcome!🎊 Thanks for taking the time to point this out.🙌