Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Unresolved
-
1.4.0
-
None
-
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