Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.4.8
-
windows
Description
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]
Attachments
Issue Links
- is duplicated by
-
MDEV-20252 Specific SQL query consistently crashes MariaDB
- Closed