[sr-dev] [tracker] Task opened: no avpops bigint handling breaks custom select queries (Attachment added)

[sip-router]

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY.

A new Flyspray task has been opened.  Details are below. 

User who did this - Walter Doekes (wdoekes) 

Attached to Project - sip-router
Summary - no avpops bigint handling breaks custom select queries
Task Type - Bug Report
Category - libsrdb1 (kamailio)
Status - Assigned
Assigned To - Henning Westerholt
Operating System - All
Severity - Medium
Priority - Normal
Reported Version - Development
Due in Version - Undecided
Due Date - Undecided
Details - Hi,

If I do this query:

avp_query("SELECT 1, id, IFNULL(id, 3) FROM sometable WHERE id = 1", "$avp(val1),$avp(val2),$avp(val3)");

I expect these values in val1..val3:
1 1 1

However, I get these values:
<null> 1 <null>

This is because there is not DB1_BIGINT handling in avpops_db.c. Only the 'id' fields gets read correctly, because it is of type integer (32bits).

I'm using avpops.so and db_mysql.so on 3.2.x.


Attached patch fixes that it works. But it won't fix actual bigint handling for numbers larger than 32bit on systems where sizeof(int) < 8.

Regards,
Walter Doekes
OSSO B.V.

One or more files have been attached.

More information can be found at the following URL:
http://sip-router.org/tracker/index.php?do=details&task_id=193

You are receiving this message because you have requested it from the Flyspray bugtracking system.  If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above.