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-3532

Ordering on DB2 zOS 10 not working

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Cannot Reproduce
    • Icon: L3 - Default L3 - Default
    • 7.3.0, 7.3.0-alpha3
    • None
    • engine
    • None

      The ordering of a query (e.g. tasks by name) isn't working on DB2 zOS 10. For example the query: 

      SELECT SUB.* FROM ( select distinct RES.* , row_number() over (ORDER BY RES.NAME_ asc) rnk FROM ( select distinct RES.* from TRK_ACT_RU_TASK RES WHERE RES.NAME_ like ? )RES ) SUB WHERE SUB.rnk >= ? AND SUB.rnk < ?

      is missing an additional outer ORDER BY SUB.rnk statement.

        This is the controller panel for Smart Panels app

            Loading...
            Uploaded image for project: 'camunda BPM'
            1. camunda BPM
            2. CAM-3532

            Ordering on DB2 zOS 10 not working

            XMLWordPrintable

              • Icon: Bug Report Bug Report
              • Resolution: Cannot Reproduce
              • Icon: L3 - Default L3 - Default
              • 7.3.0, 7.3.0-alpha3
              • None
              • engine
              • None

                The ordering of a query (e.g. tasks by name) isn't working on DB2 zOS 10. For example the query: 

                SELECT SUB.* FROM ( select distinct RES.* , row_number() over (ORDER BY RES.NAME_ asc) rnk FROM ( select distinct RES.* from TRK_ACT_RU_TASK RES WHERE RES.NAME_ like ? )RES ) SUB WHERE SUB.rnk >= ? AND SUB.rnk < ?

                is missing an additional outer ORDER BY SUB.rnk statement.

                  This is the controller panel for Smart Panels app

                        smirnov Roman Smirnov
                        sebastian.menski Sebastian Menski
                        Votes:
                        0 Vote for this issue
                        Watchers:
                        2 Start watching this issue

                          Created:
                          Updated:
                          Resolved:

                              smirnov Roman Smirnov
                              sebastian.menski Sebastian Menski
                              Votes:
                              0 Vote for this issue
                              Watchers:
                              2 Start watching this issue

                                Created:
                                Updated:
                                Resolved: