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

EXTRACT() returns an internal error when xxxx_MICROSECOND is used

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 1.0.1
    • Icebox
    • ExeMgr
    • None

    Description

      Build Tested:

      mscadmin> getsoft
      getsoftwareinfo Fri Jun 17 17:27:58 2016

      Name : mariadb-columnstore-platform Relocations: (not relocatable)
      Version : 1.0 Vendor: MariaDB Corporation Ab
      Release : 1 Build Date: Mon 13 Jun 2016 06:50:26 PM CDT

      #select cidx, CDATE, EXTRACT(MINUTE_MICROSECOND FROM CDATE) from datatypetestm order by cidx;
      #select cidx, CDATE, EXTRACT(HOUR_MICROSECOND FROM CDATE) from datatypetestm order by cidx;
      #select cidx, CDATE, EXTRACT(DAY_MICROSECOND FROM CDATE) from datatypetestm order by cidx;
      #select cidx, CDATETIME, EXTRACT(MINUTE_MICROSECOND FROM CDATETIME) from datatypetestm order by cidx;
      #select cidx, CDATE from datatypetestm where EXTRACT(MINUTE_MICROSECOND FROM CDATE) <> CDATE order by cidx;
      #select cidx, CDATE from datatypetestm where EXTRACT(HOUR_MICROSECOND FROM CDATE) <> CDATE order by cidx;
      #select cidx, CDATE from datatypetestm where EXTRACT(DAY_MICROSECOND FROM CDATE) <> CDATE order by cidx;
      #select cidx, CDATETIME from datatypetestm where EXTRACT(MINUTE_MICROSECOND FROM CDATETIME) <> CDATETIME order by cidx;
      #select cidx, CDATETIME from datatypetestm where EXTRACT(HOUR_MICROSECOND FROM CDATETIME) <> CDATETIME order by cidx;
      #select cidx, CDATETIME from datatypetestm where EXTRACT(DAY_MICROSECOND FROM CDATETIME) <> CDATETIME order by cidx;

      The above statements returned the following error msg. It looks like XXX_MICROSECOND caused the problem.

      ERROR 1815 (HY000) at line 76: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file &

      Attachments

        Activity

          People

            Unassigned Unassigned
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.