Affects Version/s: 6.12.2
Fix Version/s: None
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