[Bug] CTAS got ERROR: duplicate DISTRIBUTED BY column

[avamingli]

Apache Cloudberry version

main

What happened

Create AS got :ERROR: duplicate DISTRIBUTED BY column

What you think should happen instead

No response

How to reproduce

create table dup_key_t(a int, b int, c int) distributed randomly;
create temp table temp_2 as select rn, a, b from (select a, b, row_number() over (partition by a, b order by c) rn from dup_key_t where dup_key_t.a = dup_key_t.b) x;
ERROR:  duplicate DISTRIBUTED BY column 'a'

Operating System

all

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.