[MCOL-3699] Cross-engine join fails: fatal error running mysql_real_connect() in libmysql_client lib (1698) (Access denied for user 'root'@'localhost') Created: 2019-12-26  Updated: 2019-12-27  Resolved: 2019-12-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.4.2
Fix Version/s: Icebox

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None


 Description    

drop table if exists t2;
 
drop table if exists t3;
 
create table t2 (a int) engine=Columnstore;
 
insert into t2 values (1),(2);
 
create table t3 (a int) engine=InnoDB;
 
insert into t3 values (1),(2);
 
select * from t2 join t3 on (t2.a = t3.a);

MariaDB f93bfb9288d020b190f5c73a31223fff6439687d

 
MariaDB [db]> select * from t2 join t3 on (t2.a = t3.a);
 
ERROR 1815 (HY000): Internal error: fatal error running mysql_real_connect() in libmysql_client lib (1698) (Access denied for user 'root'@'localhost')

Same with MyISAM and Aria.
SELECT from each table separately works as expected:

MariaDB [db]> select * from t2;
 
+------+
 
| a    |
 
+------+
 
|    1 |
 
|    2 |
 
+------+
 
2 rows in set (0.040 sec)
 
 
 
MariaDB [db]> select * from t3;
 
+------+
 
| b    |
 
+------+
 
|    1 |
 
|    2 |
 
+------+
 
2 rows in set (0.001 sec)



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-12-26 ]

In the 1.4.x documentation we state that you have to explicitly configure cross engine joins due to the new security features in MariaDB 10.4. If you don't do this you will get this error.

Comment by Elena Stepanova [ 2019-12-26 ]

Where can one find this documentation?

Comment by Andrew Hutchings (Inactive) [ 2019-12-26 ]

Doc for 1.4.1 shared with you

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