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

Add DEFAULT to partition option engine

XMLWordPrintable

      Ignoring unparseable DDL statement 'CREATE TABLE positions_rollover (
      id bigint(20) NOT NULL AUTO_INCREMENT,
      time datetime NOT NULL,
      position_uid binary(36) NOT NULL,
      rolled_instrument_id int(11) DEFAULT NULL,
      position_human_id bigint(20) DEFAULT NULL,
      account_id bigint(20) DEFAULT NULL,
      quantity decimal(15,4) DEFAULT NULL,
      price_avg decimal(20,8) DEFAULT NULL,
      instrument_id int(11) DEFAULT NULL,
      ppl_adjustment decimal(20,8) DEFAULT NULL,
      from_price decimal(20,8) DEFAULT NULL,
      to_price decimal(20,8) DEFAULT NULL,
      partition_index int(10) unsigned NOT NULL DEFAULT 0,
      PRIMARY KEY (id,partition_index),
      KEY time (time),
      KEY rolled_instrument_id (rolled_instrument_id),
      KEY positions_rollover_opened_position_fk (position_uid),
      KEY positions_rollover_instrument_fk1 (instrument_id)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      PARTITION BY LIST (partition_index)
      (PARTITION positions_rollover_partition VALUES IN (0) ENGINE = InnoDB,
      PARTITION positions_rollover_partition1 VALUES IN (1) ENGINE = InnoDB,
      PARTITION positions_rollover_partition2 VALUES IN (2) ENGINE = InnoDB,
      PARTITION positions_rollover_partition3 VALUES IN (3) ENGINE = InnoDB,
      PARTITION positions_rollover_partition4 VALUES IN (4) ENGINE = InnoDB,
      PARTITION positions_rollover_partition5 VALUES IN (5) ENGINE = InnoDB,
      PARTITION positions_rollover_partition6 VALUES IN (6) ENGINE = InnoDB,
      PARTITION positions_rollover_partition7 VALUES IN (7) ENGINE = InnoDB,
      PARTITION positions_rollover_partition8 VALUES IN (8) ENGINE = InnoDB,
      PARTITION positions_rollover_partition9 VALUES IN (9) ENGINE = InnoDB,
      PARTITION default_positions_rollover_partition DEFAULT ENGINE = InnoDB)': {};

       

       

            anmohant Anisha Mohanty
            yordan.stoichkov95 Yordan Stroichkov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: