[ https://issues.apache.org/jira/browse/FLINK-4565?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15890565#comment-15890565 ]
ASF GitHub Bot commented on FLINK-4565: --------------------------------------- Github user DmytroShkvyra commented on a diff in the pull request: https://github.com/apache/flink/pull/2870#discussion_r103736499 --- Diff: flink-libraries/flink-table/src/main/scala/org/apache/flink/api/table/codegen/calls/ScalarOperators.scala --- @@ -1002,12 +1068,17 @@ object ScalarOperators { val resultTypeTerm = primitiveTypeTermForTypeInfo(resultType) // no casting necessary if (operandType == resultType) { - (operandTerm) => s"$operandTerm" + if (isDecimal(operandType)) { + (operandTerm) => s"$operandTerm.stripTrailingZeros()" + } else { + (operandTerm) => s"$operandTerm" + } } // result type is decimal but numeric operand is not else if (isDecimal(resultType) && !isDecimal(operandType) && isNumeric(operandType)) { (operandTerm) => - s"java.math.BigDecimal.valueOf((${superPrimitive(operandType)}) $operandTerm)" + s"java.math.BigDecimal.valueOf((${superPrimitive(operandType)}) $operandTerm)" + --- End diff -- @twalthr See my comment above > Support for SQL IN operator > --------------------------- > > Key: FLINK-4565 > URL: https://issues.apache.org/jira/browse/FLINK-4565 > Project: Flink > Issue Type: Improvement > Components: Table API & SQL > Reporter: Timo Walther > Assignee: Dmytro Shkvyra > > It seems that Flink SQL supports the uncorrelated sub-query IN operator. But > it should also be available in the Table API and tested. -- This message was sent by Atlassian JIRA (v6.3.15#6346)