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

Calcite this is a very strange mistake

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      0: jdbc:calcite:model=/root/calcite/apache-ca> select sum("xxx") as a from "xxx";
      java.lang.NumberFormatException: For input string: "13485468068"
      at ru.yandex.clickhouse.response.ByteFragmentUtils.parseInt(ByteFragmentUtils.java:61)
      at ru.yandex.clickhouse.response.ClickHouseResultSet.getInt(ClickHouseResultSet.java:342)
      at org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:623)
      at org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:623)
      at Baz$1$1.apply(Unknown Source)
      at org.apache.calcite.runtime.ResultSetEnumerable$ResultSetEnumerator.current(ResultSetEnumerable.java:365)
      at org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.next(Linq4j.java:683)
      at org.apache.calcite.avatica.util.IteratorCursor.next(IteratorCursor.java:46)
      at org.apache.calcite.avatica.AvaticaResultSet.next(AvaticaResultSet.java:217)
      at sqlline.BufferedRows.nextList(BufferedRows.java:110)
      at sqlline.BufferedRows.(BufferedRows.java:52)
      at sqlline.SqlLine.print(SqlLine.java:1640)
      at sqlline.Commands.executeSingleQuery(Commands.java:1017)
      at sqlline.Commands.execute(Commands.java:957)
      at sqlline.Commands.sql(Commands.java:921)
      at sqlline.SqlLine.dispatch(SqlLine.java:717)
      at sqlline.SqlLine.begin(SqlLine.java:536)
      at sqlline.SqlLine.start(SqlLine.java:266)
      at sqlline.SqlLine.main(SqlLine.java:205)

      The data I got is integer, and I am getting an error.

      However, this is not an error.

      select "xx","xx",sum("xx") as xx from "xx" group by "xx","xxx" limit 1;

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              1693294577 ;ianghaibin
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: