ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Kuznetsov (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (IGNITE-9989) JDBC v2: getPrimaryKeys always returns constant COLUMN_NAME, KEY_SEQ, PK_NAME
Date Wed, 07 Nov 2018 18:50:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-9989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16678625#comment-16678625
] 

Pavel Kuznetsov edited comment on IGNITE-9989 at 11/7/18 6:49 PM:
------------------------------------------------------------------

One more question: in the javadoc of {{java.sql.DatabaseMetaData#getPrimaryKeys}} there is
nothing about {{null}} value or sql wildchars (like {{"%"}}) in {{table}} parameter. Currently,
we are treating this parameter as "table name pattern", should we change this behaviour? 


was (Author: pkouznet):
One more question: in the javadoc of {{java.sql.DatabaseMetaData#getPrimaryKeys}} there is
nothing about {{null}} or {{"%"}} values of table parameter. Currently we are treating this
parameter as "table name pattern" which could be wrong, should we change this behaviour? 

> JDBC v2: getPrimaryKeys always returns constant COLUMN_NAME, KEY_SEQ, PK_NAME
> -----------------------------------------------------------------------------
>
>                 Key: IGNITE-9989
>                 URL: https://issues.apache.org/jira/browse/IGNITE-9989
>             Project: Ignite
>          Issue Type: Bug
>    Affects Versions: 2.6
>            Reporter: Pavel Kuznetsov
>            Assignee: Pavel Kuznetsov
>            Priority: Major
>              Labels: jdbc
>
> Jdbc v2 driver has hardcoded values for meta attibutes : 
> COLUMN_NAME = _KEY 
> KEY_SEQ = 1
> PK_NAME = _KEY
> But this values should be different for different tables.
> how to reproduce: 
> 1) connect to the cluser using jdbcv2 driver
> 2) CREATE TABLE TAB (ID LONG, SEC_ID LONG, VAL LONG, PRIMARY KEY(ID, SEC_ID))
> 3) check result of connection.getMetadata().getPrimaryKeys()



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message