[ https://issues.apache.org/jira/browse/CALCITE-3241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16907044#comment-16907044 ]
Danny Chan commented on CALCITE-3241: ------------------------------------- [~1693294577] Thanks, can you summarize and make an abstract the issue about the error, or even better, can you give a test case in Calcite to reproduce this problem ? It would helps a lot for the contributors who has willingness on this issue. > 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 > Priority: Major > > 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)