Thanks a lot for response.
Ok i found partial CAST tests like :
SqlOperatorTest#testCastBooleanToNumeric, SqlOperatorTest#testCastToString
and so on.
Soon i will try to fix all observed CAST discrepancy according to:
ISO/IEC 9075-2:1999
6.22 <cast specification> standard
Hi,stanilovsky, CALCITE-5662
<https://issues.apache.org/jira/browse/CALCITE-5662> CAST(BOOLEAN as
INTEGER) throws a NumberFormatException. Maybe you can get some
information
from this JIRA. Best, LakeShen
Julian Hyde <jhyde.apa...@gmail.com> 于2023年8月2日周三 23:04写道：
I think there’s at least one jira case discussing Boolean cast. Can you
locate it?
> On Aug 2, 2023, at 5:46 AM, stanilovsky evgeny <
estanilovs...@gridgain.com> wrote:
>
> hello all !
> According to sql standard, chapter: 6.22 <cast specification>
> We can found, for example, that casting from BOOLEAN is deprecated
into
Exact Numeric, but according to SqlTypeCoercionRule
> it`s possible for now. Probably i miss something, can someone
highlight
me in such a case? If no - did i need to fill the appropriate issue ?
> Also i can`t found sufficient CAST tests (
>
> thanks !
