|
The scale should be 0 for the column generated for a property of type java.sql.Types.BIGINT. Currently, the default is 2.
Making this change will fix problems with SQL Server sequences of type bigint. By default, a bigint sequence ranges from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
By default, the first sequence value returned by SQL Server is -9,223,372,036,854,775,808. With the current default scale (of 2), SQL Server throws: com.microsoft.sqlserver.jdbc.SQLServerException: Arithmetic overflow error converting numeric to data type numeric.
See HHH-9250 for more details of the failure on SQL Server. The fix for HHH-9250 simply changes the mapping for a test that fails using SQL Server to explicitly set scale="0" as a workaround.
|
