[MCOL-5635] Query - view with sum/truncate/floor() erroring: rowgroup.h@821: assertion '0' failed Created: 2024-01-05  Updated: 2024-01-08

Status: Open
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 6.4.7- CS only
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Jordan G Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

ubuntu22



 Description   

We run mariadb 10.6.16 with cs plugin 6.4.7 and we get error on a query over view:

Jan 3 12:35:11 dev ExeMgr[578581]: 11.660132 |46|0|0| D 16 CAL0041: Start SQL statement: SELECT ROUND(SUM(bytes*8)/1024/1024/300,2) as Mbps from all_macs_mac1_5min WHERE stamp_inserted='2024-01-03 09:40:00' ORDER BY Mbps DESC LIMIT 5; |<proc>|

Jan 3 12:35:11 dev Calpont[578581]: 11.757820 |0|0|0| E 00 CAL0000: ./storage/columnstore/columnstore/utils/rowgroup/./rowgroup.h@821: assertion '0' failed
Jan 3 12:35:11 dev joblist[578581]: 11.758071 |46|0|0| C 05 CAL0000: SubAdapterStep::execute() MCS-2035: An internal error occurred. Check the error log file & contact support.
Jan 3 12:35:11 dev ExeMgr[578581]: 11.760413 |46|0|0| D 16 CAL0042: End SQL statement

The same issue is observed with all other functions - ROUND, TRUNCATE, CEIL, FLOOR.
If we remove them everything is OK.

No such issue in version 5.6.2.



 Comments   
Comment by Jordan G [ 2024-01-08 ]

Issue is in the bytes*8) statement.
Please close this case.

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