Kbase P150199: the parameter -Dsrv qt_debug,qt_no_bind_where does not work with CAN-FIND or FIND statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/07/2009 |
|
Status: Unverified
SYMPTOM(s):
the parameter -Dsrv qt_debug,qt_no_bind_where does not work with CAN-FIND or FIND statement
DataServer.log shows that despite using qt_no_bind_where binding variables are still used:
SELECT /*+ INDEX(T0 QAD_WKFL##QAD_INDEX1) */ COUNT(*) FROM QAD.Q
AD_WKFL T0 WHERE (upper(QAD_DOMAIN) = upper(:1) AND upper(QAD_KEY
1) LIKE upper(:2) ESCAPE '\' AND upper(QAD_KEY2) = upper(:3)) AND
rownum <= :Rn
FACT(s) (Environment):
Example ABL code:
ccOrder = can-find(first qad_wkfl
where qad_wkfl.qad_domain = global_domain
and qad_key1 begins string(so_nbr, "x(8)")
and qad_key2 = "creditcard")
All Supported Operating Systems
OpenEdge 10.x
Progress 9.1D
Progress 9.1E
Progress 9.1C
CAUSE:
This is expected behaviour. ORACLE Dsrv has to ignore the qt_no_bind_where for FIND and CAN-FIND.
FIX:
None