[Bug] PLJava regress test failed.

[wenchaozhang-123]

Cloudberry Database version

No response

What happened

When we run pljava regress test will fail

What you think should happen instead

No response

How to reproduce

SELECT javatest.transferPeople(1) FROM javatest.test; -- should error
-ERROR: query plan with multiple segworker groups is not supported
-HINT: likely caused by a function that reads or modifies data in a distributed table
+ERROR: function cannot execute on a QE slice because it accesses relation "javatest.employees1"
+CONTEXT: SQL statement "SELECT id, name, salary FROM employees1 WHERE salary > $1"

Operating System

centos7

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, @wenchaozhang-123 welcome!🎊 Thanks for taking the time to point this out.🙌

[tuhaihe]

Does creating one issue on @cloudberrydb/pljava repo make sense?

[my-ship-it]

After discussion, the root cause is there is a plan diff for postgres planner and ORCA, so it's database kernel bug.

For postgres planner, javatest.transferPeople is executed at QD after gather, but for ORCA, javatest.transferPeople is executed on QE.

If add execute on master when creating function javatest.transferPeople, another error occurred.