On Friday, November 22, 2019 at 2:44:22 PM UTC+7, Evgenij Ryazanov wrote:
>
> Anyway, the result of addition has larger precision for additional
> possible digit, so in some use cases an explicit cast is still necessary.
>
Yes, but in that case this is to expect and you would have needed to do the
same cast in any/most programming languages.
I just tested the commit and it worked beautiful! I can not overstate my
appreciation, because CAST seems to be very very slow and really harmed the
performance (am I right on that?!).
The table looks now as expected. Thank you so much again and cheers!
CREATE TABLE ifrsbox.public.REP_FINANCIAL_ASSETS
(
ID_COUNTERPARTY VARCHAR(50) NULL
, DESCRIPTION VARCHAR(255) 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(24, 5) NULL , NOMINAL_BALANCE_BC
DECIMAL(24, 5) NULL*
, OPEN_COMMITMENT DECIMAL(23, 5) NULL
, OPEN_COMMITMENT_BC DECIMAL(23, 5) NULL
,
* IMPAIRMENT DECIMAL(24, 5) NULL , IMPAIRMENT_BC
DECIMAL(24, 5) 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
, MASTER_RATING INTEGER(10) 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/97a39da5-27fa-45a3-beba-e13892b727f5%40googlegroups.com.
