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)