#--source include/have_innodb.inc
--source include/have_debug.inc
--source include/have_debug_sync.inc

create table t1(f1 int) engine=innodb;
insert into t1 values(1);
insert into t1 values(2);

CREATE TABLE `t2` (
  `id` bigint(20) NOT NULL,
  `p` json NOT NULL,
  `m` tinyint(2) NOT NULL,
  `ho` char(64) COLLATE utf8_bin GENERATED ALWAYS AS (json_unquote(json_extract(`p`,'$.ho'))) VIRTUAL,
  `hr` char(64) COLLATE utf8_bin GENERATED ALWAYS AS (json_unquote(json_extract(`p`,'$.hr'))) VIRTUAL,
  PRIMARY KEY (`id`,`m`),
  KEY `originator_idx` (`ho`(16)),
  KEY `recipient_idx` (`hr`(16))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
PARTITION BY RANGE (`m`)
(PARTITION p1 VALUES LESS THAN (2) ENGINE = InnoDB,
 PARTITION p2 VALUES LESS THAN (3) ENGINE = InnoDB,
 PARTITION p3 VALUES LESS THAN (4) ENGINE = InnoDB,
 PARTITION p4 VALUES LESS THAN (5) ENGINE = InnoDB,
 PARTITION p5 VALUES LESS THAN (6) ENGINE = InnoDB,
 PARTITION p6 VALUES LESS THAN (7) ENGINE = InnoDB,
 PARTITION p7 VALUES LESS THAN (8) ENGINE = InnoDB,
 PARTITION p8 VALUES LESS THAN (9) ENGINE = InnoDB,
 PARTITION p9 VALUES LESS THAN (10) ENGINE = InnoDB,
 PARTITION p10 VALUES LESS THAN (11) ENGINE = InnoDB,
 PARTITION p11 VALUES LESS THAN (12) ENGINE = InnoDB,
 PARTITION p12 VALUES LESS THAN (13) ENGINE = InnoDB);

set debug="d,bug94610";
--send alter table t2 truncate partition p3

--connect(con1,localhost,root,,test)
--connection con1
--sleep 5
select now();
insert into t1 values(3);
select now();

--connection default
--reap
set debug='';

drop table t1, t2;