Skip to content

DatabaseMetaData#getProcedures not ordered as specified. #2321

Open
@onacit

Description

@onacit

Driver version

12.6.0.jre11

SQL Server version

Maven home: /opt/homebrew/Cellar/maven/3.9.6/libexec
Java version: 21.0.2, vendor: Eclipse Adoptium, runtime: /Library/Java/JavaVirtualMachines/temurin-21.jdk/Contents/Home
Default locale: en_KR, platform encoding: UTF-8
OS name: "mac os x", version: "14.3", arch: "aarch64", family: "mac"

Client Operating System

Maven home: /opt/homebrew/Cellar/maven/3.9.6/libexec
Java version: 21.0.2, vendor: Eclipse Adoptium, runtime: /Library/Java/JavaVirtualMachines/temurin-21.jdk/Contents/Home
Default locale: en_KR, platform encoding: UTF-8
OS name: "mac os x", version: "14.3", arch: "aarch64", family: "mac"

JAVA/JVM version

Table schema

?

Problem description

getProcedures's result should be ordered as specified yet I got,

group is not sorted according to Comparator$$Lambda/0x00000008000fe3d0 comparator because element 202:
  Procedure(super=AbstractMetadataType(super=com.github.jinahya.database.metadata.bind.Procedure@bd5520b1, unmappedValues={NUM_INPUT_PARAMS=-1, NUM_OUTPUT_PARAMS=-1, NUM_RESULT_SETS=-1}),
    procedureCat=master,
    procedureSchem=sys,
    procedureName=sp_assemblies_rowset_rmt;1,
    remarks=null,
    procedureType=2,
    specificName=null)
is not less or equal than element 203:
  Procedure(super=AbstractMetadataType(super=com.github.jinahya.database.metadata.bind.Procedure@bd5520b1, unmappedValues={NUM_INPUT_PARAMS=-1, NUM_OUTPUT_PARAMS=-1, NUM_RESULT_SETS=-1}),
    procedureCat=master,
    procedureSchem=sys,
    procedureName=sp_assemblies_rowset2;1,
    remarks=null, procedureType=2,
    specificName=null)

Expected behavior

Actual behavior

Error message/stack trace

Any other details that can be helpful

JDBC trace logs

Metadata

Metadata

Assignees

No one assigned

    Labels

    BacklogThe topic in question has been recognized and added to development backlog

    Type

    No type

    Projects

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions