Hi
I'm chasing an issue where I have a mysql column of type int NOT NULL
In MySQL this is a signed integer.
In some cases this column can be negative for example -1
I read this column with sql_xquery
I end up with 18446744073709551615
That is the unsigned equivalent of 2^64-1 - so kamailio uses SIGNED int?
Is there a way to change this to unsigned or to read have sql_xquery convert the value to a string?
Mit freundlichen Grüssen
-Benoît Panizzon-
Hi
I wonder if I shall open a bugreport or if this is just a documentation issue of the sqlops module.
After also re-testing with Kamailio 5.7 I can confirm that there a MySQL integer of value -1 is also being "converted" by sqlops from signed to unsigned and results in the variable having value 4294967295 which shows that 5.7 works with 32 bit unsigned int while 5.8 works with 64 bit unsigned int.
Is this intentional or a bug?
Mit freundlichen Grüssen
-Benoît Panizzon-
Hello,
it should be signed int (older versions) or long (newer versions). Can you give the snippet of the kamailio.cfg where you do the query and use the result that prints the unsigned value?
Cheers, Daniel
On 02.09.25 15:02, Benoit Panizzon via sr-users wrote:
Hi
I wonder if I shall open a bugreport or if this is just a documentation issue of the sqlops module.
After also re-testing with Kamailio 5.7 I can confirm that there a MySQL integer of value -1 is also being "converted" by sqlops from signed to unsigned and results in the variable having value 4294967295 which shows that 5.7 works with 32 bit unsigned int while 5.8 works with 64 bit unsigned int.
Is this intentional or a bug?
Mit freundlichen Grüssen
-Benoît Panizzon-
I m p r o W a r e A G - Leiter Commerce Kunden ______________________________________________________
Zurlindenstrasse 29 Tel +41 61 826 93 00 CH-4133 Pratteln Fax +41 61 826 93 01 Schweiz Web http://www.imp.ch ______________________________________________________ __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions -- sr-users@lists.kamailio.org To unsubscribe send an email to sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender!
-
Benoit Panizzon -
Daniel-Constantin Mierla