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

cross engine joins between innob and columnstore between views throws Internal error: MCS-1000: 'view_on_CS_tables_and_InnoDB_tables' and 'InnoDB2' are not joined.

    XMLWordPrintable

Details

    Description

      To reproduce

      drop table if exists CS1;
      create table CS1
      ( 
      ID int,
      someText varchar(100),
      FK int
      ) 
      ENGINE=Columnstore;
       
      drop table if exists CS2;
      create table CS2
      ( 
      ID int,
      someText varchar(100)
      ) 
      ENGINE=Columnstore;
       
      drop table if exists InnoDB2;
      create table InnoDB2
      ( 
      ID int,
      someText varchar(100)
      ) 
      ENGINE=InnoDB;
       
      select CS1.ID, CS2.someText
      from CS1
      join CS2 on CS1.FK = CS2.ID;
       
      select CS1.ID, InnoDB2.someText
      from CS1
      join InnoDB2 on CS1.FK = InnoDB2.ID;
      -- works!!!
       
      drop view if exists view_on_CS_tables;
      create view view_on_CS_tables as 
      select CS1.ID, CS2.someText
      from CS1
      left outer join CS2 on CS1.FK = CS2.ID;
       
      select count(*) from view_on_CS_tables;
       
      drop view if exists view_on_CS_and_InnoDB_tables;
      create view view_on_CS_tables_and_InnoDB_tables as 
      select CS1.ID, InnoDB2.someText
      from CS1
      left outer join InnoDB2 on CS1.FK = InnoDB2.ID;
       
      select count(*) from view_on_CS_tables; -- works
       
      select count(*) from view_on_CS_tables_and_InnoDB_tables;
      -- Error Code: 1815. Internal error: IDB-1000: 'view_on_cs_tables_and_innodb_tables' and 'innodb2' are not joined.	
      

      Works with
      set columnstore_select_handler = 0;

      Attachments

        Activity

          People

            drrtuy Roman
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.