Bug #80473 JDBC driver DatabaseMetaData.getTables() does not return remarks
Submitted: 23 Feb 2016 9:49 Modified: 21 Jan 2022 12:34
Reporter: Pruteanu Dragos Email Updates:
Status: Can't repeat Impact on me:
Category:Connector / J Severity:S3 (Non-critical)
Version:5.1.38 OS:Any
Assigned to: CPU Architecture:Any
Tags: jdbc databaseMetaData

[23 Feb 2016 9:49] Pruteanu Dragos
The DatabaseMetaData.getTables() method should return remarks in rs.getString(5). This is not working.
For columns works fine, for the tables not.
The remarks should be the one created using :
ALTER TABLE sakila.sample COMMENT 'sample comment'

How to repeat:
ALTER TABLE sakila.sample COMMENT 'sample comment'
then call
[24 Feb 2016 8:46] Chiranjeevi Battula
Hello Pruteanu Dragos,

Thank you for the bug report.
Verified this behavior on MySQL Connector / J 5.1.38.

[24 Feb 2016 8:47] Chiranjeevi Battula
test case

Attachment: 80473.java (application/octet-stream, text), 1.03 KiB.

[24 Feb 2016 8:47] Chiranjeevi Battula
List of tables: 
   sakila, null, actor, TABLE, , 
   sakila, null, address, TABLE, , 
   sakila, null, category, TABLE, , 
   sakila, null, city, TABLE, , 
   sakila, null, country, TABLE, , 
   sakila, null, customer, TABLE, , 
   sakila, null, film, TABLE, , 
   sakila, null, film_actor, TABLE, , 
   sakila, null, film_category, TABLE, , 
   sakila, null, film_text, TABLE, , 
   sakila, null, inventory, TABLE, , 
   sakila, null, language, TABLE, , 
   sakila, null, payment, TABLE, , 
   sakila, null, rental, TABLE, , 
   sakila, null, staff, TABLE, , 
   sakila, null, store, TABLE, , 
   sakila, null, actor_info, VIEW, , 
   sakila, null, customer_list, VIEW, , 
   sakila, null, film_list, VIEW, , 
   sakila, null, nicer_but_slower_film_list, VIEW, , 
   sakila, null, sales_by_film_category, VIEW, , 
   sakila, null, sales_by_store, VIEW, , 
   sakila, null, staff_list, VIEW, , 
BUILD SUCCESSFUL (total time: 0 seconds)
[18 Jul 2016 4:41] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=82251 marked as duplicate of this one.
[29 Nov 2017 10:11] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=88690 marked as duplicate of this one.
[21 Jan 2022 12:34] Alexander Soklakov
Posted by developer:
This bug is not reproducible with the latest Connector/J 8.0.

Connector/J 5.1 series came to EOL on Feb 9th, 2021, see https://www.mysql.com/support/eol-notice.html, so this bug will not be fixed there.