Hello.
Scale should be unsigned according to the SQL Standard, so such definition
is invalid.
On the other hand, H2 supports the negative scale in numeric data types and
such support was broken by accident.
--
You received this message because you are subscribed to the Google Groups "H2
Hello.
Please, take a look on the documentation of identifiers:
https://h2database.com/html/grammar.html#name
You need to use "firstDay" and "lastDay" with double quotes instead,
because "firstDay" and firstDay = "FIRSTDAY" are different identifiers.
--
You received this message because you
I have a function datelist(startDate,endDate) returning a ResultSet that
containes 2 columns firstDay,lastDay.
select * from datelist('2019-01-01','2019-03-01') as cal
This works well, returning
firstDay lastDay
----
2019-01-012019-01-31
2019-02-012019-02-28
If a number column has a negative scale value, e.g. NUMBER (5, -2), the
precision and scale values are incorrect. They are set to 32767, regardless
of the real values. Versions prior to 1.4.198 do not show this error. The
attached example shows the error if the h2 version in pom.xml is set to >