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

[Ovidiu Sas]

Make sure that the values are stored as strings in the table, not as float.

-ovidiu

On Tue, Mar 12, 2013 at 10:40 PM, Jayesh Nambiar <jayesh1017 at gmail.com> wrote:
> Hi Ovidiu,
> Thanks for your reply. But I just expect them to be stored as string in my
> AVPs. Even in 1.8.2, when I dumped those AVPs back into a database table, it
> always put the exact value like 1.0000 or 0.0123 etc. So it was indeed
> storing the entire value as string in the AVPs and not as 1 or 0. Is this
> behaviour changed now?
>
>
> --- Jayesh
>
>
> On Tuesday, March 12, 2013, Ovidiu Sas wrote:
>>
>> 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