Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2061

Dynamic parameters in OFFSET, FETCH and LIMIT clauses

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 1.15.0
    • 1.15.0
    • core
    • None

    Description

      Fetch/Offset already support RexNode, it will be useful to support Dynamic parameters as well.

      This implementation is needed to be able to run Yahoo YCSB JDBC benchmarks which does large use of this syntax
      select .... LIMIT ?

      Attachments

        Issue Links

          is depended upon by

          Task - A task that needs to be done. CALCITE-2049 Release Calcite 1.15.0

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5286 Join with parameterized LIMIT throws AssertionError "not a literal"

          • Major - Major loss of function.
          • Resolved
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5048 Query with parameterized LIMIT and correlated sub-query throws AssertionError "not a literal"

          • Major - Major loss of function.
          • Closed

          Activity

            People

              julianhyde Julian Hyde
              eolivelli Enrico Olivelli
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: