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

Derived table handlers leak after SHOW CREATE VIEW and listing of columns of the Columnstore table

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.4
    • 11.4
    • None
    • None

    Description

      A simple reproduction:

      use test;
      drop table if exists имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48;
      CREATE TABLE имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48
      (
                имя_поля_в_кодировке_утф8_длиной_больше_чем_45 INT
      )ENGINE=Columnstore;
       
      DROP VIEW IF EXISTS имя_вью_кодировке_утф8_длиной_больше_чем_42;
      CREATE VIEW имя_вью_кодировке_утф8_длиной_больше_чем_42 AS SELECT * FROM имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48;
      SHOW CREATE VIEW  имя_вью_кодировке_утф8_длиной_больше_чем_42;
       
      select COLUMN_NAME from information_schema.columns where table_schema='test' order by 1;
      

      Building Columnstore with ASAN reveals that SHOW CREATE VIEW leaks a derived table handler as does SELECT COLUMN_NAME.

      A fix for SHOW CREATE VIEW is sketched in MCOL-5791 (in function mysql_execute_command at finishing part: walk on first_table, delete dt_handler), but as SELECT COLUMN_NAME performs join, I was unable to pinpoint a good location of a fix.

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            sergey.zefirov Sergey Zefirov
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.