[#MCOL-4755] Allow joins on all numeric data type pairs

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.

[MCOL-4755] Allow joins on all numeric data type pairs Created: 2021-06-10 Updated: 2023-10-06
Status:	Open
Project:	MariaDB ColumnStore
Component/s:	ExeMgr, PrimProc
Affects Version/s:	5.6.1, 6.1.1
Fix Version/s:	Icebox