Support system columns

[ktny]

What happens?

SELECT ctid FROM columnstore_table causes an error.

To Reproduce

create table columnstore_table (id int) using columnstore;
select ctid from columnstore_table;

ERROR:  (PGDuckDB/CreatePlan) Prepared query returned an error: 'Binder Error: Referenced column "ctid" not found in FROM clause!
Candidate bindings: "columnstore_table.id"
LINE 1: SELECT ctid FROM pgmooncake.public.columnstore...

In a heap table, ctid can be used.

create table heap_table (id int);
select ctid from heap_table;

 ctid
------
(0 rows)

OS:

Debian GNU/Linux 12 (bookworm)

pg_mooncake Version:

latest docker image

Postgres Version:

17.0

Are you using pg_mooncake Docker, Neon, or the extension standalone?

pg_mooncake Docker Image

[dpxcc]

Thanks for the feature request!
We've filed a feature request upstream: duckdb/pg_duckdb#430