Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-12071 Official support for CockroachDB
  3. CAM-12160

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

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.14.0, 7.14.0-alpha2
    • None
    • 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

              Unassigned Unassigned
              nikola.koevski Nikola Koevski
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: