IBM Db2 Showing Unique Index for Non-Unique Columns

Answered

I have a database which has 2 non-unique indexes, but tools like "Modify Table" or "Scripts > Copy DDL" show the columns as being unique indexes.

In the SYSIBM.SYSINDEXES and SYSCAT.INDEXES tables, they have a UNIQUERULE of "D", which means "Not unique; duplicates allowed" (https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/cattab/src/tpc/db2z_sysibmsysindexestable.html)

I am using the latest version of the driver (4.23.42).

I can provide other information as needed.

1 comment

@ Christian Snodgrass 
Looks like the described issue was fixed https://youtrack.jetbrains.com/issue/DBE-5705.
Try to use the latest DataGrip 2019.1 EAP https://www.jetbrains.com/datagrip/nextversion/ for verification.

0

Please sign in to leave a comment.