Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1356

CONVERT_TZ Throws "IDB-1815: Unknown Error" in UPDATE or SELECT statement

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.5.2
    • Fix Version/s: 6.2.1, 6.2.2
    • Component/s: None
    • Labels:
      None
    • Environment:
      CentOS 7 Using MariaDB ColumnStore 1.1
    • Sprint:
      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              memog29 Mike Archipley
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.