rlm_sql: "NUMERIC VALUE OUT OF RANGE" error

[Vegard Svanberg]

* Alan DeKok <aland at deployingradius.com> [2008-09-26 11:07]:

> > $ select 2163214239::integer;
> > ERROR:  integer out of range
> 
>   It's treating the number as a signed 32-bit integer, and the number is
> greater than 2^31.
> 
>   And the NASPortId field in the default schema is VARCHAR, not integer.
> 
>   Hmm... the default queries add a "::integer" to the NAS-Port-Id.  Why?

I didn't realize I could change the queries until now, so I just removed
the integer cast. Works now. Thanks.

-- 
Vegard Svanberg <vegard at svanberg.no> [*Takapa at IRC (EFnet)]