jim.thompson_at_lagosantafe.com (Jim Thompson) wrote in message news:<8f516336.0212101145.726cb0c5_at_posting.google.com>...
> 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.
I've noticed something else today -- It seems that queries with the in clause
of one element don't work.
Received on Mon Dec 16 2002 - 15:10:22 CST
