[
https://issues.apache.org/jira/browse/SPARK-27924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xiao Li updated SPARK-27924:
----------------------------
Description:
{quote}<boolean test> ::=
<boolean primary> [ IS [ NOT ] <truth value> ]
<truth value> ::=
TRUE
| FALSE
| UNKNOWN{quote}
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]
was:
Support for various forms of search conditions are mandatory in the SQL
standard. For example: {{<predicate> is not true;}}.
Redshift, Vertica and Hive support this feature.
[https://docs.aws.amazon.com/redshift/latest/dg/r_Boolean_type.html]
[https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/LanguageElements/Predicates/Boolean-predicate.htm]
https://issues.apache.org/jira/browse/HIVE-13583
[https://www.postgresql.org/docs/12/features-sql-standard.html]
> ANSI SQL: Boolean Test
> ----------------------
>
> Key: SPARK-27924
> URL: https://issues.apache.org/jira/browse/SPARK-27924
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Yuming Wang
> Priority: Major
>
> {quote}<boolean test> ::=
> <boolean primary> [ IS [ NOT ] <truth value> ]
> <truth value> ::=
> TRUE
> | FALSE
> | UNKNOWN{quote}
>
> 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]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
