| 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: | |
| Category: | Connector / J | Severity: | S3 (Non-critical) |
| Version: | 8.0.25 | OS: | Any |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[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".
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