[OpenSIPS-Users] querying float point values in opensips-1.9 gives error

[Ovidiu Sas]

You are trying to store a float into an int.  Prior to 1.9, there
wasn't a strict check on the conversion and whatever the result was,
it was stored (i.e. 1.000 was stored as 1 and 0.0123 was stored as 0).
For more info: http://linux.die.net/man/3/strtol
Starting with 1.9, there is a strict check for invalid characters and
therefore the conversion fails: 1.000 and 0.0123 are not a valid
integers.

Regards,
Ovidiu Sas

On Tue, Mar 12, 2013 at 10:36 AM, Jayesh Nambiar <jayesh1017 at gmail.com> wrote:
> Hi,
> I am testing out Opensips-1.9 currently. While I was using opensips-1.8.2, I
> used avp_db_query to query some values from database tables which were float
> point values and used those values to insert into acc table. Obviously for
> billing reasons. But after upgrading to 1.9 it gives error.
> Eg: I am querying a table containing values 1.0000, 0.0123 etc. and storing
> it into AVPs. But the 1.9 version gives the following error:
> ERROR:core:db_str2int: Unexpected characters: [.0000]
> ERROR:db_mysql:db_mysql_str2val: error while converting integer value from
> string
>
> Can someone help me to take corrective actions inorder to avoid these
> errors. Any help is much appreciated.
>
> Thanks,
>
> --- Jayesh
>