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

Cross-Engine join at text type not supported

    XMLWordPrintable

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

          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.