[BUG] Union queries fail in CRDB due to a type mismatch

XMLWordPrintable

    • Type: Sub-task
    • Resolution: Fixed
    • Priority: L3 - Default
    • 7.14.0, 7.14.0-alpha2
    • Affects Version/s: None
    • Component/s: engine
    • None

      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)

        This is the controller panel for Smart Panels app

          1. historic-statistics-query-example.txt
            2 kB
          2. historic-statistics-query-test-failures.txt
            73 kB

              Assignee:
              Unassigned
              Reporter:
              Nikola Koevski
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: