Benedek, AFAIK what you describe is simply not possible with Calcite currently.
Best, Ruben On Wed, Oct 25, 2023 at 12:22 PM Benchao Li <[email protected]> wrote: > Benedek, > > Per my understanding, dynamic parameters should be some placeholders > of literals, which means that each dynamic parameter can only be a > single literal. Hence, your requirement cannot be achieved by this > definition. > > BTW, do you know any databases that have the ability as you described? > > Benedek Halasi <[email protected]> 于2023年10月25日周三 19:12写道： > > > > Hi, > > > > We're looking for a way to parse and execute queries with Apache Calcite > > that contain an `IN (?)` expression, where the dynamic parameter is a set > > of values. > > > > As we've observed, Calcite handles dynamic parameters as single values, > and > > we haven't found a way to make it handle them differently. This causes > some > > transformations to be flawed (e.g., `IN (?)` gets transformed to `= ?`). > > > > Has anyone encountered this? Is there a go-to solution? > > > > Thanks in advance, > > Ben > > > > -- > > Best, > Benchao Li >
