Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
1.5.2
-
None
-
None
-
CentOS 7 Using MariaDB ColumnStore 1.1
-
2021-8, 2021-9, 2021-10
Description
Using the CONVERT_TZ command with an UPDATE query throws "IDB-1815: Unknown Error".
Here is an example query that produces the error:
UPDATE mytable SET `dateTimeOriginationConverted`= CONVERT_TZ(FROM_UNIXTIME(`dateTimeOrigination`), @@session.time_zone,'America/New_York') WHERE ID = 1;
This only happens when referencing the field value (dateTimeOrigination is an INT field in the database that contains the UNIX timestamp value). If you use a static INT, the update works fine. The command also works fine as is on a standard MySQL 5.7 server using InnoDB. so this must be specific to MariaDB or ColumnStore.