Description:
DBMD.getTables()->REMARKS is blank
DBMD.getTables()->TABLE_SCHEM is null
When looking up this information via SQL query, the information is found. But it is not returned by the JDBC driver.
SQL query:
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_name = <myTable>;
How to repeat:
1 - Create a table with a comment:
create table <myTable> (col_int int comment 'my col_int description', col2_year year) comment 'table description';
2 - Retrieve the metadata information about the table. Here's some sample Java code:
---------------------
ResultSet rsmd3 = dm.getTables(null, null, tableName, null);
while(rsmd3.next())
{
System.out.println("TABLE_SCHEM="+rsmd3.getString("TABLE_SCHEM"));
System.out.println("TABLE_NAME="+rsmd3.getString("TABLE_NAME"));
System.out.println("TABLE_TYPE="+rsmd3.getString("TABLE_TYPE"));
System.out.println("REMARKS="+rsmd3.getString("REMARKS"));
}
---------------------
Suggested fix:
Return relevant information for DBMD.getTables()->REMARKS and
DBMD.getTables()->TABLE_SCHEM
Description: DBMD.getTables()->REMARKS is blank DBMD.getTables()->TABLE_SCHEM is null When looking up this information via SQL query, the information is found. But it is not returned by the JDBC driver. SQL query: SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_name = <myTable>; How to repeat: 1 - Create a table with a comment: create table <myTable> (col_int int comment 'my col_int description', col2_year year) comment 'table description'; 2 - Retrieve the metadata information about the table. Here's some sample Java code: --------------------- ResultSet rsmd3 = dm.getTables(null, null, tableName, null); while(rsmd3.next()) { System.out.println("TABLE_SCHEM="+rsmd3.getString("TABLE_SCHEM")); System.out.println("TABLE_NAME="+rsmd3.getString("TABLE_NAME")); System.out.println("TABLE_TYPE="+rsmd3.getString("TABLE_TYPE")); System.out.println("REMARKS="+rsmd3.getString("REMARKS")); } --------------------- Suggested fix: Return relevant information for DBMD.getTables()->REMARKS and DBMD.getTables()->TABLE_SCHEM