Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3375

FUNCTION idblocalpm does not exist using CTE - udf are not loaded consistently

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.2.4
    • Icebox
    • PrimProc
    • None
    • 2um 2pm with local query

    Description

      Customer report issue, request that the related select not be placed in JIRA. So you will need to view that in the issue.

      I have been using the idb function successfully, but I can't use them with a CTE :

      SELECT IN THE ISSUE

      ERROR 1305 (42000) at line 6: FUNCTION pic.idblocalpm does not exist

      Looks like it is looking for the function in the pic schema, which schema should I call it ?

      ---------------------------------------

      Got input from development , D.H.

      I don't think changing the schema name will make a difference. What that says is that it can't find the function in the current context. Those functions were added as UDF before we had CTE. Not sure what is going on here. This needs a JIRA.

      Attachments

        Activity

          People

            leonid.fedorov Leonid Fedorov
            hill David Hill (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.