Skip to content

[python adbc-driver-postgresql] Numeric altered values when ingesting #3485

@MateiNenciu

Description

@MateiNenciu

What happened?

When using cursor.adbc_ingest() to write Polars DataFrames containing decimal values to PostgreSQL, specific decimal values experience issues. For example, 44.123456 saved in a parquet file as Decimal(10.6) becomes 4412.345500 when written to a numeric(10,6) column.

I also tested directly with adbc_ingest function and it behaves the same.

Stack Trace

No response

How can we reproduce the bug?

I made a reproduction repository for this issue: https://github.com/MateiNenciu/polars-decimal-bug

Environment/Setup

Environment

  • ADBC PostgreSQL Driver: 1.8.0
  • ADBC Driver Manager: 1.8.0
  • Polars: 1.34.0b1
  • PostgreSQL: 17
  • Python: 3.12

Metadata

Metadata

Labels

Type: bugSomething isn't working

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions