duckdb.duckdb.Error: Failed to copy data: ERROR: invalid byte sequence for encoding "UTF8": 0x00

[wonb168]

What happens?

The error occurs when writing a DuckDB table to Greenplum.
invalid byte sequence for encoding "UTF8": 0x00

To Reproduce

sql=f"""
insert into gp.tenant_{tenant}_adm.{tb}
select * from tmp_rst
;"""
exesql(sql)

OS:

mac14

PostgreSQL Version:

6.12.1(gp,pg:9.4)

DuckDB Version:

0.10.1

DuckDB Client:

python

Full Name:

wang cz

Affiliation:

Linezone

Have you tried this on the latest main branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree