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

Properly configured <CrossEngineSupport> in Calpont.xml still results in error on cross engine join

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • Icebox
    • Documentation
    • None

    Description

      <CrossEngineSupport>
      <Host>192.168.1.144</Host>
      <Port>3306</Port>
      <User>root</User>
      <Password/>
      </CrossEngineSupport>

      MariaDB [test]> select fact.i1, fact_myisam.i1 from fact join fact_myisam on fact.seq = fact_myisam.seq where fact.i1 != fact_myisam.i1;
      ERROR 1815 (HY000): Internal error: IDB-2034: At least one DBRoot required for that query is offline.

      CREATE TABLE `fact` (
      `seq` bigint(20) DEFAULT NULL,
      `i1` tinyint(4) DEFAULT NULL,
      `i2` smallint(6) DEFAULT NULL,
      `i4` int(11) DEFAULT NULL,
      `i8` bigint(20) DEFAULT NULL,
      `i1u` tinyint(3) unsigned DEFAULT NULL,
      `i2u` smallint(5) unsigned DEFAULT NULL,
      `i4u` int(10) unsigned DEFAULT NULL,
      `i8u` bigint(20) unsigned DEFAULT NULL,
      `d5` decimal(15,5) DEFAULT NULL,
      `f1` float DEFAULT NULL,
      `f2` float(2,1) DEFAULT NULL,
      `f23` float(23,4) DEFAULT NULL,
      `f24` float(24,10) DEFAULT NULL,
      `f53` float(53,20) DEFAULT NULL,
      `p1` double DEFAULT NULL,
      `p2` double(2,1) DEFAULT NULL,
      `p23` double(23,4) DEFAULT NULL,
      `p24` double(24,10) DEFAULT NULL,
      `p53` double(53,20) DEFAULT NULL,
      `r1` double DEFAULT NULL,
      `d` date DEFAULT NULL,
      `dt` datetime DEFAULT NULL,
      `c1` char(1) DEFAULT NULL,
      `c2` char(255) DEFAULT NULL,
      `vc1` varchar(1) DEFAULT NULL,
      `vc2` varchar(255) DEFAULT NULL
      ) ENGINE=Columnstore DEFAULT CHARSET=latin1;

      CREATE TABLE `fact_myisam` (
      `seq` bigint(20) DEFAULT NULL,
      `i1` tinyint(4) DEFAULT NULL,
      `i2` smallint(6) DEFAULT NULL,
      `i4` int(11) DEFAULT NULL,
      `i8` bigint(20) DEFAULT NULL,
      `i1u` tinyint(3) unsigned DEFAULT NULL,
      `i2u` smallint(5) unsigned DEFAULT NULL,
      `i4u` int(10) unsigned DEFAULT NULL,
      `i8u` bigint(20) unsigned DEFAULT NULL,
      `d5` decimal(15,5) DEFAULT NULL,
      `f1` float DEFAULT NULL,
      `f2` float(2,1) DEFAULT NULL,
      `f23` float(23,4) DEFAULT NULL,
      `f24` float(24,10) DEFAULT NULL,
      `f53` float(53,20) DEFAULT NULL,
      `p1` double DEFAULT NULL,
      `p2` double(2,1) DEFAULT NULL,
      `p23` double(23,4) DEFAULT NULL,
      `p24` double(24,10) DEFAULT NULL,
      `p53` double(53,20) DEFAULT NULL,
      `r1` double DEFAULT NULL,
      `d` date DEFAULT NULL,
      `dt` datetime DEFAULT NULL,
      `c1` char(1) DEFAULT NULL,
      `c2` char(255) DEFAULT NULL,
      `vc1` varchar(1) DEFAULT NULL,
      `vc2` varchar(255) DEFAULT NULL
      ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

      Attachments

        Activity

          People

            dthompson David Thompson (Inactive)
            jswanhart Justin Swanhart (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.