CAISEC.CIA_FILTER_MATCH Not Returning Expected Results.

Products

• Top Secret
• Top Secret - LDAP

Issue/Introduction

When selecting authid, resmask, noprefix from table(CAISEC.CIA_FILTER_MATCH('ABCD','OTRAN','%','PREFIX')), the following is returned:

AUTHID RESMASK NOPREFIX
-------------------------------------------------------------
PRODDEPT ABCD 
TESTDEPT -FGH 
TESTDEPT -IJK 

Why are -FGH and -IJK returned?

Environment

Release: TOPSEC00200-15-Top Secret-Security
Component:

Resolution

Because OTRANS '-FGH'  and '-IJK' is owned and CIA cannot tell that the '-' is a floating point wild card masking character on a prefixed resource. This is not a bug.

The enhancement to have this changed has been accepted and will be added to a future level.