Interactive Report Bind Variable Evaluation - Bug?
I have a table with a column whose data contains commas. When an equals filter is created against this column the results are accurate. However, if you use an "in" filter the results do not contain all of the expected results. When you look at the debug information to see how the query was written/performed you see this:
where ("PARAMETER" in (:APXWS_EXPR_VAL1_1, :APXWS_EXPR_VAL2_1)
So when the system substitutes the parameter names into the bind variables you end up with
APXWS_EXPR_VAL1_1 = Fecal Coliform
APXWS_EXPR_VAL2_1 = Coliform, Fecal
Because the second parameter name has a comma in it, the executed query ends up behaving like it has three values in it.
where ("PARAMETER" in (:APXWS_EXPR_VAL1_1, :APXWS_EXPR_VAL2_1)
So when the system substitutes the parameter names into the bind variables you end up with
APXWS_EXPR_VAL1_1 = Fecal Coliform
APXWS_EXPR_VAL2_1 = Coliform, Fecal
Because the second parameter name has a comma in it, the executed query ends up behaving like it has three values in it.
0