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

Crash on an SP variable assignment to a wrong subselect

    XMLWordPrintable

    Details

      Description

      SET sql_mode='';
      DELIMITER $$
      BEGIN NOT ATOMIC
        DECLARE a INT;
        SET a=(SELECT 1 FROM DUAL UNION SELECT HIGH_PRIORITY 2 FROM DUAL);
      END;
      $$
      DELIMITER ;
      

      ERROR 2013 (HY000): Lost connection to MySQL server during query
      

      Note, 10.3 correctly returns the expected error without crashing:

      ERROR 1234 (42000): Incorrect usage/placement of 'HIGH_PRIORITY'
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: