[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 - Daniel-Constantin Mierla (miconda)

----------
I see the points in your situation, but for generic case, casting big int to int can result in truncation. So if one wants to do it, better do it on demand in the config (note that it is memory operations, barely affects performances). Many can use it just to add it to headers or print it, which is just fine when kept as string in avp, as opposite to have a truncated value, without any control on it.

For your case casting should do the job, but AFAIK mysql does not support casting from bigint to int, but you can write a small function to do that - take big int as parameter and just return it back as int.


----------

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

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.