Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20873

date between and multiple order by crash server

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.4.8
    • N/A
    • Optimizer
    • 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

          Activity

            People

              elenst Elena Stepanova
              iceuponfire jeantet guillaume
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.