search

apache / cloudberry

One advanced and mature open-source MPP (Massively Parallel Processing) database. Open source alternative to Greenplum Database.
https://cloudberry.apache.org
Apache License 2.0
430 stars 104 forks source link

[Bug] PLJava regress test failed. #648

Open wenchaozhang-123 opened 1 month ago

wenchaozhang-123 commented 1 month ago

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?

Code of Conduct

github-actions[bot] commented 1 month ago

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

tuhaihe commented 1 month ago

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

my-ship-it commented 1 month ago

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.