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

UPDATE on text/blob column with a join returns "Exemgr Error 1000:

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.0
    • Fix Version/s: None
    • Component/s: DMLProc
    • Labels:
      None

      Description

      Build tests: 1.4.0-1

      engine commit:
      1f47534

      MariaDB [mytest]> update tinytext1 t1, tinytext2 t2 set t1.c2=t2.c2 where t1.c1=t2.c1 and t2.c1=3;
      ERROR 1815 (HY000): Internal error: CAL0002: Update Failed: ExeMgr Error 1000

      The issue affected the following data types:

      blob
      longblob
      longtext
      mediumblob
      mediumtext
      text
      tinyblob
      tinytext

      Here is an example for tinytext:

      MariaDB [mytest]> create table tinytext1 (c1 int, c2 tinytext) engine=columnstore;
      Query OK, 0 rows affected (0.167 sec)

      MariaDB [mytest]> create table tinytext2 (c1 int, c2 tinytext) engine=columnstore;
      Query OK, 0 rows affected (0.178 sec)

      MariaDB [mytest]> #
      MariaDB [mytest]> insert into tinytext1 values (1,'cdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456');
      Query OK, 1 row affected (0.280 sec)

      MariaDB [mytest]> insert into tinytext2 values (1,'cdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456');
      Query OK, 1 row affected (0.275 sec)

      MariaDB [mytest]> select * from tinytext1;
      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      c1 c2

      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      1 cdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456

      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.107 sec)

      MariaDB [mytest]> select * from tinytext2;
      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      c1 c2

      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      1 cdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456789abcdefghij0123456

      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.070 sec)

      MariaDB [mytest]> update tinytext1 t1, tinytext2 t2 set t1.c2=t2.c2 where t1.c1=t2.c1 and t2.c1=3;
      ERROR 1815 (HY000): Internal error: CAL0002: Update Failed: ExeMgr Error 1000

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            dleeyh Daniel Lee
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

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