mattcasters opened a new pull request, #8468: URL: https://github.com/apache/hop/pull/8468
Show database column definition in the Database perspective table and view information dialog, fixes #8464. ### Description When inspecting information for a table or view in the Database perspective, users can now see the underlying database column definition (e.g. `varchar(100)`, `bigint`, `int identity`, `bool`, `float`, `timestamp(6)`, `numeric(10, 2)`) in column 2, directly following the column name, with the Hop data type shown in column 3 labeled "Hop Type". Key improvements: - Added `getDefinition()` and `calculateDefinition(...)` on `DatabaseColumn` formatting database column definitions based on native type name, size, precision, and scale. - Handled parameterized types (`varchar`, `decimal`, `datetime2`, `timestamp`) while keeping unsized types (`uniqueidentifier`, `money`, `datetime`, `float`, `bigint`, etc.) clean without extraneous dimensions. - Correctly formats timestamp timezone clauses such as `TIMESTAMP(6) WITH LOCAL TIME ZONE`. - Handled catalog-first database explorers (e.g. MySQL) by passing catalog appropriately in `DatabaseTableInfoTab.loadColumnDefinitions`. - Escaped LIKE wildcards (`_`, `%`) when querying database column metadata with `getColumns`. - Added unit tests in `DatabaseColumnTest` and `DatabaseTableInfoTabTest`. ------------------------ - [x] Run `mvn clean install apache-rat:check` to make sure basic checks pass. A more thorough check will be performed on your pull request automatically. - [x] If you have a group of commits related to the same change, please squash your commits into one and force push your branch using `git rebase -i`. - [x] Mention the appropriate issue in your description (for example: `addresses #123`), if applicable. To make clear that you license your contribution under the [Apache License Version 2.0, January 2004](http://www.apache.org/licenses/LICENSE-2.0) you have to acknowledge this by using the following check-box. - [x] I hereby declare this contribution to be licensed under the [Apache License Version 2.0, January 2004](http://www.apache.org/licenses/LICENSE-2.0) - [ ] In any other case, please file an [Apache Individual Contributor License Agreement](https://www.apache.org/licenses/icla.pdf). -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
