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

Simple JOIN does not work properly with default configuration from columnstore rpms

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • None
    • Icebox
    • DMLProc
    • None

    Description

      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;

      MariaDB [test]> select fact.i1, fact_myisam.i1 from fact join fact_myisam using(seq) where fact.i1 != fact_myisam.i1;
      ERROR 1815 (HY000): Internal error: IDB-8001: CrossEngineSupport section in Calpont.xml is not properly configured.

      Attachments

        Activity

          People

            Unassigned Unassigned
            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.