[ https://issues.apache.org/jira/browse/FLINK-21637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17333590#comment-17333590 ]
Flink Jira Bot commented on FLINK-21637: ---------------------------------------- This issue was marked "stale-assigned" and has not received an update in 7 days. It is now automatically unassigned. If you are still working on it, you can assign it to yourself again. Please also give an update about the status of the work. > Wrong results when filtering by timestamp type > ---------------------------------------------- > > Key: FLINK-21637 > URL: https://issues.apache.org/jira/browse/FLINK-21637 > Project: Flink > Issue Type: Bug > Components: Table SQL / Planner > Reporter: Rui Li > Assignee: Jark Wu > Priority: Major > Labels: stale-assigned > Fix For: 1.13.0 > > > The following test can reproduce the issue: > {code} > @Test > def test(): Unit = { > TestCollectionTableFactory.reset() > TestCollectionTableFactory.initData( > Collections.singletonList(Row.of("a", > LocalDateTime.parse("2021-03-05T20:35:01.1")))) > tEnv.executeSql("create table src(s string,ts timestamp) with('connector' > = 'COLLECTION')") > val results = CollectionUtil.iteratorToList( > tEnv.executeSql("select s from src where timestamp '2021-03-05 > 20:35:01' = ts").collect()) > assertEquals(0, results.size()) > } > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)