Postgres Numeric -> BigDecimal exception

[subkanthi]

Exception:

Error persisting records to ClickHousejava.lang.RuntimeException: java.lang.IllegalArgumentException: BigDecimal(-57896044618658100000000000000000000000000000000000000000000000000000000000000000000000000) should be between -10000000000000000000000000000000000000000000000000000000000000000000000000000 and 10000000000000000000000000000000000000000000000000000000000000000000000000000 exclusive of both values

[subkanthi]

postgresql numeric datatype

-57896044618658100000000000000000000000000000000000000000000000000000000000000000000000000

[subkanthi]

Postgres version: 14.15

[subkanthi]

Currently numeric postgres datatypes are mapped to Decimal(64,18).
The limit is currently enforced by Clickhouse-jdbc library.

[subkanthi]

CREATE TABLE test_numeric
(
    `amount` Decimal(64, 18)
)
ENGINE = MergeTree
ORDER BY amount

Query id: f1885bbf-3f31-42fd-9799-9f0bbfe4558d

Ok.

0 rows in set. Elapsed: 0.004 sec. 

42125f6acaa6 :) insert into test_numeric values(-57896044618658100000000000000000000000000000000000000000000000000000000000000000000000000)

INSERT INTO test_numeric FORMAT Values

Query id: 73782c5b-9632-4f51-8031-a64afe285788

Ok.
Exception on client:
Code: 69. DB::Exception: Too many digits (65 > 64) in decimal value:  at row 0: While executing ValuesBlockInputFormat: data for INSERT was parsed from query. (ARGUMENT_OUT_OF_BOUND)

[subkanthi]

Decimal256

42125f6acaa6 :) create table test_numeric(amount Decimal256(76)) ENGINE=MergeTree order by amount;

CREATE TABLE test_numeric
(
    `amount` Decimal256(76)
)
ENGINE = MergeTree
ORDER BY amount

Query id: 8d4f5b37-a35d-4146-bf07-4a60a4858003

Ok.

0 rows in set. Elapsed: 0.007 sec. 

42125f6acaa6 :) insert into test_numeric values(-57896044618658100000000000000000000000000000000000000000000000000000000000000000000000000)

INSERT INTO test_numeric FORMAT Values

Query id: 69a5cdb0-817f-4553-8047-391e89642940

Ok.
Exception on client:
Code: 69. DB::Exception: Too many digits (77 > 76) in decimal value:  at row 0: While executing ValuesBlockInputFormat: data for INSERT was parsed from query. (ARGUMENT_OUT_OF_BOUND)