[jira] [Created] (CALCITE-6739) Explicit cast of ARRAY to VARCHAR is rejected, but implicit is not

["Mihai Budiu (Jira)" <ji...@apache.org>]

Mihai Budiu created CALCITE-6739:
------------------------------------

             Summary: Explicit cast of ARRAY to VARCHAR is rejected, but implicit is not
                 Key: CALCITE-6739
                 URL: https://issues.apache.org/jira/browse/CALCITE-6739
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.38.0
            Reporter: Mihai Budiu


Calcite will happily cast implicitly an ARRAY to a VARCHAR, but will refuse to do it using an explicit CAST. In general, I believe that anything that can be done implicitly should also be allowed explicitly.

As a proof, the first test in postgres.iq is:

{code:sql}
# Test string and array comparison
select array[0,1,2] = '{0,1,2}';
EXPR$0
true
{code}

The matrix in https://calcite.apache.org/docs/reference.html#implicit-type-conversion says that even implicit casting should be rejected.

As an aside, the matrix is woefully incomplete, since it is missing ROW, MULTISET types, and all the INTERVAL types are bundled as a single type.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)