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

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.