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

Cross-Engine join at text type not supported

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 6.2.3
    • 23.10.2
    • ?
    • 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

      Attachments

        Activity

          kirill.perov@mariadb.com Kirill Perov (Inactive) added a comment - - edited

          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

          kirill.perov@mariadb.com Kirill Perov (Inactive) added a comment - - edited 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

          cross-engine on text columns checked on develop 02.06.2024

          kirill.perov@mariadb.com Kirill Perov (Inactive) added a comment - cross-engine on text columns checked on develop 02.06.2024

          People

            sergey.zefirov Sergey Zefirov
            suresh.ramagiri@mariadb.com suresh ramagiri
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.