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

server crashed by long WHERE IN

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3.10
    • Fix Version/s: 10.3.11
    • Component/s: N/A
    • Labels:
      None
    • Environment:
      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
        2. mysqld.log
          142 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              jirka Jiri Reischig
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: