numeric : NumericParseError(ErrorString("Invalid decimal: overflow from too many digits")

[readyset-railway]

Summary

numeric data type raises an overflow error when a large decimal number is added.

Steps to reproduce

CREATE TABLE t1 (a numeric(1000,800));

INSERT INTO t1 VALUES ('-994877526002806872754342148749241.04353023451866590387054959174736129501310680280823383331007646306243540953499740615246583399296334239109936336446284803020643582102868247857009494139535009572740621288230740389545481395');

ReadySet version

359b727a7c016c3975ff946201cd9a48f215f448

Upstream DB type and version

Postgres 16

Logs

2024-03-13T13:45:33.145345Z ERROR replicators::noria_adapter: Will stop replicating a table due to table error table="public"."t1" error=Error during replication: WAL error: NumericParseError(ErrorString("Invalid decimal: overflow from too many digits"))
2024-03-13T13:45:33.145966Z  INFO replicators::noria_adapter: Removing table state from readyset table="public"."t1"
2024-03-13T13:45:33.148000Z  INFO replicators::table_filter: denying replication schema=public table=t1
2024-03-13T13:45:33.148991Z  WARN replicators::noria_adapter: Restarting adapter after error encountered error=Internal error: invariant failed: lsn == cur_pos.commit_lsn;
left = 0/44C33458;
right = 0/44C331E0
2024-03-13T13:45:33.149022Z ERROR replicators: Error in replication, will retry after timeout error=Internal error: invariant failed: lsn == cur_pos.commit_lsn;
left = 0/44C33458;
right = 0/44C331E0 timeout_sec=1
2024-03-13T13:45:34.163864Z  INFO replicators::postgres_connector::ddl_replication: Setting up DDL replication
2024-03-13T13:45:34.164625Z  INFO tokio_postgres::connection: NOTICE: schema "readyset" already exists, skipping
2024-03-13T13:45:34.172269Z  INFO replicators::postgres_connector::ddl_replication: Set up DDL replication
2024-03-13T13:45:34.178152Z  INFO replicators::noria_adapter: Connected to PostgreSQL
2024-03-13T13:45:34.180300Z  INFO replicators::noria_adapter: readyset_slot_exists full_resnapshot=false resnapshot=false pos=Some(0/44C333A8)
2024-03-13T13:45:34.182364Z  INFO replicators::postgres_connector::connector: confirmed_flush_lsn="0/44C31AD0" wal_status="reserved"
2024-03-13T13:45:34.185559Z  INFO replicators::noria_adapter: Streaming replication started
2024-03-13T13:45:34.186738Z ERROR replicators::noria_adapter: Will stop replicating a table due to table error table="public"."t1" error=Error during replication: WAL error: NumericParseError(ErrorString("Invalid decimal: overflow from too many digits"))
2024-03-13T13:45:34.186776Z  INFO replicators::noria_adapter: Removing table state from readyset table="public"."t1"
2024-03-13T13:45:34.188191Z  INFO replicators::table_filter: denying replication schema=public table=t1
2024-03-13T13:45:34.188396Z  WARN replicators::noria_adapter: Restarting adapter after error encountered error=Internal error: invariant failed: lsn == cur_pos.commit_lsn;
left = 0/44C33458;
right = 0/44C331E0
2024-03-13T13:45:34.188420Z ERROR replicators: Error in replication, will retry after timeout error=Internal error: invariant failed: lsn == cur_pos.commit_lsn;
left = 0/44C33458;
right = 0/44C331E0 timeout_sec=1