SubAdapterStep::execute() MCS-2035 Fix Requested

ERROR 1815 (HY000) at line 2: Internal error: SubAdapterStep::execute() MCS-2035: An internal error occurred.  Check the error log file & contact support.

Feb  4 20:08:37 ip-172-31-35-155 Calpont[461757]: 37.223756 |0|0|0| E 00 CAL0000: /home/jenkins/workspace/Build-Package/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX_ON_ES_BACKUP_DEBUGSOURCE/storage/columnstore/columnstore/utils/rowgroup/rowgroup.h@839: assertion '0' failed         %%10%%

bash cs_package_manager.sh install enterprise 10.6.14-9

mariadb -e "create database if not exists test"

mariadb test < LTE_HIST_SECTOR_DAILY.sql

mariadb test < LTE_HIST_SECTOR_DAILY.tbl.gz

mariadb test < LTE_HIST_SECTOR_HOURLY.sql

cpimport test LTE_HIST_SECTOR_HOURLY LTE_HIST_SECTOR_HOURLY.tbl -s '\t' 

echo "

SELECT ElementID ElementID, Longitude, Latitude, ValidFor, DimCount, DimValue , (DimValue * DimCount) newvalue

FROM

(

SELECT ElementID ElementID, Longitude, Latitude, TIMESTAMP(Date) ValidFor, HistType, DimValue, AVG(DimCount) DimCount

FROM

(

SELECT ElementID, Longitude, Latitude, Date, HistType, DimValue, DimCount

FROM

(

SELECT ElementID, Longitude, Latitude, Date, HistType, DimValue, DimCount

FROM LTE_HIST_SECTOR_DAILY C 

WHERE Longitude >= 120.431725 AND Longitude <= 122.675259 AND Latitude >= 24.018287 AND Latitude <= 26.113308 

    AND Date = DATE('2024-08-21')

    AND (HistType IN ('CT_RSRPValues','CT_RSRQValues'))

) D

UNION ALL

SELECT ElementID, Longitude, Latitude, Date, HistType, DimValue, DimCount

FROM

(

SELECT ElementID, Longitude, Latitude, Date, HistType, DimValue, DimCount

FROM LTE_HIST_SECTOR_HOURLY C

WHERE Longitude >= 120.431725 AND Longitude <= 122.675259 AND Latitude >= 24.018287 AND Latitude <= 26.113308 

    AND Date = DATE('2024-08-20')

    AND (HistType IN ('CT_RSRPValues','CT_RSRQValues'))

) H

) X

GROUP BY ElementID, Longitude, Latitude, ValidFor, HistType, DimValue

) V

HAVING DimCount IS NOT NULL

" > problem.sql

mariadb test < problem.sql

echo "

set session columnstore_select_handler=OFF;

SELECT ElementID ElementID, Longitude, Latitude, ValidFor, DimCount, DimValue , (DimValue * DimCount) newvalue

FROM

(

SELECT ElementID ElementID, Longitude, Latitude, TIMESTAMP(Date) ValidFor, HistType, DimValue, AVG(DimCount) DimCount

FROM

(

SELECT ElementID, Longitude, Latitude, Date, HistType, DimValue, DimCount

FROM

(

SELECT ElementID, Longitude, Latitude, Date, HistType, DimValue, DimCount

FROM LTE_HIST_SECTOR_DAILY C 

WHERE Longitude >= 120.431725 AND Longitude <= 122.675259 AND Latitude >= 24.018287 AND Latitude <= 26.113308 

    AND Date = DATE('2024-08-21')

    AND (HistType IN ('CT_RSRPValues','CT_RSRQValues'))

) D

UNION ALL

SELECT ElementID, Longitude, Latitude, Date, HistType, DimValue, DimCount

FROM

(

SELECT ElementID, Longitude, Latitude, Date, HistType, DimValue, DimCount

FROM LTE_HIST_SECTOR_HOURLY C

WHERE Longitude >= 120.431725 AND Longitude <= 122.675259 AND Latitude >= 24.018287 AND Latitude <= 26.113308 

    AND Date = DATE('2024-08-20')

    AND (HistType IN ('CT_RSRPValues','CT_RSRQValues'))

) H

) X

GROUP BY ElementID, Longitude, Latitude, ValidFor, HistType, DimValue

) V

HAVING DimCount IS NOT NULL

" > workaround.sql ;

mariadb test < workaround.sql ;