Bug #76859 DBMD getColumns using I_S doesn't have column IS_GENERATEDCOLUMN as per JDBC 4.1
Submitted: 28 Apr 2015 1:14 Modified: 5 Oct 2015 19:14
Reporter: Jess Balint Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Filipe Silva CPU Architecture:Any

[28 Apr 2015 1:14] Jess Balint 
Description:
DBMD getColumns() using I_S doesn't have column IS_GENERATEDCOLUMN as per JDBC 4.1

the SHOW version has it. meta-data in result set is inconsistent with I_S query result

How to repeat:
call getColumns() and check for new field
[28 Sep 2015 10:20] Filipe Silva 
Posted by developer:
 
Actually, IS_GENERATEDCOLUMN is not missing from DatabaseMetaData.getColumns(), but it is always empty.

Nevertheless I'll keep this report as a verified bug to track the implementations of support for generated columns.
[5 Oct 2015 19:14] Daniel So 
Added the following entry to the Connector/J 5.1.37 changelog:

"The IS_GENERATEDCOLUMN field was empty in the result returned by DatabaseMetaData.getColumns(). This fix corrects the field so that it contains a YES or NO according to whether the column is generated or not."
[5 Oct 2015 19:21] Daniel So 
Posted by developer: