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

Allow joins on all numeric data type pairs

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.6.1, 6.1.1
    • Fix Version/s: 6.3.1
    • Component/s: ExeMgr, PrimProc
    • Labels:
      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

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration