Given:
An number of started Process Instances with incidents.

When:
A HistoricActivityStatisticsQuery is executed.

Then:
The query fails due to a type mismatch between the ACT_HI_INCIDENT and ACT_HI_ACTINST tables.

Expected:
The HistoricActivityStatisticsQuery is succeeds without an exception.

Note:
This is a reported bug in CRDB. The reason that it's not detected in other supported databases (e.g. Postgres), is that they are more lenient with type matching (ref)