Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6825

Add support for ALL, SOME, ANY in RelToSqlConverter

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 1.40.0
    • None

    Description

      Add test in RelToSqlConverterTest

      @Test void testSome() {
        final String sql = "SELECT 1, \"gross_weight\" < SOME(SELECT \"gross_weight\" "
            + "FROM \"foodmart\".\"product\") AS \"t\" "
            + "FROM \"foodmart\".\"product\"";
        final String expected = "";
        sql(sql).ok(expected);
      } 

      throw AssertionError:

      java.lang.AssertionError
          at org.apache.calcite.sql.SqlUtil.unparseBinarySyntax(SqlUtil.java:442)
          at org.apache.calcite.sql.SqlSyntax$4.unparse(SqlSyntax.java:78)
          at org.apache.calcite.sql.SqlOperator.unparse(SqlOperator.java:414)
          at org.apache.calcite.sql.SqlDialect.unparseCall(SqlDialect.java:465)
          at org.apache.calcite.sql.SqlCall.unparse(SqlCall.java:133)
          at org.apache.calcite.sql.SqlAsOperator.unparse(SqlAsOperator.java:81)
          at org.apache.calcite.sql.SqlDialect.unparseCall(SqlDialect.java:465)
          at org.apache.calcite.sql.SqlCall.unparse(SqlCall.java:133) 

      Attachments

        Issue Links

          Activity

            People

              wangdiao wangdiao
              suibianwanwan33 suibianwanwan
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: