zhangsean opened a new pull request, #12153:
URL: https://github.com/apache/seatunnel/pull/12153
### Purpose of this pull request
This pull request preserves MySQL native index metadata when reading tables
through the JDBC catalog and uses it while generating MySQL `CREATE TABLE` SQL.
A source `FULLTEXT` index on a long `VARCHAR` column is now recreated as
`FULLTEXT KEY` instead of being downgraded to a normal B-tree `KEY`, and MySQL
prefix index lengths from `SUB_PART` are preserved when available.
### Does this PR introduce _any_ user-facing change?
Yes. When JDBC sink auto-creates a MySQL table from MySQL catalog metadata
with `create_index = true`, MySQL `FULLTEXT` indexes are generated as `FULLTEXT
KEY`, and prefix index lengths are retained. This avoids failures such as
`Specified key was too long; max key length is 3072 bytes` when a long
`VARCHAR` source column had a valid fulltext index.
### How was this patch tested?
Added
`MysqlCreateTableSqlBuilderTest#testBuildCreateTableSqlWithMysqlFulltextAndPrefixIndexes`
to verify that MySQL fulltext and prefix index metadata is rendered in the
generated DDL.
Local verification:
- `git diff --check apache/dev...HEAD` passed.
- `mvn -pl seatunnel-connectors-v2/connector-jdbc -DskipITs
-Dtest=MysqlCreateTableSqlBuilderTest test` was attempted locally but did not
complete before a 10-minute timeout in this environment.
### Check list
* [ ] If any new Jar binary package adding in your PR, please add License
Notice according
[New License
Guide](https://github.com/apache/seatunnel/blob/dev/docs/en/developer/new-license.md)
* [ ] If necessary, please update the documentation to describe the new
feature. https://github.com/apache/seatunnel/tree/dev/docs
* [ ] If necessary, please update `incompatible-changes.md` to describe the
incompatibility caused by this PR.
* [ ] If you are contributing the connector code, please check that the
following files are updated:
1. Update
[plugin-mapping.properties](https://github.com/apache/seatunnel/blob/dev/plugin-mapping.properties)
and add new connector information in it
2. Update the pom file of
[seatunnel-dist](https://github.com/apache/seatunnel/blob/dev/seatunnel-dist/pom.xml)
3. Add ci label in
[label-scope-conf](https://github.com/apache/seatunnel/blob/dev/.github/workflows/labeler/label-scope-conf.yml)
4. Add e2e testcase in
[seatunnel-e2e](https://github.com/apache/seatunnel/tree/dev/seatunnel-e2e/seatunnel-connector-v2-e2e/)
5. Update connector
[plugin_config](https://github.com/apache/seatunnel/blob/dev/config/plugin_config)
--
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]
