Bug #88690 DatabaseMetaData.getTables() remarks not listed
Submitted: 29 Nov 2017 8:25 Modified: 29 Nov 2017 10:11
Reporter: Pruteanu Dragos Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:5.1.44 OS:Any
Assigned to: CPU Architecture:Any
Tags: JDBC table comments

[29 Nov 2017 8:25] Pruteanu Dragos
Description:
The DatabaseMetaData.getTables() should list in rs.getString(5) the table remarks, but it does not. Please check this. We use this to maintain a  documented database schema in the databases.

https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTables(java.la...])

How to repeat:
We issue 
ALTER TABLE sakila.film COMMENT 'sample comment'

and then call DatabaseMetaData.getTables() and read the remarks.
[29 Nov 2017 10:11] Chiranjeevi Battula
Hello Pruteanu Dragos,

Thank you for the bug report.
This is most likely duplicate of Bug #80473, please see Bug #80473

Thanks,
Chiranjeevi.