Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
1.0.1
-
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 &