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

crash in st_key::actual_rec_per_key when group by constant

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.1.6, 10.1.11, 10.2.0, 10.1
    • 10.1.14
    • Optimizer
    • None

    Description

      Version: '10.1.11-MariaDB'  mariadb.org binary distribution
      [ERROR] mysqld got exception 0xc0000005 ;
      mysqld.exe!st_key::actual_rec_per_key()[table.cc:7416]
      mysqld.exe!cost_group_min_max()[opt_range.cc:13114]
      mysqld.exe!get_best_group_min_max()[opt_range.cc:12478]
      mysqld.exe!SQL_SELECT::test_quick_select()[opt_range.cc:2562]
      mysqld.exe!get_quick_record_count()[sql_select.cc:3490]
      mysqld.exe!make_join_statistics()[sql_select.cc:4108]
      mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1375]
      mysqld.exe!JOIN::optimize()[sql_select.cc:1036]
      mysqld.exe!mysql_select()[sql_select.cc:3437]
      mysqld.exe!handle_select()[sql_select.cc:384]
      mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5903]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:2962]
      mysqld.exe!mysql_parse()[sql_parse.cc:7308]
      mysqld.exe!dispatch_command()[sql_parse.cc:1491]
      mysqld.exe!do_command()[sql_parse.cc:1109]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:239]
      mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

      How to repeat
      ---------------

      drop table if exists t;
      create table t (a date not null,unique (a)) engine=innodb;
      select distinct a from t group by 'a';

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              sbester1 sbester1
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.