Store integral data as BIGINT.
Summary
Integral numeric data should be stored as LONG, because sometimes people already start querying for numbers which are too large for 32 bit integers.
Possible fixes
- (Change the datatype of the
integer_data
table to BIGINT.) - Make sure that the server also sends and can receive BIGINTs.
- Make sure that all APIs and client libraries support 64 bit integers. (Queries excluded)