Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3699

Cross-engine join fails: fatal error running mysql_real_connect() in libmysql_client lib (1698) (Access denied for user 'root'@'localhost')

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • 1.4.2
    • Icebox
    • N/A
    • 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)
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.