[SPARK-27924] Support ANSI SQL Boolean-Predicate syntax

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Target Version/s: 3.0.0
• Assignee: Jiaan Geng
• Reporter: Yuming Wang
• Created: 03/Jun/19 08:50
• Updated: 08/May/21 09:23
• Resolved: 31/Jul/19 07:00

Description

<boolean test> ::=
  <boolean primary> [ IS [ NOT ] <truth value> ]
<truth value> ::=
    TRUE
  | FALSE
  | UNKNOWN

 
Currently, the following DBMSs support the syntax:

• PostgreSQL: https://www.postgresql.org/docs/9.1/functions-comparison.html
• Hive: https://issues.apache.org/jira/browse/HIVE-13583
• Redshift: https://docs.aws.amazon.com/redshift/latest/dg/r_Boolean_type.html
• Vertica: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/LanguageElements/Predicates/Boolean-predicate.htm

Issue Links

• links to: GitHub Pull Request #25074
• links to: GitHub Pull Request #25366
• links to: GitHub Pull Request #27699