SNOW-912245: DatabaseMetaData.getProcedureParameters and getFunctionParameters are failing

[dbschema-pro]

Calling this methods are slow or fails.

[sfc-gh-spanaite]

@wise-coders Can you post a sample code rather than a screenshot so I can see what you are trying to do?

[dbschema-pro]

This is for loading the schema structure in DbSchema, a database designer.
We found out that this happens for build-in functions and procedures.

it seems that built in function (is_buildin = ‚Y‘) could not use „desc function“

But the build-in functions are listed by SELECT GET_DDL ( 'SCHEMA', '<schema_name>', true)
and DatabaseMetaData.getFunctions() and getProcedures().
I think you should exclude the build-in procedures and functions from this methods.

[sfc-gh-spanaite]

@wise-coders I am not sure I get it. For built-in functions you cannot use desc function <func_name> or select get_ddl and this is publicly documented (it only works for UDFs or external functions):

• describe function:
  Describes the specified user-defined function (UDF) or external function, including the signature (i.e. arguments), return value, language, and body (i.e. definition).

• get_ddl:
  FUNCTION (for UDFs, including external functions)

[dbschema-pro]

We use select get_ddl only with the complete schema, and probably this does include the build in functions in the generated DDL.
Could you please double-check if this is true?

[sfc-gh-spanaite]

That is not true, as I have done a quick test.

Let's say I use a specific database/schema of my own. If I do show functions I will see all functions including the OOB ones. Now for the same schema I do SELECT GET_DDL ( 'SCHEMA', '<schema_name>', true); and I see only my UDFs in the output, but not the OOB ones.

So, maybe you're using something else as well like show functions rather than only select get_ddl. That would explain it, but again as of now I see the behavior as the one documented.

[sfc-gh-spanaite]

Any other feedback @wise-coders otherwise I will close this issue.