The ancient timestamptz is sometimes incorrect with debezium-pg

[xuefengze]

when use debezium connector and AvroConverter, ancient timestamptz is incorrect sometimes.
see other configs in integration_tests/debezium-postgres.
steps:

1. create table in pg:

CREATE TABLE test_tz (
  id BIGINT PRIMARY KEY,
  c_timestamptz timestamptz
);

ALTER TABLE
  test_tz REPLICA IDENTITY FULL;

INSERT INTO test_tz VALUES (1, '1970-01-01 00:00:00Z');
INSERT INTO test_tz VALUES (2, '0001-01-01 00:00:00Z');

2. set debezium connect

curl -s -X PUT -H "Content-Type: application/json" http://localhost:8083/connectors/register-postgres/config \
  -d '{
    "connector.class": "io.debezium.connector.postgresql.PostgresConnector",
    "database.hostname": "postgres",
    "database.port": 5432,
    "database.user": "postgresuser",
    "database.password": "postgrespw",
    "database.dbname": "mydb",
    "database.server.name": "postgres",
    "database.schema": "public",
    "database.history.kafka.bootstrap.servers": "message_queue:29092",
    "database.history.kafka.topic": "postgres-history",
    "include.schema.changes": false
}'

3. create souce in risingwave:

CREATE TABLE test_tz (PRIMARY KEY(id)) with (
    connector = 'kafka',
    kafka.topic = 'postgres.public.test_tz',
    kafka.brokers = 'message_queue:29092',
    kafka.scan.startup.mode = 'earliest'
) FORMAT DEBEZIUM ENCODE AVRO (schema.registry = 'http://message_queue:8081');

4. insert data in pg:

INSERT INTO test_tz VALUES (3, '1970-01-01 00:00:00Z');
INSERT INTO test_tz VALUES (4, '0001-01-01 00:00:00Z');

now in risingwave:

dev=> select * from test_tz order by id;
 id |        c_timestamptz
----+-----------------------------
  1 | 1970-01-01T00:00:00.000000Z
  2 | 0000-12-30T00:00:00.000000Z
  3 | 1970-01-01T00:00:00.000000Z
  4 | 0001-01-01T00:00:00.000000Z
(4 rows)

also in kafka:

 "before": null,
  "after": {
      "id": 2,
      "c_timestamptz": "0000-12-30T00:00:00.000000Z"
  }

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.