Hi All,
I am testing the scenario is of union of Integer and Decimal.
Observation is H2 does not merge the value when column is defined
as decimal with scale and the numeric value are the equal.
Test Integer Union Decimal (5):
select cast (1 as integer) from dual
union
select cast (1 as decimal(5)) from dual;
=> Result are merged
Test Integer Union Decimal (5,1):
select cast (1 as integer) from dual
union
select cast (1 as decimal(5,1)) from dual;
=> Result are NOT merged
Same behavior is observed when union decimal / decimal with scale
Test Decimal(5) Union Decimal (5,1):
select cast (1 as decimal(5)) from dual
union
select cast (1 as decimal(5,1)) from dual;
=> Result are NOT merged
Test Join
select * from
(select cast (10 as decimal(5)) col1 from dual ) a,
(select cast (10 as decimal(5,1)) col1 from dual) b
where a.col1 = b.col1;
=> value can be join
Is this a defect ?
--
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 post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
