dmwm / DDM

Dynamic Data Management - Cache release and auto-replication of hot data
1 stars 9 forks source link

Escape "_" in SQL queries #66

Open nikmagini opened 9 years ago

nikmagini commented 9 years ago

The "_" character is an Oracle wildcard, so it should be escaped where appopriate in SQL queries. This affects in particular the Victorinterface APIs, where the results for the "T2_TH_CUNSTDA" site contain entries both for "T2_TH_CUNSTDA" (CMS name) and "T2-TH-CUNSTDA" (GOCDB name for the same site):

https://cmsweb.cern.ch/popdb/victorinterface/accessedBlocksStatLastAcc/?sitename=T2_TH_CUNSTDA