|
--source include/have_binlog_format_row.inc
|
--source include/have_innodb.inc
|
--source include/master-slave.inc
|
|
--connection master
|
CREATE TABLE t1 (
|
id int NOT NULL,
|
f varchar(16),
|
s datetime NOT NULL,
|
e datetime NOT NULL,
|
PERIOD FOR p (s, e),
|
PRIMARY KEY (id,p WITHOUT OVERLAPS)
|
) ENGINE=InnoDB;
|
|
INSERT INTO t1 VALUES (1,NULL,'1973-05-16 00:00:00','1981-05-23 00:00:00'),(2,NULL,'1995-04-15 00:00:00','2012-10-02 00:00:00'),(3,NULL,'1994-02-03 00:00:00','2034-03-10 00:00:00');
|
|
UPDATE t1 FOR PORTION OF p FROM '1985-06-02' TO '2028-02-01' SET f=1;
|
|
--sync_slave_with_master
|
|
--connection master
|
drop table t1;
|
--source include/rpl_end.inc
|
|
10.5 c69520c9dfa6e4a26258842a1d35
|
mariadbd: /10.5/sql/handler.cc:7002: int handler::ha_check_overlaps(const uchar*, const uchar*): Assertion `inited != NONE' failed.
|
200731 10:31:05 [ERROR] mysqld got signal 6 ;
|
|
linux/raise.c:51(__GI_raise)[0x7fce7a6387bb]
|
stdlib/abort.c:81(__GI_abort)[0x7fce7a623535]
|
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7fce7a62340f]
|
??:0(__assert_fail)[0x7fce7a631102]
|
sql/handler.cc:7003(handler::ha_check_overlaps(unsigned char const*, unsigned char const*))[0x55807dc182ef]
|
sql/handler.cc:7176(handler::ha_update_row(unsigned char const*, unsigned char const*))[0x55807df7a1bd]
|
sql/log_event_server.cc:8344(Update_rows_log_event::do_exec_row(rpl_group_info*))[0x55807df64e90]
|
sql/log_event_server.cc:5669(Rows_log_event::do_apply_event(rpl_group_info*))[0x55807d1ba3d7]
|
sql/log_event.h:1496(Log_event::apply_event(rpl_group_info*))[0x55807d19c5c2]
|
sql/slave.cc:4003(apply_event_and_update_pos_apply(Log_event*, THD*, rpl_group_info*, int))[0x55807d19d09a]
|
sql/slave.cc:4165(apply_event_and_update_pos(Log_event*, THD*, rpl_group_info*))[0x55807d19e6fe]
|
sql/slave.cc:4482(exec_relay_log_event(THD*, Relay_log_info*, rpl_group_info*))[0x55807d1a607e]
|
sql/slave.cc:5659(handle_slave_sql)[0x55807e4e1886]
|
nptl/pthread_create.c:487(start_thread)[0x7fce7b0f3fa3]
|
x86_64/clone.S:97(clone)[0x7fce7a6fa4cf]
|
|
Query (0x6120000a465b): UPDATE t1 FOR PORTION OF p FROM '1985-06-02' TO '2028-02-01' SET f=1
|
|