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

Assertion `is_last_prefix <= 0' failed in QUICK_GROUP_MIN_MAX_SELECT::get_next()

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
    • 10.4, 10.5, 10.6
    • Optimizer
    • None

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (a varchar(10) CHARACTER SET utf8mb4, key(a)) engine=innodb;
      INSERT INTO t1 VALUES (0xEFBFBF),(0xF0908080),(0xF48FBFBF);
      ALTER TABLE t1 MODIFY a varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
       
      SELECT count(DISTINCT a) FROM t1;
      

      10.4 49e3bd2cbcb12ed45908

      Version: '10.4.23-MariaDB-debug-log'
      mysqld: /10.4/sql/opt_range.cc:14994: virtual int QUICK_GROUP_MIN_MAX_SELECT::get_next(): Assertion `is_last_prefix <= 0' failed.
      220124 15:44:34 [ERROR] mysqld got signal 6 ;
       
       
      /lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7f9bc173f102]
      sql/opt_range.cc:14998(QUICK_GROUP_MIN_MAX_SELECT::get_next())[0x555f3caed9b2]
      sql/records.cc:369(rr_quick(READ_RECORD*))[0x555f3cb0f526]
      sql/records.h:70(READ_RECORD::read_record())[0x555f3bdc3c52]
      sql/sql_select.cc:21552(join_init_read_record(st_join_table*))[0x555f3c0b480e]
      sql/sql_select.cc:20600(sub_select(JOIN*, st_join_table*, bool))[0x555f3c0ada62]
      sql/sql_select.cc:20139(do_select(JOIN*, Procedure*))[0x555f3c0abc67]
      sql/sql_select.cc:4534(JOIN::exec_inner())[0x555f3c03bf1e]
      sql/sql_select.cc:4317(JOIN::exec())[0x555f3c03956a]
      sql/sql_select.cc:4757(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x555f3c03d5c9]
      sql/sql_select.cc:436(handle_select(THD*, LEX*, select_result*, unsigned long))[0x555f3c00ee98]
      sql/sql_parse.cc:6449(execute_sqlcom_select(THD*, TABLE_LIST*))[0x555f3bf80dd6]
      sql/sql_parse.cc:3963(mysql_execute_command(THD*))[0x555f3bf6e697]
      sql/sql_parse.cc:7995(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x555f3bf89f21]
      sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x555f3bf60d06]
      sql/sql_parse.cc:1373(do_command(THD*))[0x555f3bf5d777]
      sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x555f3c345f5d]
      sql/sql_connect.cc:1317(handle_one_connection)[0x555f3c3456ba]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x555f3cffd7ef]
      nptl/pthread_create.c:487(start_thread)[0x7f9bc1bfdfa3]
      x86_64/clone.S:97(clone)[0x7f9bc18084cf]
       
      Query (0x62b0000a1290): SELECT count(DISTINCT a) FROM t1
      

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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