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

Cannot escape characters when using like operator on DB2

    XMLWordPrintable

Details

    Description

      Steps to reproduce:
      1) start a process instance with a variable foo and the value bar_123
      2) login into cockpit
      3) go to the runtime process instance view of the specific process instance
      4) search for the variable inside the variables tab by using this query:

      foo like "bar\_%"
      

      Problem:
      The variable foo is not returned.

      Expected Behavior:
      The variable foo is found.

      Hint:
      The following sql statement does not return the variable

      select * from ACT_RU_VARIABLE where TEXT_ like 'bar\_%'
      

      When the sql statement is changed as follows (ESCAPE '\' has been added):

      select * from ACT_RU_VARIABLE where TEXT_ like 'bar\_%' ESCAPE '\'
      

      then the variable is found

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Activity

            People

              michael.schoettes Michael Schoettes
              roman.smirnov Roman Smirnov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce