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

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: jdbc, sql
• Labels: jdbc metadata sql
• Assignee: Unassigned
• Reporter: Pavel Kuznetsov
• Created: 19/Dec/18 21:43
• Updated: 06/May/21 16:58

Description

Affected both thin and jdbc v2 drivers.
jdbc spec says :

ORDINAL_POSITION int => index of column in table (starting at 1)

but in fact it is a position in the metadata table itself, not position in the original table.
For example we have table

Person(id int primary key, val1 int, val2 bigint, val3 int)

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 columns by pattern - 2 or 1 and so on.

Issue Links

• is blocked by: IGNITE-11434 SQL: Create a view with list of existing COLUMNS