db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2902) AS IDENTITY (START WITH -9223372036854775808) fails
Date Mon, 09 Jul 2007 23:32:04 GMT

    [ 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.


Mime
View raw message