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

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.25.0
    • Component/s: None
    • Labels:
      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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: