[sr-dev] [tracker] Comment added: no avpops bigint handling breaks custom select queries

[sip-router]

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY.

The following task has a new comment added:

FS#193 - no avpops bigint handling breaks custom select queries
User who did this - Walter Doekes (wdoekes)

----------
> AFAIK mysql does not support casting from bigint to int

Indeed, when figuring out what was broken, I tried the CAST(.. UNSIGNED / TINYINT) but it all failed. First the cast to CHAR returned something usable.

> Or alternative, modparam for avpops (and eventually sqlops) to control the handling of bigints returned by mysql:

I like that option. It introduces a place to document reasons for one or the other. ("Are you using big numbers? Use the string. Are you just affected by mysql automatic type selection in dynamic column values? Choose int.")
----------

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

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.