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

crash in get_sel_arg_for_keypart

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.2.1
    • N/A
    • Optimizer
    • None
    • mariadb-10.2.1-winx64

    Description

      Version: '10.2.1-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
      [ERROR] mysqld got exception 0xc0000005 ;
       
      mysqld.exe!get_sel_arg_for_keypart()[opt_range.cc:12842]
      mysqld.exe!get_constant_key_infix()[opt_range.cc:12935]
      mysqld.exe!get_best_group_min_max()[opt_range.cc:12411]
      mysqld.exe!SQL_SELECT::test_quick_select()[opt_range.cc:2575]
      mysqld.exe!test_if_skip_sort_order()[sql_select.cc:21126]
      mysqld.exe!JOIN::optimize_inner()[sql_select.cc:2012]
      mysqld.exe!JOIN::optimize()[sql_select.cc:1069]
      mysqld.exe!mysql_select()[sql_select.cc:3523]
      mysqld.exe!handle_select()[sql_select.cc:377]
      mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6309]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:3352]
      mysqld.exe!mysql_parse()[sql_parse.cc:7746]
      mysqld.exe!dispatch_command()[sql_parse.cc:1793]
      mysqld.exe!do_command()[sql_parse.cc:1353]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:252]
      mysqld.exe!io_completion_callback()[threadpool_win.cc:462]
      

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

      drop table if exists t;
      create table t(a int,b int,c date,d int,
        primary key (c,a,b),
        unique key (c,d)
      ) engine=innodb;
      select distinct c from t where c;
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sbester1 sbester1
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.