[
https://issues.apache.org/jira/browse/CALCITE-1486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dongming Liu updated CALCITE-1486:
----------------------------------
Description:
SQL:
{noformat}
select 8388608/(60+27.39)
{noformat}
When I call the {code}sqlToRelConverter.convertQuery {code} convert the SqlNode
to RelNode, an error as follow:
{noformat}
Exception in thread "main" java.lang.AssertionError: Internal error: invalid
literal: 60 + 27.39
at org.apache.calcite.util.Util.newInternal(Util.java:777)
at org.apache.calcite.sql.SqlLiteral.value(SqlLiteral.java:350)
at
org.apache.calcite.sql.SqlCallBinding.getOperandLiteralValue(SqlCallBinding.java:219)
at
org.apache.calcite.sql.SqlBinaryOperator.getMonotonicity(SqlBinaryOperator.java:189)
at org.apache.calcite.sql.SqlCall.getMonotonicity(SqlCall.java:180)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectList(SqlToRelConverter.java:3502)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:665)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:622)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:2852)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:556)
at org.apache.calcite.prepare.PlannerImpl.rel(PlannerImpl.java:227)
{noformat}
Is this OK?
was:
SQL:
{noformat}
select 8388608/(60+27.39)
{noformat}
Error as follow:
{noformat}
Exception in thread "main" java.lang.AssertionError: Internal error: invalid
literal: 60 + 27.39
at org.apache.calcite.util.Util.newInternal(Util.java:777)
at org.apache.calcite.sql.SqlLiteral.value(SqlLiteral.java:350)
at
org.apache.calcite.sql.SqlCallBinding.getOperandLiteralValue(SqlCallBinding.java:219)
at
org.apache.calcite.sql.SqlBinaryOperator.getMonotonicity(SqlBinaryOperator.java:189)
at org.apache.calcite.sql.SqlCall.getMonotonicity(SqlCall.java:180)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectList(SqlToRelConverter.java:3502)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:665)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:622)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:2852)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:556)
at org.apache.calcite.prepare.PlannerImpl.rel(PlannerImpl.java:227)
{noformat}
Is this OK?
> Invalid literal error for complex expression
> --------------------------------------------
>
> Key: CALCITE-1486
> URL: https://issues.apache.org/jira/browse/CALCITE-1486
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.10.0
> Reporter: Dongming Liu
> Assignee: Julian Hyde
>
> SQL:
> {noformat}
> select 8388608/(60+27.39)
> {noformat}
> When I call the {code}sqlToRelConverter.convertQuery {code} convert the
> SqlNode to RelNode, an error as follow:
> {noformat}
> Exception in thread "main" java.lang.AssertionError: Internal error: invalid
> literal: 60 + 27.39
> at org.apache.calcite.util.Util.newInternal(Util.java:777)
> at org.apache.calcite.sql.SqlLiteral.value(SqlLiteral.java:350)
> at
> org.apache.calcite.sql.SqlCallBinding.getOperandLiteralValue(SqlCallBinding.java:219)
> at
> org.apache.calcite.sql.SqlBinaryOperator.getMonotonicity(SqlBinaryOperator.java:189)
> at org.apache.calcite.sql.SqlCall.getMonotonicity(SqlCall.java:180)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectList(SqlToRelConverter.java:3502)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:665)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:622)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:2852)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:556)
> at org.apache.calcite.prepare.PlannerImpl.rel(PlannerImpl.java:227)
> {noformat}
> Is this OK?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
