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

Introduce extra mysql queries for setting removal time async without respecting hierarchies

    XMLWordPrintable

Details

    • Bug Report
    • Resolution: Fixed
    • L3 - Default
    • 7.11.0, 7.11.0-alpha5
    • None
    • engine
    • None

    Description

      Steps to reproduce
      Setup the Engine with a MariaDB or MySQL database

      If an update statement is executed against a table that has columns of type TIMESTAMP without any constraint or with constraint NOT NULL, ...

      Observed behavior
      ...the value of these fields are automatically updated with the current timestamp

      Expected behavior
      ... the original timestamp value of these fields are preserved

      Root cause

      • if a table is created without any constraint on column of type TIMESTAMP or with constraint NOT NULL, the implicit default value is timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) and the field is updated with the current timestamp
      • if a table is created with NULL constraint on column of type TIMESTAMP, the respective field is not updated with current timestamp as the implicit default value is NULL DEFAULT NULL

      AT
      Extra queries are introduced for:

      • External Task Log
      • Identity Link Log
      • Historic Incident
      • User Operation Log

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Issue Links

            depends on

            Sub-task - The sub-task of the issue CAM-10133 Using Java API, I can set a removal time for processes asynchronously without respecting hiearchies

            • L3 - Default - Minor issue or issue with existing workaround, feature requests and questions
            • Closed
            is related to

            Bug Report - A problem which impairs or prevents the functions of the product. CAM-9505 On MariaDB and MySQL an update operation leads to an update of date fields if column type is timestamp

            • L3 - Default - Minor issue or issue with existing workaround, feature requests and questions
            • Closed

            Sub-task - The sub-task of the issue CAM-10664 Introduce extra update statement to prevent updating the timestamp with mysql

            • L3 - Default - Minor issue or issue with existing workaround, feature requests and questions
            • Closed

            Feature Request - A new feature of the product, which has yet to be developed. CAM-10130 I can set a removal time for processes asynchronously

            • L3 - Default - Minor issue or issue with existing workaround, feature requests and questions
            • Closed

            Feature Request - A new feature of the product, which has yet to be developed. CAM-10132 Using Java API, I can set removal time for batches asynchronously

            • L3 - Default - Minor issue or issue with existing workaround, feature requests and questions
            • Closed

            Activity

              People

                miklas.boskamp Miklas Boskamp
                tassilo.weidner Tassilo Weidner
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Salesforce