[DERBY-2902] AS IDENTITY (START WITH -9223372036854775808) fails

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4
• Fix Version/s: 10.3.2.1, 10.4.1.3
• Component/s: SQL
• Environment: MacTel 10.4.10 JVM 1.6.0-dp
• Assignee: Bryan Pendleton
• Reporter: James Alan Shepherd
• Created: 05/Jul/07 13:44
• Updated: 21/Jan/11 17:50
• Resolved: 12/Aug/07 15:09

Description

When creating a table

AS IDENTITY (START WITH -9223372036854775808)

fails but

AS IDENTITY (START WITH -9223372036854775807)

succeeds.

Guess this is a parsing SQL problem as the absolute value appears to be held in a long, which is not quite long enough at the positive end.