[SR-Users] "select count(*)" with avp_db_query always returns null

[Alex Balashov]

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.

--
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 at 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) = 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
> 
> 
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users