[MCOL-149] EXTRACT() returns an internal error when xxxx_MICROSECOND is used Created: 2016-06-17  Updated: 2016-09-29  Resolved: 2016-09-29

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.0.1
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Daniel Lee (Inactive) Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: 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 &



 Comments   
Comment by Dipti Joshi (Inactive) [ 2016-06-18 ]

dleeyh Is this duplicate of MCOL-99 ?

Comment by Dipti Joshi (Inactive) [ 2016-09-29 ]

This is duplicate of MCOL-99

Generated at Thu Feb 08 02:18:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.