[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 The same issue is observed with all other functions - ROUND, TRUNCATE, CEIL, FLOOR. No such issue in version 5.6.2. |
| Comments |
| Comment by Jordan G [ 2024-01-08 ] |
|
Issue is in the bytes*8) statement. |