Parameters in the OFFSET and FETCH clauses are definitely a feature we'd like. It's moderate effort. It's not been done just because we don't have the resources.
Can you please log a JIRA case. My best "hint" is how I'd approach the problem: I'd add test methods to SqlParserTest, SqlValidatorTest, and JdbcTest with both negative and positive tests. Then I'd make code changes until they pass. It sounds flippant, but I literally don't know which code I would need to change, but the tests (and a debugger) would help me figure it out. Julian On Fri, Nov 17, 2017 at 5:43 AM, Enrico Olivelli <eolive...@gmail.com> wrote: > Hi, > I see that Calcite does not support dynamic parameters in LIMIT clause. > Is it only a simple feature to be implemented or there is a deep reason ? > I see that limit offset and fetch are already represented with RexNode in > EnumerableLimit > > If it is feasible can you give me some hint in order to create a patch ? > > This fix will be very important because YCSB benchmarks use this syntax > > Thanks > I hope to be ready to use Calcite soon in my project > > Enrico
