Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-851

Inconsistent behavior for invalid dates

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • Backlog
    • None
    • mysql-connector
    • None
    • Hide

      Example date : 1836-00-00

      1)Create a table having a date field.
      2)Create connectors with schema_only and initial_only modes.
      3)Observe that date value would be different in case of the invalid date.

      Show
      Example date : 1836-00-00 1)Create a table having a date field. 2)Create connectors with schema_only and initial_only modes. 3)Observe that date value would be different in case of the invalid date.

      MySQL connector sends different values for invalid dates in different modes.
      On schema_only mode, we get a null value for an invalid date, where as initial_only/when_needed mode sends an Integer .

      We would want the schema_only mode behavior to be in sync with initial_only/when_needed mode. Please let me know if further info is needed.

            Unassigned Unassigned
            pachirao7 Prashanth Rao (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: