Generated sequences shouldn't be typed BIGINT by default, if MAXVALUE is larger than Long.MAX_VALUE

[lukaseder]

Some RDBMS don't support typed sequences. They're all DECIMAL(x, 0) typed and the value range depends on the MINVALUE and MAXVALUE flags. For example, in HANA, this range is -9999999999999999999999999999 to 9999999999999999999999999999 (28 digits, i.e. DECIMAL(28, 0).

• See https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/20d509277519101489029c064d468c5d.html

The code generator should produce the appropriate type for the respective range, e.g. (in HANA):

• TINYINT for (0, 255)
• SMALLINT for (Short.MIN_VALUE, Short.MAX_VALUE)
• INTEGER for (Integer.MIN_VALUE, Integer.MAX_VALUE)
• BIGINT for (Long.MIN_VALUE, Long.MAX_VALUE)
• DECIMAL(x, 0) for the rest

This affects these dialects:

• HANA

List to be amended