Skip to content

Fetching column info from catalog provides wrong order of the columns sometimes  #1332

@kolsan789

Description

@kolsan789

Driver version

8.2.2

SQL Server version

Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 (Build 16299: )

Client Operating System

Windows 10

JAVA/JVM version

Java(TM) SE Runtime Environment (build 1.8.0_181-b13)

Table schema

INFORMATION_SCHEMA

Problem description

  1. Expected behaviour:
    connection.getMetaData().getColumns(catalog, schema, tableName, null) provides always the same column order

  2. Actual behaviour:
    connection.getMetaData().getColumns(catalog, schema, tableName, null) gives me the last column at first place sometimes

  3. Error message/stack trace:

  4. Any other details that can be helpful:

JDBC trace logs

Reproduction code

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions