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

Default value for Bit does not work for larger values

    Details

      Description

      When an octet in BIT default value has the most significant bit set to 1 then conversion of defaut value fails. An example is

       CREATE TABLE user_subscribe (
      id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      uid char(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户ID',
      type tinyint(4) NOT NULL DEFAULT '0' COMMENT '-1自选股,-3关键词,-21自由组合,-22行业组合,-23概念组合,-4分析师,-5研究号',
      content bit(8) DEFAULT b'11111111' COMMENT '5个标志位,保留3个(沪深、港股、美股、基金、债券,)',
      PRIMARY KEY (id),
      KEY uid_type (uid,type)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='订阅分组表';
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jpechanec Jiri Pechanec
                Reporter:
                jpechanec Jiri Pechanec
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: