You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Tanner Clary (Jira)" <ji...@apache.org> on 2024/01/25 21:06:00 UTC

[jira] [Resolved] (CALCITE-6220) Rewrite MIN/MAX(BOOLEAN) as BOOL_AND/BOOL_OR for Postgres, Redshift

     [ https://issues.apache.org/jira/browse/CALCITE-6220?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tanner Clary resolved CALCITE-6220.
-----------------------------------
    Resolution: Fixed

Merged via [26b5e9b|https://github.com/apache/calcite/commit/26b5e9be6af1be61f4665c75e913b0d1f3459dfd], thanks for the review, [~julianhyde]

> Rewrite MIN/MAX(BOOLEAN) as BOOL_AND/BOOL_OR for Postgres, Redshift
> -------------------------------------------------------------------
>
>                 Key: CALCITE-6220
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6220
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Tanner Clary
>            Assignee: Tanner Clary
>            Priority: Major
>              Labels: pull-request-available
>
> Postgres and Redshift do not allow for MIN/MAX on columns of type BOOLEAN, instead they use the BOOL_AND/BOOL_OR functions, which Calcite already supports.
> While CALCITE-6206 is in progress, I plan on just adding this as an override during unparsing for now unless there are objections. After CALCITE-6206 is resolved this could be added to the mapping I described there.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)