26 Sep
2006
26 Sep
'06
8:23 a.m.
On Tue 26 Sep 2006 14:45, Guilherme Franco wrote:
Hi,
This is what happens:
SQL> UPDATE radippool SET nasipaddress = '', pool_key = 0,callingstationid = '', expiry_time = current_timestamp - interval '1' second(1) WHERE pool_key = '2398432';
0 rows updated.
SQL> SELECT framedipaddress FROM radippool WHERE pool_name = 'FOO' AND expiry_time < current_timestamp AND ROWNUM = 1 ORDER BY (select username from radippool where username <> ''), (select callingstationid from radippool where callingstationid <> ''),expiry_time FOR UPDATE;
no rows selected
So there you go. You found the problem.. Why doesn't it find any rows? -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc