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

Memory leakage is detected on running the test main.ps against the server 11.1

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (id INT, value INT);
      CREATE TABLE t2 (id INT);
       
      PREPARE stmt FROM 'UPDATE t1 t1 SET value = (SELECT 1 FROM t2 WHERE id = t1.id)';
      execute stmt;
      insert into t1 values (1,10),(2,10),(3,10);
      insert into t2 values (1),(2);
      execute stmt;  # <<=== Memory leak happens on running this statement
      select * from t1;
      deallocate prepare stmt;
      DROP TABLE t1,t2;
      

      The above use case doesn't show memory leaking on 10.11.

      The similar issue could take place on running the DELETE statement with the LIMIT clause in PS/SP mode. So, this task also about fixing a memory leak in the code that processes the DELETE statement.

      Attachments

        Issue Links

          Activity

            People

              shulga Dmitry Shulga
              shulga Dmitry Shulga
              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.