[Kamailio-Devel] BIGINT MySQL problems in 1.5.0.

Alex Balashov abalashov at evaristesys.com
Fri Apr 3 07:54:48 CEST 2009


I just installed 1.5.0 and wired it up to a MySQL 5.0.x database, and it 
appears that I am getting empty/null values for BIGINT columns when 
accessing them from script.

This is true when I do something like this with SQLOps, for example:

    sql_query("test", "SELECT someBigIntColumn FROM tbl", "ra");

    $var(i) = $dbr(ra=>[0,0]);

$var(i) will have an empty value.

Same will be the case if the access subscript is not [0,0] but say, [0,1].

The problem does not seem to be specific to sqlops;  the same occurs 
with AVPs:

   avp_db_query("SELECT someBigIntColumn FROM tbl", "$avp(S:bigInt)");

This is also empty.

I did a debug and confirmed that the right value for someBigIntColumn is 
coming out of the database, and has the right data type.  All that works 
fine.  However, for some reason this value appears to be invisible 
within the evaluative scope of the route script.

For now, I am working around it by doing CONVERT(someBigIntColumn, 
CHAR(20)) inside the query.  However, in principle this means that 
BIGINT handling is broken.

Has anyone else run into this?  Any insights, or especially, solutions?

Alex Balashov
Evariste Systems
Web    : http://www.evaristesys.com/
Tel    : (+1) (678) 954-0670
Direct : (+1) (678) 954-0671
Mobile : (+1) (678) 237-1775

More information about the Devel mailing list