rlm_sql: "NUMERIC VALUE OUT OF RANGE" error

[Alan DeKok]

Vegard Svanberg wrote:
> I have a NAS which sends a NAS-Port-Id attribute in the range
> 2147483648..2164260863. PostgreSQL doesn't like the query Freeradius
> performs. It's choking when trying to insert for instance
> '2163214239::integer' into the radacct table.
> 
> $ 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?

  Alan DeKok.