[MCOL-5644] 32-bit timestamp values support Created: 2024-01-24  Updated: 2024-01-24

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

Type: New Feature Priority: Major
Reporter: Roman Assignee: Max Mether
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-33302 Columnstore does not support 32-bit t... Open

 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 02:59:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.