ORCA & orafce: add new type, create partition table, select table ORCA coredump

[HelloYJohn]

Bug Report

ORCA & orafce: add new type, ORCA coredump

Greenplum version or build

PostgreSQL 12.12 (Greenplum Database 7.0.0+dev.261.g946eb7793c build dev) on x86_64-apple-darwin23.2.0, compiled by Apple clang version 15.0.0 (clang-1500.1.0.2.5), 64-bit compiled on Dec 26 2023 09:22:45 Bhuvnesh C.

OS version and uname -a

autoconf options used ( config.status --config )

Installation information ( pg_config )

Expected behavior

no coredump

Actual behavior

coredump

Step to reproduce the behavior

oracle-date.patch S1. add a new type oracle.date

cd gpcontrib/orafce
git apply oracle-date.patch
make clean && make install

S2. drop extension orafce, rerstart gpdb, create extension orafce if you have any about orafce, please backup it.

 drop extension orafce cascade;
 \! gpstop -ra
create extension orafce;

S3. create partition table and select partition table

set search_path to oracle;
drop table test_upsert_single_pk_date cascade;
create table test_upsert_single_pk_date (
        single_id oracle.date,
        name varchar,
        gender varchar not null,
        age oracle.date,
        height integer,
        weight integer,
        constraint "single_id_pk_date" primary key(single_id)
)DISTRIBUTED BY (single_id)partition by RANGE(single_id);
create table test_upsert_single_pk_date_p1 partition of test_upsert_single_pk_date for values from ('1990-1-1') to ('1999-12-31');

create table test_upsert_single_pk_date_p2 partition of test_upsert_single_pk_date for values from ('1999-12-31') to ('2010-12-31');

create table test_upsert_single_pk_date_p3 partition of test_upsert_single_pk_date for values from ('2010-12-31') to ('2023-12-31');

create table test_upsert_single_pk_date_p4 partition of test_upsert_single_pk_date for values from ('2023-12-31') to ('2099-12-31');

create table test_upsert_single_pk_date_default partition of test_upsert_single_pk_date default;
select * from test_upsert_single_pk_date;