Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4959

Delete IN (select id from columnstoreTable) not working

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 5.5.2
    • Fix Version/s: 22.08
    • Component/s: ExeMgr
    • Labels:
    • Environment:
      MariaDB 10.5.10
      NAME="Red Hat Enterprise Linux"
      VERSION="8.2 (Ootpa)"

      Description

      drop table if exists deleteTestInnoDB;
      create table if not exists deleteTestInnoDB (
      report_id int
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
      insert into deleteTestInnoDB values (0),(1),(2),(3);
      select * from deleteTestInnoDB;

      drop table if exists deleteTestInnoDB2;
      create table if not exists deleteTestInnoDB2 (
      report_id int
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
      insert into deleteTestInnoDB2 values (1),(2),(3),(4);
      select * from deleteTestInnoDB2;

      drop table if exists deleteTestColumnstore;
      create table if not exists deleteTestColumnstore (
      report_id int
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8mb4;
      insert into deleteTestColumnstore values (1),(2),(3),(4);
      select * from deleteTestColumnstore;

      delete from deleteTestInnoDB where report_id in (select report_id from deleteTestColumnstore); – nothing is deleted!!! (In ETL: connection to ExeMgr was lost.)

      delete from deleteTestInnoDB where report_id in (select report_id from deleteTestInnoDB2); – works
      delete from deleteTestInnoDB where report_id in (1,2,3,4); – works
      delete from deleteTestColumnstore where report_id in (select report_id from deleteTestInnoDB); – works

        Attachments

          Activity

            People

            Assignee:
            drrtuy Roman
            Reporter:
            aeae81 andreas eschbacher
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.