[MCOL-917] Issue with "IDB-1002 incompatible column type specified for join condition" error Created: 2017-09-13  Updated: 2017-09-13  Resolved: 2017-09-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.1.0
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MCOL-695 Implement joins between CHAR/VARCHAR ... Closed

 Description   

Build tested: 1.1.0-1

Columnstore returns an error while MariaDB returned results.

How to reproduce:

In InnoDB (InnoDB engine in 1.1.0-1):

create table t1 (cidx int, cchar8 char(8), cint int) engine innodb;
create table t2 (cidx int, cchar8 char(8), cint int) engine innodb;
insert into t1 values (1,'1',1);
insert into t1 values (2,'2',2);
insert into t2 values (1,'1',1);
insert into t2 values (2,'2',2);

MariaDB [d2]> select * from t1, t2 where t1.cidx = t2.cidx and t1.cchar8 = t2.cint;
------------------------------+

cidx cchar8 cint cidx cchar8 cint

------------------------------+

1 1 1 1 1 1
2 2 2 2 2 2

------------------------------+
2 rows in set (0.00 sec)

insert two more rows with characters for the cchar8 column:

insert into t1 values (3,'hello',3);
insert into t1 values (4,'world',4);
insert into t2 values (3,'hello',3);
insert into t2 values (4,'world',4);

MariaDB [d2]> select * from t1, t2 where t1.cidx = t2.cidx and t1.cchar8 = t2.cint;
------------------------------+

cidx cchar8 cint cidx cchar8 cint

------------------------------+

1 1 1 1 1 1
2 2 2 2 2 2

------------------------------+
2 rows in set, 2 warnings (0.00 sec)

MariaDB [d2]> show warnings;
---------------------------------------------------------

Level Code Message

---------------------------------------------------------

Note 1051 Unknown table 'infinidb_vtable.$vtable_1313'
Warning 1292 Truncated incorrect DOUBLE value: 'hello '
Warning 1292 Truncated incorrect DOUBLE value: 'world '

---------------------------------------------------------
3 rows in set (0.00 sec)

  • Not sure what the first warning is. InnoDB should not use vtable

The same test in columnstore

MariaDB [d1]> select * from t1, t2 where t1.cidx = t2.cidx and t1.cchar8 = t2.cint;
ERROR 1815 (HY000): Internal error: IDB-1002: 't1' and 't2' have incompatible column type specified for join condition.

 Comments   
Comment by David Thompson (Inactive) [ 2017-09-13 ]

Tracking in MCOL-695

Generated at Thu Feb 08 02:24:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.