[h2] Re: Reproducible Corruption of a database, java.lang.IllegalStateException: Unsupported type 17 [1.4.200/3]

[areichel]

I saw a few recent commits on precision and scale, so I pulled from Git and 
gave it a try. 
The created table looks different now and I can open the database after 
closing it, which seems to solve my problem with the corruption.

Although I still see the very odd column NOMINAL_BALANCE DECIMAL(2147483647, 
100000) NULL.
Why would we want to set it like that instead of Decimal(23,5) as defined 
by the source columns?

CREATE TABLE ifrsbox.PUBLIC.REP_FINANCIAL_ASSETS
  (
     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, 100000) NULL
     , NOMINAL_BALANCE_BC       DECIMAL(2147483647, 100000) NULL
     , OPEN_COMMITMENT          DECIMAL(23, 5) NULL
     , OPEN_COMMITMENT_BC       DECIMAL(23, 5) NULL
     , IMPAIRMENT               DECIMAL(2147483647, 100000) NULL
     , IMPAIRMENT_BC            DECIMAL(2147483647, 100000) 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
  );

CREATE INDEX idx_rep_financial_assets_1
  ON ifrsbox.PUBLIC.rep_financial_assets(ID_COUNTERPARTY);

CREATE INDEX idx_rep_financial_assets_10
  ON ifrsbox.PUBLIC.rep_financial_assets(IMPAIRMENT_STAGE);

CREATE INDEX idx_rep_financial_assets_11
  ON ifrsbox.PUBLIC.rep_financial_assets(ID_PORTFOLIO);

CREATE INDEX idx_rep_financial_assets_12
  ON ifrsbox.PUBLIC.rep_financial_assets(RATING_CLASS);

CREATE INDEX idx_rep_financial_assets_13
  ON ifrsbox.PUBLIC.rep_financial_assets(INVESTMENT_GRADE);

CREATE INDEX idx_rep_financial_assets_2
  ON ifrsbox.PUBLIC.rep_financial_assets(SECTOR);

CREATE INDEX idx_rep_financial_assets_3
  ON ifrsbox.PUBLIC.rep_financial_assets(SUB_SECTOR);

CREATE INDEX idx_rep_financial_assets_4
  ON ifrsbox.PUBLIC.rep_financial_assets(ID_INSTRUMENT_TYPE);

CREATE INDEX idx_rep_financial_assets_5
  ON ifrsbox.PUBLIC.rep_financial_assets(PRODUCT_TYPE);

CREATE INDEX idx_rep_financial_assets_6
  ON ifrsbox.PUBLIC.rep_financial_assets(PRODUCT);

CREATE INDEX idx_rep_financial_assets_7
  ON ifrsbox.PUBLIC.rep_financial_assets(MATURITY_BUCKET);

CREATE INDEX idx_rep_financial_assets_8
  ON ifrsbox.PUBLIC.rep_financial_assets(GL_CODE);

CREATE INDEX idx_rep_financial_assets_9
  ON ifrsbox.PUBLIC.rep_financial_assets(PLEDGED); 

 

-- 
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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/2a33c89c-8e65-492e-9534-8ba3a6b67f05%40googlegroups.com.