Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
6.2.3
-
None
-
2024-1
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