CREATE TABLE IF NOT EXISTS `planning` (
`idsalarie` INT(10) UNSIGNED NOT NULL,
`nom` VARCHAR(255) NULL DEFAULT NULL,
`absence` TINYINT(4) NULL DEFAULT 0,
`couleur` CHAR(7) NULL DEFAULT NULL,
`date` DATE NULL DEFAULT NULL,
`heuredebut` TIME NULL DEFAULT NULL,
`heurefin` TIME NULL DEFAULT NULL,
`pause` TINYINT(4) NULL DEFAULT 0,
`pausedebut` TIME NULL DEFAULT NULL,
`pausefin` TIME NULL DEFAULT NULL,
INDEX `FK_PLANNING_SALARIE_idx` (`idsalarie` ASC),
INDEX `INDEX_PLANNING_DATE` (`date` ASC),
CONSTRAINT `FK_PLANNING_SALARIE`
FOREIGN KEY (`idsalarie`)
REFERENCES `rhonline`.`salarie` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8

the followwing request crash the server, if the between statement is deleted it works fine as if the multiple order by are deleted. This request works fine on the 10.3.x releases

SELECT
*
FROM
planning
WHERE
idsalarie = 1
AND `date` BETWEEN '2019-10-21' AND '2019-10-27'
ORDER BY
`date`,
heuredebut,
nom

Thread pointer: 0x2b87a889f48
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
mysqld.exe!handler_index_cond_check()[handler.cc:5973]
mysqld.exe!row_search_idx_cond_check()[row0sel.cc:3939]
mysqld.exe!row_search_mvcc()[row0sel.cc:5257]
mysqld.exe!ha_innobase::index_read()[ha_innodb.cc:9308]
mysqld.exe!ha_innobase::rnd_pos()[ha_innodb.cc:9814]
mysqld.exe!handler::ha_rnd_pos()[handler.cc:2858]
mysqld.exe!rr_from_pointers()[records.cc:543]
mysqld.exe!sub_select()[sql_select.cc:20154]
mysqld.exe!do_select()[sql_select.cc:19695]
mysqld.exe!JOIN::exec_inner()[sql_select.cc:4391]
mysqld.exe!JOIN::exec()[sql_select.cc:4174]
mysqld.exe!mysql_select()[sql_select.cc:4607]
mysqld.exe!handle_select()[sql_select.cc:413]
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6357]
mysqld.exe!mysql_execute_command()[sql_parse.cc:3899]
mysqld.exe!mysql_parse()[sql_parse.cc:7914]
mysqld.exe!dispatch_command()[sql_parse.cc:1845]
mysqld.exe!do_command()[sql_parse.cc:1359]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:366]
mysqld.exe!tp_callback()[threadpool_common.cc:193]