[CALCITE-3433] EQUALS operator between date/timestamp types returns false if the type is nullable

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.17.0, 1.18.0, 1.19.0, 1.20.0, 1.21.0
• Fix Version/s: 1.22.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Feng Zhu
• Reporter: jiezouSH
• Created: 21/Oct/19 05:45
• Updated: 06/Mar/20 04:36
• Resolved: 01/Nov/19 06:30

Description

sql

select time0 = time1
from (select
            timestamp'2000-12-30 21:07:32' as time0,
            timestamp'2000-12-30 21:07:32' as time1
          union all
          select
            cast(null as timestamp) as time0,
            cast(null as timestamp) as time1)

answer is false

but 

sql

select time0 = time1
from
(select
  timestamp'2000-12-30 21:07:32' as time0,
  timestamp'2000-12-30 21:07:32'as time1)

answer is true

 

Issue Links

• links to: GitHub Pull Request #1540