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

Document MySQL boolean handling

    XMLWordPrintable

Details

    Description

      MySQL represents boolean as TINYINT(1) when DDL is obtained from snapshot but as boolean when obtaine from binlog, see DBZ-1074.

      We should document this behaviour and also document JDBC driver options
      tinyInt1isBit and transformedBitIsBoolean and discuss tradeoffs using them to bypass the problem.

      Attachments

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-1773 TINYINT(1) value range restricted on snapshot.

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              jpechane Jiri Pechanec
              jpechane Jiri Pechanec
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: