[CALCITE-1486] Invalid "Invalid literal" error for complex expression

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.10.0
• Fix Version/s: 1.11.0
• Assignee: Julian Hyde
• Reporter: Dongming Liu
• Created: 09/Nov/16 08:48
• Updated: 16/Jul/18 17:51
• Resolved: 13/Nov/16 01:51

Description

SQL:

select 8388608/(60+27.39)

When I call the

sqlToRelConverter.convertQuery 

convert the SqlNode to RelNode, an error as follow:

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)

Is this OK?

Issue Links

• is duplicated by: CALCITE-1504 Assertion error when determining monotonicity
• is related to: CALCITE-2416 Assertion error when determining monotonicity