Comment 3 for bug 1657941

Revision history for this message
Nickolay Ihalainen (ihanick) wrote :

Crashes mysql for both debug and release builds.
Looks similar to http://bugs.mysql.com/bug.php?id=76418

--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:
mysqld(Partition_helper::handle_ordered_index_scan(unsigned char*)+0x5c)[0xbc18fc]
mysqld(handler::ha_index_last(unsigned char*)+0x208)[0x7f9c78]
mysqld(join_read_last(QEP_TAB*)+0x7c)[0xc2b8fc]
mysqld(sub_select(JOIN*, QEP_TAB*, bool)+0x11b)[0xc3222b]
mysqld(JOIN::exec()+0x3b8)[0xc2ad18]
mysqld(handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long)+0x238)[0xc9d498]
mysqld[0x75f9dd]
mysqld(mysql_execute_command(THD*, bool)+0x3449)[0xc5d739]
mysqld(mysql_parse(THD*, Parser_state*)+0x625)[0xc608d5]
mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x874)[0xc611c4]
mysqld(do_command(THD*)+0x1b7)[0xc627b7]
mysqld(handle_connection+0x2a0)[0xd26960]
mysqld(pfs_spawn_thread+0x1b4)[0xe9f284]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7fa44bd28064]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fa449d3062d]