DBeaver query results in cast error

[ybrs]

I was testing DBeaver and when connecting I'm getting this error

[2025-09-20T23:03:46Z INFO  datafusion_postgres::handlers] Sending error: Internal error: could not cast array of type Int64 to arrow_array::array::primitive_array::PrimitiveArray<arrow_array::types::Int32Type>.
    This issue was likely caused by a bug in DataFusion's code. Please help us to resolve this by filing a bug report in our issue tracker: https://github.com/apache/datafusion/issues

It looks like dbeaver sends this query on connection

select t.oid as __alias_oid, t.*, c.relkind, format_type(nullif(t.typbasetype, 0), t.typtypmod) as base_type_name, d.description from pg_catalog.pg_type as t left outer join pg_catalog.pg_type as et on et.oid = t.typelem left outer join pg_catalog.pg_class as c on c.oid = t.typrelid left outer join pg_catalog.pg_description as d on t.oid = d.objoid where t.typname is not null and (c.relkind is null or c.relkind = 'c') and (et.typcategory is null or et.typcategory <> 'c')

Then it gives the error (for this query I'm also getting the error with psql)

I'm testing with DBeaver Version 25.2.0.202508311659 and latest master branch.

For the server using this with datafusion-postgres-cli

cargo run -- --csv data:delhiclimate.csv

[ybrs]

Just digging a bit more, seems like the issue might be related to casting in format_type. To reproduce simply you can run this

postgres=> select oid, format_type(oid, NULL) from pg_type;
ERROR:  Internal error: could not cast array of type Int64 to arrow_array::array::primitive_array::PrimitiveArray<arrow_array::types::Int32Type>.
This issue was likely caused by a bug in DataFusion's code. Please help us to resolve this by filing a bug report in our issue tracker: https://github.com/apache/datafusion/issues

[sunng87]

I think the root cause is oid in pg_type table being treated as bigint. Let me fix it from data level. The format_type function should not accept int64.

[sunng87]

hmmm.. the query sent from dbeaver includes a nullif with int literal and it's treated as int64 by default. So we still need to support int64 as input