[jira] [Created] (IGNITE-14065) JDBC DatabaseMetaData::getColumns should return vendor specific data types, like UUID, in TYPE_NAME

["Lukas Eder (Jira)" <ji...@apache.org>]

Lukas Eder created IGNITE-14065:
-----------------------------------

             Summary: JDBC DatabaseMetaData::getColumns should return vendor specific data types, like UUID, in TYPE_NAME
                 Key: IGNITE-14065
                 URL: https://issues.apache.org/jira/browse/IGNITE-14065
             Project: Ignite
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 2.9.1
            Reporter: Lukas Eder


Create a table using a UUID column type:
{code:java}
create table t (i int primary key, u uuid);{code}
I'd expect this type to be reported as the TYPE_NAME in a DatabaseMetaData::getColumns call (e.g. PostgreSQL or H2 are doing this).
{code:java}
try (ResultSet rs = c.getMetaData().getColumns(null, "PUBLIC", "T", null)) {
  while (rs.next())
    System.out.println(rs.getString(6)); // TYPE_NAME
}{code}
However, the reported TYPE_NAME is OTHER. There is no way to discover the UUID type from this method call. The Javadoc on getColumns reads:
{quote}*TYPE_NAME* String {{=>}} Data source dependent type name, for a UDT the type name is fully qualified
{quote}
So, I'd say, this is perfectly qualified for this information.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)