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

EXTRACT() function returns an exception when processing *MICROSECONDS

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.0.4
    • ExeMgr
    • None
    • 2016-19

    Description

      Build tested:

      mscadmin> getsoft
      getsoftwareinfo Thu Jun 2 09:55:23 2016

      Name : mariadb-columnstore-platform Relocations: (not relocatable)
      Version : 1.0 Vendor: MariaDB Corporation Ab
      Release : 0 Build Date: Fri 27 May 2016 03:07:53 PM CDT
      Install Date: Mon 30 May 2016 10:07:40 AM CDT Build Host: srvbuilder
      Group : Applications Source RPM: mariadb-columnstore-1.0-0.src.rpm

      The issue was reported by autopilot's distributed function test case

      The following queries have the *MICROSECOND issue:

      11 select cidx, CDATE, EXTRACT(MINUTE_MICROSECOND FROM CDATE) from datatypetestm order by cidx;
      13 select cidx, CDATE, EXTRACT(HOUR_MICROSECOND FROM CDATE) from datatypetestm order by cidx;
      16 select cidx, CDATE, EXTRACT(DAY_MICROSECOND FROM CDATE) from datatypetestm order by cidx;
      33 select cidx, CDATETIME, EXTRACT(HOUR_MICROSECOND FROM CDATETIME) from datatypetestm order by cidx;
      53 select cidx, CDATE from datatypetestm where EXTRACT(HOUR_MICROSECOND FROM CDATE) <> CDATE order by cidx;
      56 select cidx, CDATE from datatypetestm where EXTRACT(DAY_MICROSECOND FROM CDATE) <> CDATE order by cidx;
      73 select cidx, CDATETIME from datatypetestm where EXTRACT(HOUR_MICROSECOND FROM CDATETIME) <> CDATETIME order by cidx;
      76 select cidx, CDATETIME from datatypetestm where EXTRACT(DAY_MICROSECOND FROM CDATETIME) <> CDATETIME order by cidx;

      Errors returned:

      [root@columnStore CNX]# cat EXTRACT.DM.sql.diff.log| grep -i error
      > ERROR 1815 (HY000) at line 11: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.
      > ERROR 1815 (HY000) at line 13: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.
      > cidERROR 1815 (HY000) at line 16: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.
      > select cidx, CDATETIME,ERROR 1815 (HY000) at line 31: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.
      > ERROR 1815 (HY000) at line 33: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.
      > select cidx, CDATETIME, EXTRACT(HOUR_MINUTE FROM CDATETIME) from datatypetestm orderERROR 1815 (HY000) at line 36: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.
      > select cidx, CDATE from datatypetestm where EXTRACT(WEEK FROM CDATE) <>ERROR 1815 (HY000) at line 51: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.
      > ERROR 1815 (HY000) at line 53: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.
      > ERROR 1815 (HY000) at line 56: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.
      > --------ERROR 1815 (HY000) at line 71: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.
      > ERROR 1815 (HY000) at line 73: Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.
      > 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 & contact support.

      Attachments

        Issue Links

          Activity

            People

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