I have an unsigned SMALLINT column in my MySQL database. Querying via Ignition doesn’t work because it’s using java.lang.Short which only supports the range for a signed value.
Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Value '42222' is outside of valid range for type java.lang.Short
Hm. Unsigned smallint appears to be a vendor extension we/Java didn't anticipate, especially since Java doesn't have native unsigned types.
We might be able to do something about it, but it won't be any time soon...
Just change the type to INT?
It’s not really a problem for my current use case. Our acceptable values won’t actually be over 32,000 so I can just validate against that instead of changing the type.