Re: [h2] Re: ALIAS function not supporting Number parameter type

2019-10-23 Thread Noel Grandin
the problem is that H2 is trying to convert the argument to a valid type and because it doesn't know how to deal with Number, ends up in a fallback path that produces a less than useful error message. Probably we should just remove that fallback path and instead throw a conversion error.

Re: [h2] Re: ALIAS function not supporting Number parameter type

2019-10-23 Thread Jack Green
Thanks - I understand that, but if it simply returned the String from the function (that it already computed) it’d be fine. But instead it’s then trying to convert that String from hex for some reason that’s the part that’s failing? > On 23 Oct 2019, at 1:32 pm, Evgenij Ryazanov wrote: > > 

[h2] Re: ALIAS function not supporting Number parameter type

2019-10-23 Thread Evgenij Ryazanov
Hello. java.lang.Number is an abstract class in Java that has different implementations, such as `BigInteger`, `BigDecimal`, wrappers over primitive data types and you can create your own implementations too. So, technically, it can hold everything. This data type is not supported by JDBC. It