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

Allow joins on all numeric data type pairs

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.6.1, 6.1.1
    • Icebox
    • ExeMgr, PrimProc
    • None

    Description

      ColumnStore does not support all possible numeric data type pairs in JOINs. For example:

      SET default_storage_engine=ColumnStore;
      		 
      DROP TABLE IF EXISTS t1,t2;
      		 
      CREATE TABLE t1 (a FLOAT);
      		 
      INSERT INTO t1 VALUES (1);
      		 
      CREATE TABLE t2 (a TINYINT);
      		 
      INSERT INTO t2 VALUES (1);
      		 
      SELECT * FROM t1,t2 WHERE t1.a=t2.a;


      ERROR 1815 (HY000): Internal error: IDB-1002: 't1' and 't2' have incompatible column type specified for join condition.

      Here's the full table:

                     TINYINT   SMALLINT   MEDIUMINT  INT       BIGINT    DECIMAL(10,0) DECIMAL(10,1) FLOAT DOUBLE
      		 
      TINYINT        OK        OK         OK         OK        OK        OK            IDB-1002      IDB-1002
      		 
      SMALLINT       OK        OK         OK         OK        OK        OK            IDB-1002      IDB-1002
      		 
      MEDIUMINT      OK        OK         OK         OK        OK        OK            IDB-1002      IDB-1002
      		 
      INT            OK        OK         OK         OK        OK        OK            IDB-1002      IDB-1002
      		 
      BIGINT         OK        OK         OK         OK        OK        OK            IDB-1002      IDB-1002
      		 
      DECIMAL(10,0)  OK        OK         OK         OK        OK        OK            IDB-1002      IDB-1002
      		 
      DECIMAL(10,1)  IDB-1002  IDB-1002   IDB-1002   IDB-1002  IDB-1002  IDB-1002      OK            OK
      		 
      FLOAT          IDB-1002  IDB-1002   IDB-1002   IDB-1002  IDB-1002  IDB-1002      IDB-1002      IDB-1002
      		 
      DOUBLE         IDB-1002  IDB-1002   IDB-1002   IDB-1002  IDB-1002  IDB-1002      IDB-1002      IDB-1002

      Under terms of this task will allow all combinations that currently return IDB-1002.

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4627 SET int_col=decimal_col returns an error

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4628 SET double_col=decimal_col returns an error

          • Major - Major loss of function.
          • Open
          relates to

          Task - A task that needs to be done. MCOL-4173 Support JOINs wide-DECIMAL keys.

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MCOL-4753 Performance problem in Typeless join

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.