[jira] [Created] (CALCITE-6414) Resolve Snoflake SQL generation of BOOL_OR, BOOL_AND

["Justin Swett (Jira)" <ji...@apache.org>]

Justin Swett created CALCITE-6414:
-------------------------------------

             Summary: Resolve Snoflake SQL generation of BOOL_OR, BOOL_AND 
                 Key: CALCITE-6414
                 URL: https://issues.apache.org/jira/browse/CALCITE-6414
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Justin Swett


The rewriteMacMInExpr is generating incorrect SQL for Snowflake.

Instead of BOOL_OR, it should be BOOLOR_AGG and instead BOOL_AND, it should be BOOLAND_AGG

 

I think adding the following expectation in testMaxMinOnBooleanColumn should repro:

```

@Test void testMaxMinOnBooleanColumn() {

...   

final String expectedSnowflake = "SELECT BOOLOR_AGG(\"brand_name\" = 'a'), "
        + "BOOLAND_AGG(\"brand_name\" = 'a'), "
        + "MIN(\"brand_name\")\n"
        + "FROM \"foodmart\".\"product\"";
    sql(query)
      .ok(expected)
      .withSnowflake().ok(expectedSnowflake)

  }

```



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