From Ricardo.Keigo@br.bosch.com Wed Jun 29 19:35:56 2011
From: "Andrade Ricardo (CI/AFU1)" <Ricardo.Keigo@br.bosch.com>
To: sr-users@lists.kamailio.org
Subject: [SR-Users] "select count(*)" with avp_db_query always returns null
Date: Wed, 29 Jun 2011 19:35:48 +0200
Message-ID: <268C7AED54EDF64F808B167324D2CBF91A0815E133@SI-MBX18.de.bosch.com>
In-Reply-To: <mailman.7110.1309356982.2672.sr-users@lists.sip-router.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2005181111=="

--===============2005181111==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi list,

Perhaps this fits better into a bug report, but I'd like to know if somebody =
out there experienced a similar issue.
I am executing a "select count" query using the avp_db_query function, but it=
 is not storing the results in any avp. Other queries are working fine.
I use db_mysql connected with a mysql 5.1 server.

I have tested this with kamailio-3.1.0 and kamailio-3.1.3, both didn't work. =
In an old box (version 1.3.x), the same query was returning the correct value.

---------------------------------------------------
Here is the case which is not working:

Code:
avp_delete("$avp(s:count)");
$var(ret) =3D avp_db_query("SELECT count(*) FROM subscriber where username=3D=
'foo'",
    "$avp(s:count)");
xlog("L_INFO", "var(ret)=3D$var(ret) avp(s:count)=3D$avp(s:count)");


Output:
INFO: <script>: var(ret)=3D1 avp(s:count)=3D<null>

(notice the return code 1, which means that the query was successfull and the=
re should be some output value stored in the avp, but it is <null>)

---------------------------------------------------

And here is one case which works as expected:

$var(ret) =3D avp_db_query("SELECT id FROM subscriber where username=3D'foo'",
    "$avp(s:count)");

Output:
INFO: <script>: var(ret)=3D1 avp(s:count)=3D11

---------------------------------------------------

Thanks in advance for any feedback.

Best regards,
Ricardo Andrade.


--===============2005181111==--


From miconda@gmail.com Tue Jul  5 11:31:16 2011
From: Daniel-Constantin Mierla <miconda@gmail.com>
To: sr-users@lists.kamailio.org
Subject:
 Re: [SR-Users] "select count(*)" with avp_db_query always returns null
Date: Tue, 05 Jul 2011 11:31:07 +0200
Message-ID: <4E12D9DB.5050105@gmail.com>
In-Reply-To:
 <268C7AED54EDF64F808B167324D2CBF91A0815E133@SI-MBX18.de.bosch.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1667474007=="

--===============1667474007==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hello,

On 6/29/11 7:35 PM, Andrade Ricardo (CI/AFU1) wrote:
> Hi list,
>
> Perhaps this fits better into a bug report, but I'd like to know if somebod=
y out there experienced a similar issue.
> I am executing a "select count" query using the avp_db_query function, but =
it is not storing the results in any avp. Other queries are working fine.
> I use db_mysql connected with a mysql 5.1 server.
>
> I have tested this with kamailio-3.1.0 and kamailio-3.1.3, both didn't work=
. In an old box (version 1.3.x), the same query was returning the correct val=
ue.
>
> ---------------------------------------------------
> Here is the case which is not working:
>
> Code:
> avp_delete("$avp(s:count)");
> $var(ret) =3D avp_db_query("SELECT count(*) FROM subscriber where username=
=3D'foo'",
>      "$avp(s:count)");
> xlog("L_INFO", "var(ret)=3D$var(ret) avp(s:count)=3D$avp(s:count)");
>
>
> Output:
> INFO:<script>: var(ret)=3D1 avp(s:count)=3D<null>
>
> (notice the return code 1, which means that the query was successfull and t=
here should be some output value stored in the avp, but it is<null>)
>
> ---------------------------------------------------
>
> And here is one case which works as expected:
>
> $var(ret) =3D avp_db_query("SELECT id FROM subscriber where username=3D'foo=
'",
>      "$avp(s:count)");
>
> Output:
> INFO:<script>: var(ret)=3D1 avp(s:count)=3D11
>
> ---------------------------------------------------
>
> Thanks in advance for any feedback.
It might be related to the type of the value returned by mysql library=20
for 'count(*)' - the avps support only integer or string values.

Have you tried also with sql_query(), is it giving the same result?

Cheers,
Daniel

--=20
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda



--===============1667474007==--


