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
problem 1:
create table foo5 (a text ) engine=columnstore;
create table bar5 (a text ) engine=columnstore;
select * from foo5,bar5;
ERROR 1815 (HY000): Internal error: MCS-1000: 'foo5' and 'bar5' are not joined.
problem2:
create table foo5 (a text );
create table bar5 (a text ) engine=columnstore;
select * from foo5 where exists ( select 1 from bar5 where foo5.a=bar5.a);
ERROR 1815 (HY000): Internal error: CrossEngineStep::execute() fatal error running mysql_real_connect() in libmysql_client lib (1698) (Access denied for user 'root'@'localhost')
select * from foo5,bar5;
ERROR 1815 (HY000): Internal error: MCS-1000: 'foo5' and 'bar5' are not joined.
no such errors for default engine
tested on develop 02.06.2024