You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by ";ianghaibin (JIRA)" <ji...@apache.org> on 2019/08/12 01:47:00 UTC

[jira] [Created] (CALCITE-3241) Calcite this is a very strange mistake

;ianghaibin created CALCITE-3241:
------------------------------------

             Summary: Calcite this is a very strange mistake
                 Key: CALCITE-3241
                 URL: https://issues.apache.org/jira/browse/CALCITE-3241
             Project: Calcite
          Issue Type: Bug
            Reporter: ;ianghaibin


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;



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)