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 <[email protected]> 于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 < > [email protected]> 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 ! >
