Skip to content

Cannot relate procedures to procedure columns (same with functions) #2739

@sualeh

Description

@sualeh

Driver version

13.2.0

SQL Server version

Microsoft SQL Server 2019 (RTM-CU32-GDR) (KB5058722) - 15.0.4435.7 (X64) Jun 9 2025 18:36:12 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Datacenter 10.0 (Build 17763: ) (Hypervisor)

Client Operating System

Windows 11

JAVA/JVM version

Java 21

Problem description

Since
getProcedures returns

  • PROCEDURE_NAME without the numeric portion (for example, without ";1")
  • SPECIFIC_NAME is null

it is not possible to relate the parameters using

getProcedureColumns which returns

  • PROCEDURE_NAME with the numeric portion (for example, including ";1")
  • SPECIFIC_NAME is null

and the same for functions.

Suggested behavior

getProcedures would return

  • PROCEDURE_NAME without the numeric portion (for example, without ";1")
  • SPECIFIC_NAME as procedure name with the numeric portion (for example, including ";1")

and relate parameters with

getProcedureColumns which would return

  • PROCEDURE_NAME without the numeric portion (for example, without ";1")
  • SPECIFIC_NAME as procedure name with the numeric portion (for example, including ";1")

and the same for functions.

Metadata

Metadata

Assignees

Labels

Under ReviewUsed for pull requests under review

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions