[MCOL-4877] Too long values are silently truncated without errors or warnings upon UPDATE Created: 2021-09-27  Updated: 2021-10-20

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-26699 Row counter does not work consistentl... Open

 Description   

Server 10.7 8dd4794c4, Columnstore 6.1.1

MariaDB [db]> create table t (c char(4)) engine=Columnstore;
Query OK, 0 rows affected (0.632 sec)
 
MariaDB [db]> insert into t values ('foo');
Query OK, 1 row affected (0.194 sec)
 
MariaDB [db]> insert into t values ('foobar');
ERROR 1406 (22001): Data too long for column 'c' at row 1
MariaDB [db]> update t set c = 'foobar';
Query OK, 1 row affected (0.276 sec)
Rows matched: 1  Changed: 1  Warnings: 0
 
MariaDB [db]> select * from t;
+------+
| c    |
+------+
| foob |
+------+
1 row in set (0.034 sec)

So, INSERT is dutifully rejected, but UPDATE is accepted without any complaint.


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