[MCOL-3530] UPDATE on text/blob column with a join returns "Exemgr Error 1000: Created: 2019-09-30  Updated: 2021-01-15

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: 1.4.0
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
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



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-11-14 ]

dleeyh does this actually work in 1.2?

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