From alex@speakup.nl Tue Jul  5 11:39:26 2011
From: Alex Hermann <alex@speakup.nl>
To: sr-users@lists.kamailio.org
Subject:
 Re: [SR-Users] "select count(*)" with avp_db_query always returns	null
Date: Tue, 05 Jul 2011 11:39:24 +0200
Message-ID: <201107051139.24619.alex@speakup.nl>
In-Reply-To:
 <268C7AED54EDF64F808B167324D2CBF91A0815E133@SI-MBX18.de.bosch.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0674121596=="

--===============0674121596==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

On Wednesday 29 June 2011, Andrade Ricardo (CI/AFU1) wrote:
> Perhaps this fits better into a bug report, but I'd like to know if
> somebody out there experienced a similar issue. I am executing a "select
> count" query using the avp_db_query function, but it is not storing the
> results in any avp. Other queries are working fine. I use db_mysql
> connected with a mysql 5.1 server.
> 
> I have tested this with kamailio-3.1.0 and kamailio-3.1.3, both didn't
> work. In an old box (version 1.3.x), the same query was returning the
> correct value.
> 
> ---------------------------------------------------
> Here is the case which is not working:
> 
> Code:
> avp_delete("$avp(s:count)");
> $var(ret) = avp_db_query("SELECT count(*) FROM subscriber where
> username='foo'", "$avp(s:count)");
> xlog("L_INFO", "var(ret)=$var(ret) avp(s:count)=$avp(s:count)");
> 
> 
> Output:
> INFO: <script>: var(ret)=1 avp(s:count)=<null>
> 
> (notice the return code 1, which means that the query was successfull and
> there should be some output value stored in the avp, but it is <null>)

The return type of the COUNT() function is a BIGINT, which is ignored in 
kamailio. The attached patch converts the lower 32 bits of the result to an 
int usable by kamailio. I'll push this eventually.
-- 
Greetings,

Alex Hermann


--===============0674121596==
Content-Type: text/x-patch
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="avpops-treat-bigint-as-int.diff"
MIME-Version: 1.0

Y29tbWl0IDcwMDEwMjQ0OGE2NWIyZmNhOTVmNzYzMDI1NTAzYzkxMGIyMDY1YmQKQXV0aG9yOiBB
bGV4IEhlcm1hbm4gPGFsZXhAc3BlYWt1cC5ubD4KRGF0ZTogICBNb24gSnVsIDQgMTc6MzM6NTAg
MjAxMSArMDIwMAoKICAgIG1vZHVsZXMvYXZwb3BzOiBhdnBfZGJfcXVlcnk6IHRyZWF0IEJJR0lO
VCByZXN1bHQgYXMgSU5ULCBkaXNyZWdhcmRpbmcgdGhlIG1vc3Qgc2lnbmlmaWNhbnQgMzIgYml0
cy4KCmRpZmYgLS1naXQgYS9tb2R1bGVzL2F2cG9wcy9hdnBvcHNfZGIuYyBiL21vZHVsZXMvYXZw
b3BzL2F2cG9wc19kYi5jCmluZGV4IGI1Y2FhYmUuLmY4YTE4ZmMgMTAwNjQ0Ci0tLSBhL21vZHVs
ZXMvYXZwb3BzL2F2cG9wc19kYi5jCisrKyBiL21vZHVsZXMvYXZwb3BzL2F2cG9wc19kYi5jCkBA
IC0zOTUsNiArMzk1LDEwIEBAIGludCBkYl9xdWVyeV9hdnAoc3RydWN0IHNpcF9tc2cgKm1zZywg
Y2hhciAqcXVlcnksIHB2bmFtZV9saXN0X3QqIGRlc3QpCiAJCQkJCWF2cF92YWwubgogCQkJCQkJ
PSAoaW50KVJFU19ST1dTKGRiX3JlcylbaV0udmFsdWVzW2pdLnZhbC5pbnRfdmFsOwogCQkJCWJy
ZWFrOworCQkJCWNhc2UgREIxX0JJR0lOVDoKKwkJCQkJYXZwX3ZhbC5uCisJCQkJCQk9IChpbnQp
UkVTX1JPV1MoZGJfcmVzKVtpXS52YWx1ZXNbal0udmFsLmxsX3ZhbDsKKwkJCQlicmVhazsKIAkJ
CQljYXNlIERCMV9EQVRFVElNRToKIAkJCQkJYXZwX3ZhbC5uCiAJCQkJCQk9IChpbnQpUkVTX1JP
V1MoZGJfcmVzKVtpXS52YWx1ZXNbal0udmFsLnRpbWVfdmFsOwo=

--===============0674121596==--


From miconda@gmail.com Tue Jul  5 11:51:24 2011
From: Daniel-Constantin Mierla <miconda@gmail.com>
To: sr-users@lists.kamailio.org
Subject:
 Re: [SR-Users] "select count(*)" with avp_db_query always returns null
Date: Tue, 05 Jul 2011 11:51:16 +0200
Message-ID: <4E12DE94.6070400@gmail.com>
In-Reply-To: <201107051139.24619.alex@speakup.nl>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0383543054=="

--===============0383543054==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit



On 7/5/11 11:39 AM, Alex Hermann wrote:
> On Wednesday 29 June 2011, Andrade Ricardo (CI/AFU1) wrote:
>> Perhaps this fits better into a bug report, but I'd like to know if
>> somebody out there experienced a similar issue. I am executing a "select
>> count" query using the avp_db_query function, but it is not storing the
>> results in any avp. Other queries are working fine. I use db_mysql
>> connected with a mysql 5.1 server.
>>
>> I have tested this with kamailio-3.1.0 and kamailio-3.1.3, both didn't
>> work. In an old box (version 1.3.x), the same query was returning the
>> correct value.
>>
>> ---------------------------------------------------
>> Here is the case which is not working:
>>
>> Code:
>> avp_delete("$avp(s:count)");
>> $var(ret) = avp_db_query("SELECT count(*) FROM subscriber where
>> username='foo'", "$avp(s:count)");
>> xlog("L_INFO", "var(ret)=$var(ret) avp(s:count)=$avp(s:count)");
>>
>>
>> Output:
>> INFO:<script>: var(ret)=1 avp(s:count)=<null>
>>
>> (notice the return code 1, which means that the query was successfull and
>> there should be some output value stored in the avp, but it is<null>)
> The return type of the COUNT() function is a BIGINT, which is ignored in
> kamailio. The attached patch converts the lower 32 bits of the result to an
> int usable by kamailio. I'll push this eventually.
Thanks for quick reaction and patch. Go ahead and commit it.

Cheers,
Daniel

-- 
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda



--===============0383543054==--


From abalashov@evaristesys.com Tue Jul  5 12:04:35 2011
From: Alex Balashov <abalashov@evaristesys.com>
To: sr-users@lists.kamailio.org
Subject:
 Re: [SR-Users] "select count(*)" with avp_db_query always returns	null
Date: Tue, 05 Jul 2011 06:04:19 -0400
Message-ID: <5C4FE26A-5490-41FA-8088-F4117AD789FB@evaristesys.com>
In-Reply-To: <4E12DE94.6070400@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1509750004=="

--===============1509750004==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Does sqlops handle bigint these days? It's the same srdb1 API for Pg as avp_d=
b_query(), right? So perhaps that's the wrong question.

--
Alex Balashov - Principal
Evariste Systems LLC
260 Peachtree Street NW
Suite 2200
Atlanta, GA 30303
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/

On Jul 5, 2011, at 5:51 AM, Daniel-Constantin Mierla <miconda(a)gmail.com> wr=
ote:

>=20
>=20
> On 7/5/11 11:39 AM, Alex Hermann wrote:
>> On Wednesday 29 June 2011, Andrade Ricardo (CI/AFU1) wrote:
>>> Perhaps this fits better into a bug report, but I'd like to know if
>>> somebody out there experienced a similar issue. I am executing a "select
>>> count" query using the avp_db_query function, but it is not storing the
>>> results in any avp. Other queries are working fine. I use db_mysql
>>> connected with a mysql 5.1 server.
>>>=20
>>> I have tested this with kamailio-3.1.0 and kamailio-3.1.3, both didn't
>>> work. In an old box (version 1.3.x), the same query was returning the
>>> correct value.
>>>=20
>>> ---------------------------------------------------
>>> Here is the case which is not working:
>>>=20
>>> Code:
>>> avp_delete("$avp(s:count)");
>>> $var(ret) =3D avp_db_query("SELECT count(*) FROM subscriber where
>>> username=3D'foo'", "$avp(s:count)");
>>> xlog("L_INFO", "var(ret)=3D$var(ret) avp(s:count)=3D$avp(s:count)");
>>>=20
>>>=20
>>> Output:
>>> INFO:<script>: var(ret)=3D1 avp(s:count)=3D<null>
>>>=20
>>> (notice the return code 1, which means that the query was successfull and
>>> there should be some output value stored in the avp, but it is<null>)
>> The return type of the COUNT() function is a BIGINT, which is ignored in
>> kamailio. The attached patch converts the lower 32 bits of the result to an
>> int usable by kamailio. I'll push this eventually.
> Thanks for quick reaction and patch. Go ahead and commit it.
>=20
> Cheers,
> Daniel
>=20
> --=20
> Daniel-Constantin Mierla -- http://www.asipto.com
> http://linkedin.com/in/miconda -- http://twitter.com/miconda
>=20
>=20
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users(a)lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


--===============1509750004==--


From Ricardo.Keigo@br.bosch.com Tue Jul  5 12:07:17 2011
From: "Andrade Ricardo (CI/AFU1)" <Ricardo.Keigo@br.bosch.com>
To: sr-users@lists.kamailio.org
Subject:
 Re: [SR-Users] "select count(*)" with avp_db_query always returns null
Date: Tue, 05 Jul 2011 12:07:07 +0200
Message-ID: <268C7AED54EDF64F808B167324D2CBF91A081E3134@SI-MBX18.de.bosch.com>
In-Reply-To: <4E12DE94.6070400@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1869427181=="

--===============1869427181==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi Daniel,
Hi Alex,

Thanks! That looks great. Once commited, I'll test it, too.

By the way, I've just tried with sql_query. It didn't work as well. Do you th=
ink it is fixed together with Alex's change?

Shouldn't there be a warning/error message if the returned data type is not s=
upported?


Code:
        sql_query("openserdb", "SELECT count(*) FROM subscriber where usernam=
e=3D'foo'", "ra");
        $avp(s:value) =3D $dbr(ra=3D>[0,0]);
        xlog("L_INFO", "avp(s:value)=3D$avp(s:value)\n");
          sql_result_free("ra");

Output:
          avp(s:value)=3D


Mit freundlichen Gr=C3=BC=C3=9Fen / Best regards

Ricardo Keigo de Sales Andrade

Robert Bosch GmbH
 (CI/AFU)
Postfach 30 02 20
70442 Stuttgart
GERMANY
www.bosch.com

Tel. +49(711)811-3607004
Mobil +49(172)1081152
ricardo.andrade(a)br.bosch.com

Sitz: Stuttgart, Registergericht: Amtsgericht Stuttgart, HRB 14000;
Aufsichtsratsvorsitzender: Hermann Scholl; Gesch=C3=A4ftsf=C3=BChrung: Franz =
Fehrenbach, Siegfried Dais;
Stefan Asenkerschbaumer, Bernd Bohr, Rudolf Colm, Volkmar Denner, Wolfgang Ma=
lchow, Peter Marks, Uwe Raschke, Wolf-Henning Scheider, Peter Tyroller


-----Urspr=C3=BCngliche Nachricht-----
Von: Daniel-Constantin Mierla [mailto:miconda(a)gmail.com]
Gesendet: Dienstag, 5. Juli 2011 11:51
An: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mail=
ing List
Cc: Alex Hermann; Andrade Ricardo (CI/AFU1)
Betreff: Re: [SR-Users] "select count(*)" with avp_db_query always returns nu=
ll



On 7/5/11 11:39 AM, Alex Hermann wrote:
> On Wednesday 29 June 2011, Andrade Ricardo (CI/AFU1) wrote:
>> Perhaps this fits better into a bug report, but I'd like to know if
>> somebody out there experienced a similar issue. I am executing a "select
>> count" query using the avp_db_query function, but it is not storing the
>> results in any avp. Other queries are working fine. I use db_mysql
>> connected with a mysql 5.1 server.
>>
>> I have tested this with kamailio-3.1.0 and kamailio-3.1.3, both didn't
>> work. In an old box (version 1.3.x), the same query was returning the
>> correct value.
>>
>> ---------------------------------------------------
>> Here is the case which is not working:
>>
>> Code:
>> avp_delete("$avp(s:count)");
>> $var(ret) =3D avp_db_query("SELECT count(*) FROM subscriber where
>> username=3D'foo'", "$avp(s:count)");
>> xlog("L_INFO", "var(ret)=3D$var(ret) avp(s:count)=3D$avp(s:count)");
>>
>>
>> Output:
>> INFO:<script>: var(ret)=3D1 avp(s:count)=3D<null>
>>
>> (notice the return code 1, which means that the query was successfull and
>> there should be some output value stored in the avp, but it is<null>)
> The return type of the COUNT() function is a BIGINT, which is ignored in
> kamailio. The attached patch converts the lower 32 bits of the result to an
> int usable by kamailio. I'll push this eventually.
Thanks for quick reaction and patch. Go ahead and commit it.

Cheers,
Daniel

--
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda



--===============1869427181==--


From miconda@gmail.com Tue Jul  5 12:13:54 2011
From: Daniel-Constantin Mierla <miconda@gmail.com>
To: sr-users@lists.kamailio.org
Subject:
 Re: [SR-Users] "select count(*)" with avp_db_query always returns null
Date: Tue, 05 Jul 2011 12:13:46 +0200
Message-ID: <4E12E3DA.6000001@gmail.com>
In-Reply-To: <5C4FE26A-5490-41FA-8088-F4117AD789FB@evaristesys.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0608734318=="

--===============0608734318==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable



On 7/5/11 12:04 PM, Alex Balashov wrote:
> Does sqlops handle bigint these days? It's the same srdb1 API for Pg as avp=
_db_query(), right? So perhaps that's the wrong question.

sqlops handle bigint but looking in the code it converts it to string.=20
Then it can be converted to int via transformation {s.int}. Hmm, wonder=20
which is the better approach...

The difference is that avp_query() stores directly the result values in=20
avps, while sqlops uses an internal structure which is accessed by=20
$dbr(...) variables. For now it tries to convert to int/string, but it=20
is more flexible overall.

Cheers,
Daniel

>
> --
> Alex Balashov - Principal
> Evariste Systems LLC
> 260 Peachtree Street NW
> Suite 2200
> Atlanta, GA 30303
> Tel: +1-678-954-0670
> Fax: +1-404-961-1892
> Web: http://www.evaristesys.com/
>
> On Jul 5, 2011, at 5:51 AM, Daniel-Constantin Mierla<miconda(a)gmail.com>  =
wrote:
>
>>
>> On 7/5/11 11:39 AM, Alex Hermann wrote:
>>> On Wednesday 29 June 2011, Andrade Ricardo (CI/AFU1) wrote:
>>>> Perhaps this fits better into a bug report, but I'd like to know if
>>>> somebody out there experienced a similar issue. I am executing a "select
>>>> count" query using the avp_db_query function, but it is not storing the
>>>> results in any avp. Other queries are working fine. I use db_mysql
>>>> connected with a mysql 5.1 server.
>>>>
>>>> I have tested this with kamailio-3.1.0 and kamailio-3.1.3, both didn't
>>>> work. In an old box (version 1.3.x), the same query was returning the
>>>> correct value.
>>>>
>>>> ---------------------------------------------------
>>>> Here is the case which is not working:
>>>>
>>>> Code:
>>>> avp_delete("$avp(s:count)");
>>>> $var(ret) =3D avp_db_query("SELECT count(*) FROM subscriber where
>>>> username=3D'foo'", "$avp(s:count)");
>>>> xlog("L_INFO", "var(ret)=3D$var(ret) avp(s:count)=3D$avp(s:count)");
>>>>
>>>>
>>>> Output:
>>>> INFO:<script>: var(ret)=3D1 avp(s:count)=3D<null>
>>>>
>>>> (notice the return code 1, which means that the query was successfull and
>>>> there should be some output value stored in the avp, but it is<null>)
>>> The return type of the COUNT() function is a BIGINT, which is ignored in
>>> kamailio. The attached patch converts the lower 32 bits of the result to =
an
>>> int usable by kamailio. I'll push this eventually.
>> Thanks for quick reaction and patch. Go ahead and commit it.
>>
>> Cheers,
>> Daniel
>>
>> --=20
>> Daniel-Constantin Mierla -- http://www.asipto.com
>> http://linkedin.com/in/miconda -- http://twitter.com/miconda
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users(a)lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users(a)lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

--=20
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda



--===============0608734318==--


From miconda@gmail.com Tue Jul  5 12:21:13 2011
From: Daniel-Constantin Mierla <miconda@gmail.com>
To: sr-users@lists.kamailio.org
Subject:
 Re: [SR-Users] "select count(*)" with avp_db_query always returns null
Date: Tue, 05 Jul 2011 12:21:05 +0200
Message-ID: <4E12E591.7080303@gmail.com>
In-Reply-To:
 <268C7AED54EDF64F808B167324D2CBF91A081E3134@SI-MBX18.de.bosch.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1998168618=="

--===============1998168618==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hello,

On 7/5/11 12:07 PM, Andrade Ricardo (CI/AFU1) wrote:
> Hi Daniel,
> Hi Alex,
>
> Thanks! That looks great. Once commited, I'll test it, too.
>
> By the way, I've just tried with sql_query. It didn't work as well. Do you =
think it is fixed together with Alex's change?
>
> Shouldn't there be a warning/error message if the returned data type is not=
 supported?
>
>
> Code:
>          sql_query("openserdb", "SELECT count(*) FROM subscriber where user=
name=3D'foo'", "ra");
>          $avp(s:value) =3D $dbr(ra=3D>[0,0]);
>          xlog("L_INFO", "avp(s:value)=3D$avp(s:value)\n");
>            sql_result_free("ra");
>
> Output:
>            avp(s:value)=3D
interesting, I just looked in the code and bigints should be converted=20
to string values. Can you test if ($dbr(ra=3D>rows) >0) to be sure there=20
was a row returned by the query.

Cheers,
Daniel

--=20
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda



--===============1998168618==--


From Ricardo.Keigo@br.bosch.com Tue Jul  5 12:30:27 2011
From: "Andrade Ricardo (CI/AFU1)" <Ricardo.Keigo@br.bosch.com>
To: sr-users@lists.kamailio.org
Subject:
 Re: [SR-Users] "select count(*)" with avp_db_query always returns null
Date: Tue, 05 Jul 2011 12:30:19 +0200
Message-ID: <268C7AED54EDF64F808B167324D2CBF91A081E3170@SI-MBX18.de.bosch.com>
In-Reply-To: <4E12E591.7080303@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1134846469=="

--===============1134846469==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi Daniel,

Code:
        sql_query("openserdb", "SELECT count(*) FROM subscriber where usernam=
e=3D'foo'", "ra");
        $avp(s:value) =3D $dbr(ra=3D>[0,0]);
        xlog("L_INFO", "avp(s:value)=3D$avp(s:value) (avp(s:value){s.int})=3D=
$(avp(s:value){s.int}) dbr(ra=3D>rows)=3D$dbr(ra=3D>rows)");
        sql_result_free("ra");

Output:
avp(s:value)=3D (avp(s:value){s.int})=3D dbr(ra=3D>rows)=3D1


I am testing only with kamailio-3.1.0 right now.

Mit freundlichen Gr=C3=BC=C3=9Fen / Best regards

Ricardo Keigo de Sales Andrade

Robert Bosch GmbH
 (CI/AFU)
Postfach 30 02 20
70442 Stuttgart
GERMANY
www.bosch.com

Tel. +49(711)811-3607004
Mobil +49(172)1081152
ricardo.andrade(a)br.bosch.com

Sitz: Stuttgart, Registergericht: Amtsgericht Stuttgart, HRB 14000;
Aufsichtsratsvorsitzender: Hermann Scholl; Gesch=C3=A4ftsf=C3=BChrung: Franz =
Fehrenbach, Siegfried Dais;
Stefan Asenkerschbaumer, Bernd Bohr, Rudolf Colm, Volkmar Denner, Wolfgang Ma=
lchow, Peter Marks, Uwe Raschke, Wolf-Henning Scheider, Peter Tyroller


-----Urspr=C3=BCngliche Nachricht-----
Von: Daniel-Constantin Mierla [mailto:miconda(a)gmail.com]
Gesendet: Dienstag, 5. Juli 2011 12:21
An: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mail=
ing List
Cc: Andrade Ricardo (CI/AFU1)
Betreff: Re: [SR-Users] "select count(*)" with avp_db_query always returns nu=
ll

Hello,

On 7/5/11 12:07 PM, Andrade Ricardo (CI/AFU1) wrote:
> Hi Daniel,
> Hi Alex,
>
> Thanks! That looks great. Once commited, I'll test it, too.
>
> By the way, I've just tried with sql_query. It didn't work as well. Do you =
think it is fixed together with Alex's change?
>
> Shouldn't there be a warning/error message if the returned data type is not=
 supported?
>
>
> Code:
>          sql_query("openserdb", "SELECT count(*) FROM subscriber where user=
name=3D'foo'", "ra");
>          $avp(s:value) =3D $dbr(ra=3D>[0,0]);
>          xlog("L_INFO", "avp(s:value)=3D$avp(s:value)\n");
>            sql_result_free("ra");
>
> Output:
>            avp(s:value)=3D
interesting, I just looked in the code and bigints should be converted
to string values. Can you test if ($dbr(ra=3D>rows) >0) to be sure there
was a row returned by the query.

Cheers,
Daniel

--
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda



--===============1134846469==--