calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ";ianghaibin (JIRA)" <>
Subject [jira] [Created] (CALCITE-3241) Calcite this is a very strange mistake
Date Mon, 12 Aug 2019 01:47:00 GMT
;ianghaibin created CALCITE-3241:

             Summary: Calcite this is a very strange mistake
                 Key: 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 org.apache.commons.dbcp2.DelegatingResultSet.getInt(
at org.apache.commons.dbcp2.DelegatingResultSet.getInt(
at Baz$1$1.apply(Unknown Source)
at org.apache.calcite.runtime.ResultSetEnumerable$ResultSetEnumerator.current(
at org.apache.calcite.linq4j.Linq4j$
at sqlline.BufferedRows.nextList(
at sqlline.BufferedRows.(
at sqlline.SqlLine.print(
at sqlline.Commands.executeSingleQuery(
at sqlline.Commands.execute(
at sqlline.Commands.sql(
at sqlline.SqlLine.dispatch(
at sqlline.SqlLine.begin(
at sqlline.SqlLine.start(
at sqlline.SqlLine.main(

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

View raw message