BIGINT provides 8 bytes of storage for integer values.
java.lang.Long
BIGINT
-9223372036854775808 (java.lang.Long.MIN_VALUE)
9223372036854775807 (java.lang.Long.MAX_VALUE)
When mixed with other data types
in expressions, the resulting data type follows the rules shown in
An attempt to put an integer value of a larger storage size into a location of a smaller size fails if the value cannot be stored in the smaller-size location. Integer types can always successfully be placed in approximate numeric values, although with the possible loss of some precision. BIGINTs can be stored in DECIMALs if the DECIMAL precision is large enough for the value.