[MDEV-33302] Columnstore does not support 32-bit timestamps: CAL0001: MCS-2025: Data truncated for column Created: 2024-01-23  Updated: 2024-01-24

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - ColumnStore, Temporal Types
Affects Version/s: N/A
Fix Version/s: 11.4

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

Issue Links:
Blocks
is blocked by MCOL-5644 32-bit timestamp values support Open
Problem/Incident
is caused by MDEV-32188 make TIMESTAMP use whole 32-bit unsig... In Testing

 Description   

bb-11.4-timestamp 53df87b27d9e0c0e7e5f2e2e7e5aabd86aa20bee

MariaDB [test]> create table t (a timestamp) engine=Columnstore;
Query OK, 0 rows affected (0.760 sec)
 
MariaDB [test]> insert into t values ('2030-01-01 00:00:00');
Query OK, 1 row affected (1.209 sec)
 
MariaDB [test]> insert into t values ('2040-01-01 00:00:00');
ERROR 1264 (22003): CAL0001: MCS-2025: Data truncated for column 'a'   
 
MariaDB [test]> show warnings;
+-------+------+-----------------------------------------------------+
| Level | Code | Message                                             |
+-------+------+-----------------------------------------------------+
| Error | 1264 | CAL0001: MCS-2025: Data truncated for column 'a'    |
| Error | 1036 | Table 't' is read only                              |
+-------+------+-----------------------------------------------------+
2 rows in set (0.000 sec)
 
MariaDB [test]> insert into t values ('2038-01-01 00:00:00');
Query OK, 1 row affected (0.125 sec)


Generated at Thu Feb 08 10:37:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.