Kbase P96650: SQL-92: Is the READPAST locking hint supported in a Sub-Query of a SELECT statement?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/10/2004 |
|
Status: Unverified
GOAL:
Is the READPAST locking hint supported in a Sub-Query of a SELECT statement?
FACT(s) (Environment):
OpenEdge 10.0A
OpenEdge 10.0B
FIX:
No, the READPAST locking hint is only supported in the main SELECT statement, not in a sub-query
Example
Supported syntax
SELECT * FROM tblname WHERE search_condition WITH {locking_hints}
Not supported syntax (note that the locking hints is in a sub-select)
SELECT * FROM tblname WHERE (SELECT field from tblname1 WITH {locking_hints}