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

Rank to TopRank to BottomVotersWatch issueWatchersConvert to sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              julianhyde Julian Hyde

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment