Prepared Statements with setArray

Hi all, we would like to use the IN operator with a single array/list argument. SELECT … WHERE COL IN(?) Avatica supports setting array parameters using ps.setArray(1, ps.getConnection().createArrayOf("VARCHAR", new Object[]{"VAL1", "VAL2"})) Unfortunately calcite optimizes the query to (whe

[jira] [Created] (CALCITE-4692) Calcite typecasts the output of aggregate functions on integer columns to DOUBLE

Narayanan Venkateswaran created CALCITE-4692: Summary: Calcite typecasts the output of aggregate functions on integer columns to DOUBLE Key: CALCITE-4692 URL: https://issues.apache.org/jira/browse/CALC

Re: Review request: CALCITE-4652 (fix AggregateExpandDistinctAggregatesRule when SUM type is expanded)

Hi. Ledkov. I'll do some code reviews in the next two days. Taras Ledkov 于2021年7月12日周一 下午7:58写道： > Hi, > > Please review the patch for the issue CALCITE-4652 [1], see PR#2439 [2]. > > I tried to draw attention to the issue in the topic: > "[HELP] Return type of the SUM aggregate function and > A

Review request: CALCITE-4652 (fix AggregateExpandDistinctAggregatesRule when SUM type is expanded)

Hi, Please review the patch for the issue CALCITE-4652 [1], see PR#2439 [2]. I tried to draw attention to the issue in the topic: "[HELP] Return type of the SUM aggregate function and AggregateExpandDistinctAggregatesRule​", but did not receive any answer, so I do not give a link to the discus

[jira] [Created] (CALCITE-4691) Incorrect handling of NOT IN and NULL values

Thomas Rebele created CALCITE-4691: -- Summary: Incorrect handling of NOT IN and NULL values Key: CALCITE-4691 URL: https://issues.apache.org/jira/browse/CALCITE-4691 Project: Calcite Issue Ty