We couldn't load all Actvitity tabs. Refresh the page to try again.
If the problem persists, contact your Jira admin.
We couldn't load the project sidebar. Refresh the page to try again.
If the problem persists, contact your Jira admin.
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

            Loading...
            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:

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

                                Created:
                                Updated:
                                Resolved: