xiong duan created CALCITE-7056: ----------------------------------- Summary: Convert RelNode to Sql failed when the RelNode includes quantify operators Key: CALCITE-7056 URL: https://issues.apache.org/jira/browse/CALCITE-7056 Project: Calcite Issue Type: Bug Reporter: xiong duan
{code:java} @Test void testQuantifyOperatorsWithTypeCoercion() { final String query = "SELECT '1970-01-01 01:23:45' = any (array[timestamp '1970-01-01 01:23:45'," + "timestamp '1970-01-01 01:23:46'])"; final String expected = "SELECT '1970-01-01 01:23:45' = any (array[timestamp '1970-01-01 01:23:45'," + "timestamp '1970-01-01 01:23:46'])"; sql(query) .withCalcite().ok(expected); } {code} It throws an exception : {code:java} class org.apache.calcite.rex.RexCall cannot be cast to class org.apache.calcite.rex.RexSubQuery (org.apache.calcite.rex.RexCall and org.apache.calcite.rex.RexSubQuery are in unnamed module of loader 'app'){code} -- This message was sent by Atlassian Jira (v8.20.10#820010)