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

Server crash on query

    XMLWordPrintable

    Details

      Description

      I've just upgraded from 10.4 to 10.5 and now some queries results in a server crash.
      The issue can be reproduced by creating this simple table and make a query on it. It doesn't matter if the table is empty or not.

      CREATE TABLE `test` (
      	`a` BIGINT(20) NOT NULL,
      	`b` BIGINT(20) NOT NULL,
      	`c` BIGINT(20) NOT NULL,
      	PRIMARY KEY (`a`, `b`, `c`) USING BTREE,
      	INDEX `KEY_2` (`b`) USING BTREE
      ) ENGINE=InnoDB;
      

      Then running this query produce the crash:

      SELECT count(*) FROM test
      WHERE c = 1
      AND a IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,
                31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,
      			 58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90)
      AND b IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,
                31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,
      			 58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90);
      

      I've found out, that it is important how many values are in the lists. Less number seems to work.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              psergei Sergei Petrunia
              Reporter:
              csiebert Carsten Siebert
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.