If it is a deterministic promotion, you can write a RelOptRule to support this.
Best, Danny Chan 在 2019年8月29日 +0800 AM9:13，Thomas D'Silva <[email protected]>，写道： > I am looking into the possibility of using row value constructors for > paging through data. The query would be of the form > > SELECT * FROM t WHERE (pk1, pk2) > (2,'bar'); > > which should logically be equivalent to > > SELECT * FROM t WHERE pk1 > 2 OR (pk1=2 AND pk2>'bar') > > I found a previous thread where this was discussed [1]. Does anyone know > the scope of work it would take to support this feature in Calcite? > > [1] > https://lists.apache.org/thread.html/8d3154f6a636972777493d176b9bbaa69ab957145470135a0a13a1b3@1419906719@%3Cdev.calcite.apache.org%3E
