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

Assertion `!for_explain_only' or crash in JOIN_CACHE::write_record_data

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4, 10.5, 10.6, 10.11, 11.0
    • 10.4, 10.5, 10.6, 10.11
    • Optimizer
    • None

    Description

      MDEV-21102 not fully fixed, as it seems.

      Reproducible, needs cleaning

      CREATE TABLE t2 LIKE mysql.help_category;
      INSERT INTO t2 SELECT * FROM mysql.help_category LIMIT 40;
       
      CREATE TABLE table8_aria_int_autoinc (pk integer auto_increment,
      col_varchar_10_utf8_key varchar(10) CHARACTER SET utf8,
      primary key (pk DESC),
      key (col_varchar_10_utf8_key DESC));
       
      EXPLAIN FORMAT=JSON DELETE FROM table8_aria_int_autoinc WHERE NOT EXISTS (SELECT tbl1.COMMENT AS fld1 FROM information_schema.ENGINES AS tbl1 RIGHT JOIN t2 AS tbl2 ON (tbl1.TRANSACTIONS >= tbl2.help_category_id AND tbl2.parent_category_id <= 'm'));
      

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.