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

server crashed by long WHERE IN

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.3.10
    • 10.3.11
    • N/A
    • None
    • CentOS 7

    Description

      Server crash after execute simple but long WHERE IN query - crash.sql.

      I tested it on the test database:

      CREATE TABLE `test` (
      `text` varchar(30) CHARACTER SET cp1250 COLLATE cp1250_czech_cs DEFAULT NULL,
      `id` varbinary(16) NOT NULL
      ) ENGINE=MyISAM DEFAULT CHARSET=binary;
      ALTER TABLE `test`
      ADD UNIQUE KEY `id` (`id`);

      with some test data:

      INSERT INTO `test` (`text`, `id`) VALUES
      ('332969.613019', 0x3131),
      ('332967.579999.580003', 0x3132),
      ('332967.579999.580002', 0x3133),
      ('332967.580000', 0x3134),
      ('332967.579999', 0x3135),
      ('abe', 0x3535),
      ('aaa', 0x33),
      ('zku', 0x3333),
      ('dddd', 0x3432343234),
      ('churu', 0x33353235),
      ('czrt', 0x333235);

      After query I have got server crash - mysqld.log.

      Attachments

        1. crash.sql
          379 kB
          Jiri Reischig
        2. mysqld.log
          142 kB
          Jiri Reischig

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jirka Jiri Reischig
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.