[MCOL-4421] Add TIME_ROUND_FRACTIONAL support in ColumnStore Created: 2020-11-28  Updated: 2023-07-01

Status: Open
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: 5.4.3
Fix Version/s: 23.10

Type: Task Priority: Major
Reporter: Alexander Barkov Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: datatype

Issue Links:
Relates
relates to MDEV-16991 Rounding vs truncation for TIME, DATE... Closed

 Description   

ColumnStore currently ignores sql_mode=TIME_ROUND_FRACTIONAL:

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a DECIMAL(10,7)) ENGINE=ColumnStore;
INSERT INTO t1 VALUES (1.0000006);
SET sql_mode=TIME_ROUND_FRACTIONAL;
SELECT CAST(a AS TIME(6)) FROM t1;

+--------------------+
| CAST(a AS TIME(6)) |
+--------------------+
| 00:00:01.000000    |
+--------------------+

The expected result should be:

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a DECIMAL(10,7)) ENGINE=MyISAM;
INSERT INTO t1 VALUES (1.0000006);
SET sql_mode=TIME_ROUND_FRACTIONAL;
SELECT CAST(a AS TIME(6)) FROM t1;

+--------------------+
| CAST(a AS TIME(6)) |
+--------------------+
| 00:00:01.000001    |
+--------------------+


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