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

NUMERIC column without scale value causes exception

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • 0.8.0.Beta1
    • None
    • mysql-connector
    • None

      A column definition without scale causes a scale mismatch exception:

      myNum NUMERIC not null default 42
      
      BigDecimal has mismatching scale value for given Decimal schema
      

            [DBZ-727] NUMERIC column without scale value causes exception

            Released

            Jiri Pechanec added a comment - Released

            Hmm, I can rperoduce the issue with NUMERIC datatype but not DECIMAL but technically those type should be the same for MySQL.

            Jiri Pechanec added a comment - Hmm, I can rperoduce the issue with NUMERIC datatype but not DECIMAL but technically those type should be the same for MySQL.

            jpechane I think we definitely should get this into 0.8. I first thought it'd be a regression of the default value work (DBZ-191), but it seems to be like that for quite a while (0.6 is the earliest I checked). Also weird that we don't seem to have a test for that.

            Gunnar Morling added a comment - jpechane I think we definitely should get this into 0.8. I first thought it'd be a regression of the default value work ( DBZ-191 ), but it seems to be like that for quite a while (0.6 is the earliest I checked). Also weird that we don't seem to have a test for that.

              Unassigned Unassigned
              gunnar.morling Gunnar Morling
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: