I assume, something goes terrible wrong with definition of the columns
during the CREATE TABLE, please see the resulting table structure below and
have an eye on *NOMINAL_BALANCE*. This column is a total of two DECIMAL(23,
5), so how do we end up with DECIMAL(2147483647, 2147483647)?
CREATE TABLE ifrsbox.PUBLIC.REP_IFRS7_DISCLOSURE
(
ID_COUNTERPARTY VARCHAR(50) NULL
, DESCRIPTION VARCHAR(2147483647) NULL
, SECTOR VARCHAR(50) NULL
, SUB_SECTOR VARCHAR(50) NULL
, ID_INSTRUMENT VARCHAR(40) NULL
, ID_INSTRUMENT_TYPE VARCHAR(12) NULL
, PRODUCT_TYPE VARCHAR(36) NULL
, PRODUCT VARCHAR(40) NULL
, END_DATE DATE NULL
, MATURITY_BUCKET VARCHAR(4) NULL
, GL_CODE VARCHAR(40) NULL
, PLEDGED VARCHAR(40) NULL
, AMORTISED_COST_DIRTY DECIMAL(23, 5) NULL
, AMORTISED_COST_DIRTY_BC DECIMAL(23, 5) NULL
, NOMINAL_BALANCE DECIMAL(2147483647, 2147483647) NULL
, NOMINAL_BALANCE_BC DECIMAL(2147483647, 2147483647) NULL
, OPEN_COMMITMENT DECIMAL(23, 5) NULL
, OPEN_COMMITMENT_BC DECIMAL(23, 5) NULL
, IMPAIRMENT DECIMAL(2147483647, 2147483647) NULL
, IMPAIRMENT_BC DECIMAL(2147483647, 2147483647) NULL
, IMPAIRMENT_CONTINGENT DECIMAL(23, 5) NULL
, IMPAIRMENT_CONTINGENT_BC DECIMAL(23, 5) NULL
, OVERDUE_DAYS DECIMAL(4) NULL
, IMPAIRMENT_STAGE DECIMAL(1) NULL
, ID_PORTFOLIO VARCHAR(40) NULL
, RATING_CLASS VARCHAR(34) NULL
, INVESTMENT_GRADE VARCHAR(14) NULL
);
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/74a16f88-7b10-470e-8a93-161aa8d01d31%40googlegroups.com.
