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

[Anton Vinogradov (Jira)]

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)