Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-20141

SQL Query does not have escape character for underscore & percent symbol

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: 6.12.2
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None

      Description

      If the node_path has characters like '_' or '%' in their name, it needs to be escaped in LIKE clause.

       

      One of the customer has 2 different directories, their names are identical except for a single difference (19.40_beta1 & 19.40 beta1)

       

      The SQL to calculate the artifact count & size is not returning correct value for '19.40_beta1'

      The value is including ALL files from other directory '19.40 beta1'

       

      I have attached a screen-shot (Extra-Unwanted-Results.png) to show the additional rows from other directory '19.40 beta1'**

      I have also attached a screen-shot (Escape-Character-Results.png) to show the correct output for '19.40_beta1'. This SQL has the escape character '\' preceding the '_' in LIKE clause.

       

      Documentation for the default escape character can be found at http://www.dba-oracle.com/t_special_characters_like_sql_query.htm 

        Attachments

          Activity

            People

            Assignee:
            tamirh Tamir Hadad
            Reporter:
            sanjeevk Sanjeev Karani
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: