According to the SQL Standard, result of subtraction of one datetime value
from another is an interval, but Oracle violates the Standard and returns a
DATE JULIAN for (DATE - DATE) and NUMBER for (TIMESTAMP - TIMESTAMP) for
historic reasons. H2 does not provide compatibility on that level,
Hello.
I think it can be caused only by invalid SQL that was used with the old
version of H2 as a workaround over its missing features, and that
workaround doesn't work any more; or by some other invalid SQL expression
that somehow worked in the old version.
You need to show us your query,
Hi,As part of spring boot upgrade, I have upgraded H2 db from 1.4.190 to
1.4.199. now few of my test cases are getting failed saying
org.h2.jdbc.JdbcSqlFeatureNotSupportedException: Feature not supported :
"INTERVAL DAY TO SECOND - BIGINT".
Anybody has encountered any such issue before or
