Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.5.8, 1.5.9
-
None
-
For MariaDB, driver version ="1.5.8" and "1.5.9",
Maria DB server version: MariaDB 10.2.4 RC
OS: windows 10
Description
PK_NAME returned in DatabaseMetadata.getPrimaryKeys() should not be null
For MariaDB, driver version ="1.5.8" and "1.5.9",
Maria DB server version: MariaDB 10.2.4 RC
DatabaseMetadata.getPrimaryKeys() returns PK_NAME as null, which is incorrect.
https://mariadb.com/kb/en/mariadb/create-table/, please note that constraint names cannot be defined by the user.
This bug breaks IBM Cognos' mutual customers to generate relationship based on primary keys and foreign keys.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
PK_NAME returned in DatabaseMetadata.getPrimaryKeys() should not be null
PK_NAME returned in DatabaseMetadata.getPrimaryKeys() should not be null For MariaDB, driver version ="1.5.8" and "1.5.9", Maria DB server version: MariaDB 10.2.4 RC DatabaseMetadata.getPrimaryKeys() returns PK_NAME as null, which is not correct. https://mariadb.com/kb/en/mariadb/create-table/, please note that constraint names cannot be defined by the user. This bug breaks IBM Cognos' mutual customers to generate relationship based on primary keys and foreign keys. |
PK_NAME returned in DatabaseMetadata.getPrimaryKeys() should not be null
For MariaDB, driver version ="1.5.8" and "1.5.9", Maria DB server version: MariaDB 10.2.4 RC DatabaseMetadata.getPrimaryKeys() returns PK_NAME as null, which is not correct. https://mariadb.com/kb/en/mariadb/create-table/, please note that constraint names cannot be defined by the user. This bug breaks IBM Cognos' mutual customers to generate relationship based on primary keys and foreign keys. |
| Summary | PK_NAME returned in DatabaseMetadata.getPrimaryKeys() should not be null | PK_NAME returned by DatabaseMetadata.getPrimaryKeys() should not be null |
| Description |
PK_NAME returned in DatabaseMetadata.getPrimaryKeys() should not be null
For MariaDB, driver version ="1.5.8" and "1.5.9", Maria DB server version: MariaDB 10.2.4 RC DatabaseMetadata.getPrimaryKeys() returns PK_NAME as null, which is not correct. https://mariadb.com/kb/en/mariadb/create-table/, please note that constraint names cannot be defined by the user. This bug breaks IBM Cognos' mutual customers to generate relationship based on primary keys and foreign keys. |
PK_NAME returned in DatabaseMetadata.getPrimaryKeys() should not be null
For MariaDB, driver version ="1.5.8" and "1.5.9", Maria DB server version: MariaDB 10.2.4 RC DatabaseMetadata.getPrimaryKeys() returns PK_NAME as null, which is incorrect. https://mariadb.com/kb/en/mariadb/create-table/, please note that constraint names cannot be defined by the user. This bug breaks IBM Cognos' mutual customers to generate relationship based on primary keys and foreign keys. |
| Fix Version/s | 1.6.1 [ 22550 ] | |
| Fix Version/s | 2.0.2 [ 22551 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
Hi diego dupin, I see this issue has been fixed in JDBC version 1.6.1 and 2.0.2. Is that correct? If so, where to download the fixed JDBC drivers? Thanks.
They will be released in a few days,
Snapshot are available though :
<repositories>
|
<repository>
|
<id>sonatype-nexus-snapshots</id>
|
<name>Sonatype Nexus Snapshots</name>
|
<url>https://oss.sonatype.org/content/repositories/snapshots</url> |
</repository>
|
</repositories>
|
|
<dependencies>
|
<dependency>
|
<groupId>org.mariadb.jdbc</groupId>
|
<artifactId>mariadb-java-client</artifactId>
|
<version>2.0.2-SNAPSHOT</version> |
</dependency>
|
</dependencies>
|
| Workflow | MariaDB v3 [ 80786 ] | MariaDB v4 [ 134978 ] |
Hi zhuq.
Right, PK_NAME must always return INDEX_NAME values (that is always set to 'PRIMARY').