[jira] [Created] (IGNITE-10745) SQL: jdbc metadata's getColumns returns wrong value for "ORDINAL_POSITION"

["Pavel Kuznetsov (JIRA)" <ji...@apache.org>]

Pavel Kuznetsov created IGNITE-10745:
----------------------------------------

             Summary: SQL: jdbc metadata's getColumns returns wrong value for "ORDINAL_POSITION" 
                 Key: IGNITE-10745
                 URL: https://issues.apache.org/jira/browse/IGNITE-10745
             Project: Ignite
          Issue Type: Bug
          Components: jdbc
            Reporter: Pavel Kuznetsov


Affected both thin and jdbc v2 drivers.
jdbc spec says : 
{noformat}
ORDINAL_POSITION int => index of column in table (starting at 1)
{noformat}

but in fact it is a position in the metadata table itself, not position in the original table. 
For example we have table 
{code:sql}
Person(id int primary key, val1 int, val2 bigint, val3 int)
{code:sql}

Oridinal number for {{val3}} is 4, but if we specified patterns that leave only 1 result  ({{PUBLIC.Person.val3}}) returned value will be 1. If we select 2 tables - 2 or 1 and so on.



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