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
