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

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 1.5.2
    • 6.2.1, 6.2.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.

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              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.