We are using liquibase 2.0.1 and loading in records that have trillion dollar amounts. Liquibase is truncating the penny amounts for 9,999,999,999,999.99.
Load data looks like this.
<changeSet id=“1” author=“load” >
<loadData tableName=“acct” file=“resources/accts.csv”>
<column name=“ID” type=“NUMERIC”/>
<column name=“amount” type=“NUMERIC”/>
We are on DB2 Z/OS which bombs if you don’t explicitly declare a numeric type as NUMERIC. When liquibase tries to do the insert, it wraps single quotes around the amount and bombs b/c the column is of DECIMAL type. However, NUMERIC has precision loss after it is a single digit trillion amount. Any ideas on a work around or a way to get it to stop truncating the penny amounts.