Uploaded image for project: 'Jenkins'
  1. Jenkins
  2. JENKINS-72753

Plugin fails weirdly when certain parameter values are passed

      Getting some weird behaviour when trying to pass slightly longer/more complex parameters.

      This seems to work:

      /parambuild/?REF=ABC123&SQL_Update=update%20TABLE%20set%20ACTIVE%3D0%20where%20USER%20LIKE%20%27ABC%27

      but this doesn't:

      /parambuild/?REF=ABC123&SQL_Update=update%20TABLE%20set%20ACTIVE%3D0%20where%20USER%20%3D%20%27ABC%27

      (returns "This site can't be reached. The connection was reset.")

      Curiously though, if I remove the previous equals sign (%3D) from the SQL_Update parameter, it works:

      /parambuild/?REF=ABC123&SQL_Update=update%20TABLE%20set%20ACTIVE0%20where%20USER%20%3D%20%27ABC%27

      However I don't think it's a "multiple equals signs" issue, as this works fine:

      /parambuild/?REF=ABC123&SQL_Update=a%3Db%20%3D%20c%3Dd

      Also, this one fails, even with no equals signs... but I added an underscore somewhere:

      /parambuild/?REF=ABC123&SQL_Update=update%20TABLE%20set%20ACTIVE%200%20where%20USER_ID%20LIKE%20%27ABC%27

      But this one with underscore works fine:

      /parambuild/?REF=ABC123&SQL_Update=USER_ID%20like%20%27ABC%27

       

      Good luck figuring out what's going on!

          [JENKINS-72753] Plugin fails weirdly when certain parameter values are passed

          Ryan added a comment -

          ... it may also be happening with /buildWithParameters as well, so... either it's a core Jenkins problem that's causing it, or it could be a problem with this module as well (if it shares code).

          Weirdly also, if I put brackets around the USER_ID from an earlier example that was failing, it works...

          /parambuild/?REF=ABC123&SQL_Update=update%20TABLE%20set%20ACTIVE%200%20where%20(USER_ID)%20LIKE%20%27ABC%27

          Ryan added a comment - ... it may also be happening with /buildWithParameters as well, so... either it's a core Jenkins problem that's causing it, or it could be a problem with this module as well (if it shares code). Weirdly also, if I put brackets around the USER_ID from an earlier example that was failing, it works... /parambuild/?REF=ABC123&SQL_Update=update%20TABLE%20set%20ACTIVE%200%20where%20(USER_ID)%20LIKE%20%27ABC%27

            sugonyak_ivan Ivan Sugonyak
            plaqilqi Ryan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: