[
https://issues.apache.org/jira/browse/DERBY-2902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12511289
]
Bryan Pendleton commented on DERBY-2902:
----------------------------------------
Hi Knut Anders, thanks for the suggestion. That would indeed be clearer, but
unfortunately Long.parseLong() doesn't support a leading "+" sign in its
allowable formats, only a leading "-" sign. So unfortunately if we always
pass the sign to Long.parseLong, the following statement is rejected:
create table t (a2 int generated always as identity (start with +0));
I'll add a comment to the code indicating this.
> AS IDENTITY (START WITH -9223372036854775808) fails
> ---------------------------------------------------
>
> Key: DERBY-2902
> URL: https://issues.apache.org/jira/browse/DERBY-2902
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.2.2.0
> Environment: MacTel 10.4.10 JVM 1.6.0-dp
> Reporter: James Alan Shepherd
> Assignee: Bryan Pendleton
> Priority: Minor
> Attachments: parseLong.diff
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
