[ https://issues.apache.org/jira/browse/FLINK-4565?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15804208#comment-15804208 ]
ASF GitHub Bot commented on FLINK-4565: --------------------------------------- Github user twalthr commented on a diff in the pull request: https://github.com/apache/flink/pull/2870#discussion_r94921085 --- 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()" --- End diff -- We should not modify decimals here. What does the SQL standard says about this? Is 2.00 and 2 equal in SQL? > 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: Nikolay Vasilishin > > 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.4#6332)