lazyfetch opened a new pull request, #11069:
URL: https://github.com/apache/seatunnel/pull/11069
### Purpose of this pull request
Resolves #11005
**Bug:**
When using the Postgres-CDC connector to sync a table containing a
`TIMESTAMP WITH TIME ZONE` (`TIMESTAMPTZ`) column, SeaTunnel throws an
`UnsupportedOperationException: Unsupported type: TIMESTAMP_TZ` during source
initialization. This occurs because
`SeaTunnelRowDebeziumDeserializationConverters#createNotNullConverter` lacks a
branch to handle `TIMESTAMP_TZ`.
**Fix:**
* Added the `SqlType.TIMESTAMP_TZ` mapping case to `createNotNullConverter`.
* Implemented `convertToTimestampTz()` to correctly parse the ISO-8601
string natively emitted by Debezium into a Java `OffsetDateTime`.
### Does this PR introduce _any_ user-facing change?
Yes.
**Previous Behavior:** Syncing a PostgreSQL table with a `TIMESTAMPTZ`
column would result in an immediate job crash (`UnsupportedOperationException`).
**New Behavior:** `TIMESTAMPTZ` columns are successfully parsed and synced
as `OffsetDateTime` types without throwing errors. No new `.conf` configuration
changes are required by the user.
### How was this patch tested?
* **Unit Tests Added:** Added `testTimestampTzConversion` to
`SeaTunnelRowDebeziumDeserializationConvertersTest.java` to explicitly mock the
Debezium string emission for `TIMESTAMPTZ` and verify it correctly parses into
a Java `OffsetDateTime`.
* **Local Verification:** Compiled and tested locally using `mvn clean
install` to ensure no compilation issues or regressions in the data type
formatting suite.
### 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]
