Skip to content

Source Postgres (CDC): debezium does not handle era indicators (AD | BC) for 'DATE' type #14590

Description

Current Behavior

Source-postgres in cdc mode omits era indicator. For example, the values 1991-02-10 BC and 1991-02-10 have the same output

Expected Behavior

Dates with the current era (AD) and before the current era (BC) should have different outputs and era indicators should not be omitted

Logs

Steps to Reproduce

  1. Insert 2 date rows to Postgres table with the same value but different eras (e.g 1991-02-10 BC, 1991-02-10)
  2. Run sync or datatype test
  3. The output values are the same

Activity

  1. grishick commented on Jul 19, 2022

    @grishick
    Contributor

    This will be fixed in #14628

  2. edgao commented on Aug 3, 2022

    @edgao
    Contributor

    implemented in #15187 - will be published as part of #14534

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions