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)
