[HIVE-3795] NPE in SELECT when WHERE-clause is an and/or/not operation involving null

• Type: Bug
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: Query Processor
• Assignee: Xiao Jiang
• Reporter: Xiao Jiang
• Created: 12/Dec/12 17:17
• Updated: 16/May/13 21:10
• Resolved: 18/Dec/12 06:22

Description

Sometimes users forget to quote date constants in queries. For example, SELECT * FROM some_table WHERE ds >= 2012-12-10 and ds <= 2012-12-12; . In such cases, if the WHERE-clause contains and/or/not operation, it would throw NPE exception. That's because PcrExprProcFactory in ql/optimizer forgot to check null.