Skip Locked failed to return correct result set.

SELECT *
FROM Libra_Sentinel
WHERE DomainObject_uuid in ('D67E84DF7BDFCC419A0E22C93ED7AE6F') FOR UPDATE NOWAIT SKIP LOCKED returns the correct result set -- one row.

SELECT *
FROM TradePilot.Libra_Sentinel
WHERE DomainObject_uuid in HEXTORAW('D67E84DF7BDFCC419A0E22C93ED7AE6F') FOR UPDATE NOWAIT skip locked

returns the wrong result set -- "nothing"

Any suggestions?

BTW, the HEXTORAW allows use of index in query.

Use of skip locked is very important in the logic of this app. Received on Tue Dec 10 2002 - 13:45:25 CST