Bug #80473 JDBC driver DatabaseMetaData.getTables() does not return remarks
Submitted: 23 Feb 2016 9:49 Modified: 24 Feb 2016 8:46
Reporter: Pruteanu Dragos Email Updates:
Status: Verified Impact on me:
None 
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
Description:
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
DatabaseMetaData.getTables()
rs.getString(5)
[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.

Thanks,
Chiranjeevi.
[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
run:
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.