[MCOL-5056] Cross-Engine join at text type not supported Created: 2022-04-18  Updated: 2024-02-05

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 6.2.3
Fix Version/s: Icebox

Type: Bug Priority: Critical
Reporter: suresh ramagiri Assignee: Leonid Fedorov
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Observed that, cross-engine joins on text column is not supported.
Can we fix this?

MariaDB [suresh]> create table foo5 (a text );
Query OK, 0 rows affected (0.006 sec)
MariaDB [suresh]> create table bar5 (a text ) engine=columnstore;
Query OK, 0 rows affected (0.220 sec)
MariaDB [suresh]> select * from foo5 where exists ( select 1 from bar5 where foo5.a=bar5.a);
ERROR 1815 (HY000): Internal error: VARBINARY/BLOB in join is not supported.
MariaDB [suresh]> select * from foo5, bar5 where foo5.a=bar5.a;
ERROR 1815 (HY000): Internal error: VARBINARY/BLOB in join is not supported.

[root@test001 ~]# rpm -qa|grep -i column
MariaDB-columnstore-engine-10.6.7_3_6.2.3-1.el7_9.x86_64
[root@test001 ~]# rpm -qa|grep -i mariadb
MariaDB-server-10.6.7_3-1.el7_9.x86_64


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