Re: [DISCUSS] CAST DOUBLE to BOOLEAN

2023-01-18 Thread Julian Hyde
I agree, we should not support converting (explicitly or implicitly) any numeric type to BOOLEAN. We made a mistake when we documented the conversions (the table did not match actual or intended behavior) I have just logged https://issues.apache.org/jira/browse/CALCITE-5485 to ensure that the

[jira] [Created] (CALCITE-5485) Make type conversion documentation consistent with behavior and tests

2023-01-18 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-5485: Summary: Make type conversion documentation consistent with behavior and tests Key: CALCITE-5485 URL: https://issues.apache.org/jira/browse/CALCITE-5485 Project:

Help converting a SHA1 hash to Oracle

2023-01-18 Thread Jonathan Farina
Hi I am trying to write some code that will take a MySQL SQL statement that includes a SHA1 hash statement and have it translate successfully to Oracle and in doing so add a cast function. Eg: select sha1(address) from locations limit 10 Should translate to: SELECT