Bug #106084 The result of IS_GENERATEDCOLUMN from DatabaseMetaData#getColumns may be wrong
Submitted: 6 Jan 2022 14:36 Modified: 2 Mar 2022 13:37
Reporter: c hd Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:8.0.25 OS:Any
Assigned to: MySQL Verification Team CPU Architecture:Any

[6 Jan 2022 14:36] c hd
Description:
I want to know whether a column is Generated Columns, I try to get this from DatabaseMetaData#getColumns, but I found result of `rsColumns.getString("IS_AUTOINCREMENT")` will get `YES` eithor when the column that is `default current_timestamp`.

How to repeat:
the mainly code is as follow
```java
rowVal[23] = s2b(StringUtils.indexOfIgnoreCase(extra, "generated") != -1 ? "YES" : "NO");

```
it just find that the `Extra` of `show full columns from ${table_name}`

but for the version of mysql8, the column `Extra` will contains `DEFAULT_GENERATED` when default current_timestamp, and make the `s2b(StringUtils.indexOfIgnoreCase(extra, "generated")` true, but it's not the really generated column
[2 Feb 2022 13:37] MySQL Verification Team
Hello,

Thank you for the bug report.
Could you please provide repeatable test case (sample project, etc. - please make it as private if you prefer) to confirm this issue at our end?

Regards,
Ashwini Patil
[3 Mar 2022 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".