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
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:
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