db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5274) getColumns() doesn't work with auto generated identity columns that start with large numbers
Date Thu, 16 Jun 2011 11:13:47 GMT

     [ https://issues.apache.org/jira/browse/DERBY-5274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Knut Anders Hatlen updated DERBY-5274:
--------------------------------------

    Issue & fix info:   (was: [Patch Available])
       Fix Version/s: 10.9.0.0

I plan to back-port the fix to the 10.8 branch. Then we'll need to bump the version number
on the branch so that the upgrade code is triggered and invalidates the old, incorrect meta-data
query in applications that already use head of the 10.8 branch.

> getColumns() doesn't work with auto generated identity columns that start with large
numbers
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-5274
>                 URL: https://issues.apache.org/jira/browse/DERBY-5274
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.7.1.1
>         Environment: Linux 10.3.
>            Reporter: Tony Brusseau
>            Assignee: Knut Anders Hatlen
>            Priority: Critical
>             Fix For: 10.9.0.0
>
>         Attachments: derby-5274-1a-getColumns.diff, derby-5274-1b-getColumns.diff, derby-5274-1c-getColumns.diff
>
>
> CREATE TABLE kb.constant_term
> (
>         term_id                 BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH
648518346341351400, INCREMENT BY 1),
>         constant_name      VARCHAR(1024) NOT NULL
> );
> The above SQL causes the table to be created but no columns to be defined (no error message
is reported). If I change  648518346341351400 to a 0, then the table is created normally with
all the columns defined correctly.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message