Github user twalthr commented on the issue:
https://github.com/apache/flink/pull/6007
Thanks for the PR @snuyanzin. I created the issue because it seems that
this is more than a one line change. I tested your queries in Postgres SQL and
it returns 0 instead of 1. We should have the same semantics as popular
database vendors. How is Oracle defining this feature?---
