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

UDFs that are table functions must implement SqlTableFunction and have CURSOR as their return type

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.25.0
    • None
    • None

    Description

      UDFs that are table functions must implement SqlTableFunction and have CURSOR as their return type,

      Validate that table functions are not used in contexts that require scalar functions, such as the SELECT clause.

      Change operand type ANY to mean 'scalar expression of any type (but not a cursor)', and add operand type IGNORE to mean skip validation - for an operand that is not an expression. TABLE is one of the few operators that accepts a CURSOR operand.

      Attachments

        Issue Links

          is depended upon by

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2160 Spatial grid index, to accelerate polygon-to-polygon spatial joins

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

          New Feature - A new feature of the product, which has yet to be developed. CALCITE-3271 Table-valued function windowing and EMIT syntax support in Calcite

          • Major - Major loss of function.
          • Open

          Activity

            People

              julianhyde Julian Hyde
              julianhyde Julian Hyde
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: