[OpenSIPS-Users] MySQL Type: FIELD_TYPE_NEWDECIMAL (246) uses DB_INT result type but should use float

[Liviu Chircu]

On 10.03.2020 00:25, Calvin Ellison wrote:
> I also noticed DB_DOUBLE is missing from /avpops/avpops_db.c but I 
> don't know C well enough to do the needful. Do you know what should be 
> done to make it a string?
>
> Here's my updated /db_mysql/res.c. I did as you suggested and 
> moved MYSQL_TYPE_NEWDECIMAL along with its #if condition to just after 
> MYSQL_TYPE_FLOAT so it is DB_DOUBLE not DB_INT. It looks like the same 
> change is needed for MYSQL_TYPE_DECIMAL since this can also be 
> non-integer, but I didn't touch that.

Hello, Calvin/Brett!

You guys are absolutely right, that definitely looks like a bug.  
Calvin, can you
please apply the below patch on a clean OpenSIPS tree and let me know if it
fixes your problem?  Thanks!

git apply <(base64 -d <<EOF
ZGlmZiAtLWdpdCBhL21vZHVsZXMvYXZwb3BzL2F2cG9wc19kYi5jIGIvbW9kdWxlcy9hdnBvcHMv
YXZwb3BzX2RiLmMKaW5kZXggNGZjNzQ3ZmI2Li40Yjk1M2U0ZWQgMTAwNjQ0Ci0tLSBhL21vZHVs
ZXMvYXZwb3BzL2F2cG9wc19kYi5jCisrKyBiL21vZHVsZXMvYXZwb3BzL2F2cG9wc19kYi5jCkBA
IC01NDQsNiArNTQ0LDEyIEBAIGludCBkYl9xdWVyeV9hdnBfcHJpbnRfcmVzdWx0cyhzdHJ1Y3Qg
c2lwX21zZyAqbXNnLCBjb25zdCBkYl9yZXNfdCAqZGJfcmVzLAogCQkJCQlhdnBfdmFsLm4gPQog
CQkJCQkJKGludClSRVNfUk9XUyhkYl9yZXMpW2ldLnZhbHVlc1tqXS52YWwuYmlnaW50X3ZhbDsK
IAkJCQlicmVhazsKKwkJCQljYXNlIERCX0RPVUJMRToKKwkJCQkJYXZwX3R5cGUgfD0gQVZQX1ZB
TF9TVFI7CisJCQkJCWF2cF92YWwucy5zID0gZG91YmxlMnN0cigKKwkJCQkJICAgICAgICBSRVNf
Uk9XUyhkYl9yZXMpW2ldLnZhbHVlc1tqXS52YWwuZG91YmxlX3ZhbCwKKwkJCQkJICAgICAgICAm
YXZwX3ZhbC5zLmxlbik7CisJCQkJYnJlYWs7CiAJCQkJZGVmYXVsdDoKIAkJCQkJTE1fV0FSTigi
VW5rbm93biB0eXBlICVkXG4iLAogCQkJCQkJUkVTX1JPV1MoZGJfcmVzKVtpXS52YWx1ZXNbal0u
dHlwZSk7CmRpZmYgLS1naXQgYS9tb2R1bGVzL2RiX215c3FsL3Jlcy5jIGIvbW9kdWxlcy9kYl9t
eXNxbC9yZXMuYwppbmRleCBiMjRjZmVjODkuLjE0NTBhNmQ0NSAxMDA2NDQKLS0tIGEvbW9kdWxl
cy9kYl9teXNxbC9yZXMuYworKysgYi9tb2R1bGVzL2RiX215c3FsL3Jlcy5jCkBAIC03NiwxMCAr
NzYsNiBAQCBpbnQgZGJfbXlzcWxfZ2V0X2NvbHVtbnMoY29uc3QgZGJfY29uX3QqIF9oLCBkYl9y
ZXNfdCogX3IpCiAJCQljYXNlIE1ZU1FMX1RZUEVfU0hPUlQ6CiAJCQljYXNlIE1ZU1FMX1RZUEVf
TE9ORzoKIAkJCWNhc2UgTVlTUUxfVFlQRV9JTlQyNDoKLQkJCWNhc2UgTVlTUUxfVFlQRV9ERUNJ
TUFMOgotCQkJI2lmIE1ZU1FMX1ZFUlNJT05fSUQgPiA0OTk5OQotCQkJY2FzZSBNWVNRTF9UWVBF
X05FV0RFQ0lNQUw6Ci0JCQkjZW5kaWYKIAkJCWNhc2UgTVlTUUxfVFlQRV9USU1FU1RBTVA6CiAJ
CQkJTE1fREJHKCJ1c2UgREJfSU5UIHJlc3VsdCB0eXBlXG4iKTsKIAkJCQlSRVNfVFlQRVMoX3Ip
W2NvbF0gPSBEQl9JTlQ7CkBAIC04Nyw2ICs4MywxMCBAQCBpbnQgZGJfbXlzcWxfZ2V0X2NvbHVt
bnMoY29uc3QgZGJfY29uX3QqIF9oLCBkYl9yZXNfdCogX3IpCiAKIAkJCWNhc2UgTVlTUUxfVFlQ
RV9GTE9BVDoKIAkJCWNhc2UgTVlTUUxfVFlQRV9ET1VCTEU6CisJCQljYXNlIE1ZU1FMX1RZUEVf
REVDSU1BTDoKKwkJCSNpZiBNWVNRTF9WRVJTSU9OX0lEID4gNDk5OTkKKwkJCWNhc2UgTVlTUUxf
VFlQRV9ORVdERUNJTUFMOgorCQkJI2VuZGlmCiAJCQkJTE1fREJHKCJ1c2UgREJfRE9VQkxFIHJl
c3VsdCB0eXBlXG4iKTsKIAkJCQlSRVNfVFlQRVMoX3IpW2NvbF0gPSBEQl9ET1VCTEU7CiAJCQkJ
YnJlYWs7CmRpZmYgLS1naXQgYS91dC5oIGIvdXQuaAppbmRleCA3ODIwZTZlODkuLmM0ZDQ4MWQ2
MyAxMDA2NDQKLS0tIGEvdXQuaAorKysgYi91dC5oCkBAIC0yODgsNiArMjg4LDE3IEBAIHN0YXRp
YyBpbmxpbmUgY2hhciogc2ludDJzdHIobG9uZyBsLCBpbnQqIGxlbikKIAlyZXR1cm4gcDsKIH0K
IAorc3RhdGljIGlubGluZSBjaGFyKiBkb3VibGUyc3RyKGRvdWJsZSBkLCBpbnQqIGxlbikKK3sK
KwlzdGF0aWMgaW50IGJ1ZjsKKworCWJ1ZiA9IChidWYgKyAxKSAlIElOVDJTVFJfQlVGX05POwor
CSpsZW4gPSBzbnByaW50ZihpbnQyc3RyX2J1ZltidWZdLCBJTlQyU1RSX01BWF9MRU4gLSAxLCAi
JWxmIiwgZCk7CisJaW50MnN0cl9idWZbYnVmXVsqbGVuXSA9ICdcMCc7CisKKwlyZXR1cm4gaW50
MnN0cl9idWZbYnVmXTsKK30KKwogCiAvKiBmYXN0ZXIgbWVtY2hyIHZlcnNpb24gKi8KIHN0YXRp
YyBpbmxpbmUgY2hhciogcV9tZW1jaHIoY2hhciogcCwgaW50IGMsIHVuc2lnbmVkIGludCBzaXpl
KQo=
EOF
)

Best regards,

-- 
Liviu Chircu
www.twitter.com/liviuchircu | www.opensips-solutions.com

OpenSIPS Summit, Amsterdam, May 2020
   www.opensips.org/events
OpenSIPS Bootcamp, Miami, March 2020
   www.opensips.org/training