drop table if exists t;
create table t(id int(11) unsigned not null auto_increment, dttm datetime not null default current_timestamp, msg text,primary key (id,dttm)) engine=innodb default charset=utf8mb4 row_format=dynamic partition by range columns(dttm) (partition pf_201612 values less than ('20170101') engine = innodb);
select * from t where dttm > '2017-01-19' order by id desc;
Crashes mysql for both debug and release builds. bugs.mysql. com/bug. php?id= 76418
Looks similar to http://
--source include/ have_innodb. inc
drop table if exists t;
create table t(id int(11) unsigned not null auto_increment, dttm datetime not null default current_timestamp, msg text,primary key (id,dttm)) engine=innodb default charset=utf8mb4 row_format=dynamic partition by range columns(dttm) (partition pf_201612 values less than ('20170101') engine = innodb);
select * from t where dttm > '2017-01-19' order by id desc;
Backtrace from release build: Partition_ helper: :handle_ ordered_ index_scan( unsigned char*)+ 0x5c)[0xbc18fc] handler: :ha_index_ last(unsigned char*)+ 0x208)[ 0x7f9c78] join_read_ last(QEP_ TAB*)+0x7c) [0xc2b8fc] sub_select( JOIN*, QEP_TAB*, bool)+0x11b) [0xc3222b] JOIN::exec( )+0x3b8) [0xc2ad18] handle_ query(THD* , LEX*, Query_result*, unsigned long long, unsigned long long)+0x238) [0xc9d498] mysql_execute_ command( THD*, bool)+0x3449) [0xc5d739] mysql_parse( THD*, Parser_ state*) +0x625) [0xc608d5] dispatch_ command( THD*, COM_DATA const*, enum_server_ command) +0x874) [0xc611c4] do_command( THD*)+0x1b7) [0xc627b7] handle_ connection+ 0x2a0)[ 0xd26960] pfs_spawn_ thread+ 0x1b4)[ 0xe9f284] 64-linux- gnu/libpthread. so.0(+0x8064) [0x7fa44bd28064 ] 64-linux- gnu/libc. so.6(clone+ 0x6d)[0x7fa449d 3062d]
mysqld(
mysqld(
mysqld(
mysqld(
mysqld(
mysqld(
mysqld[0x75f9dd]
mysqld(
mysqld(
mysqld(
mysqld(
mysqld(
mysqld(
/lib/x86_
/lib/x86_