DatabaseMetaData getIndexInfo does not include COLUMNSTORE Indexes

[goranschwarz]

Driver version

12.8.1.0

SQL Server version

Microsoft SQL Server 2022 (RTM-GDR) (KB5046861) - 16.0.1135.2 (X64)
Oct 18 2024 15:31:58
Copyright (C) 2022 Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Pro 10.0 (Build 22631: ) (Hypervisor)

Client Operating System

Windows (but really any)

JAVA/JVM version

java version "21.0.1" 2023-10-17 LTS

Table schema

WideWorldImporters.Sales.InvoiceLines

Problem description

DatabaseMetaData getIndexInfo does not include COLUMNSTORE Indexes

• See Screenshot from one of my tools:
• And a Screenshot from SSMS:

Expected behavior

That all indexes that re on the table are included in the resultset

Actual behavior

Output of what you actually see.

Error message/stack trace

None

Any other details that can be helpful

Nope

JDBC trace logs

None