Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.2.5
-
None
-
vmware / centos 7
Description
When I try to run the following query addind one more "where" field I got an error:
Original query:
MariaDB [chargify_tickets]> select date(`timestamp`), organization_id, bw_chunk, count(0) from flow_tickets where date(`timestamp`) = '2020-01-31' group by 1, 2, 3;
-----------------------------------------------------------------------+
| date(`timestamp`) | organization_id | bw_chunk | count(0) |
-----------------------------------------------------------------------+
| 2020-01-31 | 7a21fc9f-3901-426f-9ed7-88329aaf5df2 | 120 | 5 |
| 2020-01-31 | cdf062ef-0d3a-4736-b45c-722ac1161fa2 | 120 | 22 |
| 2020-01-31 | 8c614250-efe3-44ae-84c2-06046aa4cbfa | 78 | 7 |
...
Adding one more (valid) condition:
MariaDB [chargify_tickets]> select date(`timestamp`), organization_id, bw_chunk, count(0) from flow_tickets where date(`timestamp`) = '2020-01-31' AND organization_id='7a21fc9f-3901-426f-9ed7-88329aaf5df2' group by 1, 2, 3;
ERROR 1815 (HY000): Internal error: IDB-2035: An internal error occurred. Check the error log file & contact support.
Logs:
Feb 3 08:17:40 infra-sp2-mcs-pm01 Calpont[12060]: 40.320949 |0|0|0| E 00 CAL0000: /data/buildbot/bb-worker/centos7/mariadb-columnstore-engine/primitives/primproc/dictstep.cpp@393: assertion 'pt[primMsg->NVALS].offsetIndex != 0' failed
Feb 3 08:17:40 infra-sp2-mcs-pm01 PrimProc[12060]: 40.321016 |0|0|0| W 28 CAL0000: IDB-2035: An internal error occurred. Check the error log file & contact support.