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
pgpiEhA0xUlHI.pgp
Description: PGP signature
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
