[HIVE-21113] For HPL/SQL that contains boolean expression with NOT, incorrect SQL may be generated.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: hpl/sql
• Hadoop Flags: Reviewed
• Assignee: Baoning He
• Reporter: Baoning He
• Created: 10/Jan/19 08:02
• Updated: 17/Nov/22 08:55
• Resolved: 12/Jan/19 00:37

Description

In HPL/SQL, ' SELECT * FROM a WHERE NOT (1 = 2) ' will generate to incorrect SQL ' SELECT * FROM a WHERE (1 = 2) ', the 'NOT' in boolean expression is missing.