[
https://issues.apache.org/jira/browse/DERBY-3177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543147
]
Bryan Pendleton commented on DERBY-3177:
----------------------------------------
Charlie, what do you think is the status of this issue at this point? In my
environment,
the DERBY-3175 patch makes the bug2.sql script run correctly, so my feeling is
that
we should mark this issue as a resolved duplicate of DERBY-3175.
However, in one of your comments to DERBY-3175
( https://issues.apache.org/jira/browse/DERBY-3175#action_12541670 )
you indicated that you are still seeing problems even after the DERBY-3175 fix.
Can you provide a repro script that demonstrates those problems?
Please let us know what you think would be best to do regarding this JIRA issue.
> Dropping columns casues auto_increment field to be lost
> -------------------------------------------------------
>
> Key: DERBY-3177
> URL: https://issues.apache.org/jira/browse/DERBY-3177
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.4
> Environment: Windows XP SP2
> JVM: Hotspot JVM 1.6
> Derby: 10.3.1000004.561794
> Reporter: Charlie Hubbard
> Assignee: Bryan Pendleton
> Attachments: bug2.sql, migration-bug.sql
>
>
> I have a DB that I've been updating over time, and I've run into this bug.
> After running this script Messages.ID table looses it's auto incrementing
> column after running the script to completion. If I create a virgin DB and
> run this script against the Message table's ID column looses it's auto
> increment data type. If you comment out the last three alter table
> statements the column's auto increment feature is not lost. You don't have
> to insert any data into the database for this to happen.
> I tried creating a simpler script to expose this problem, but was
> unsuccessful. I tried something like:
> create table Messages (
> Name varchar(256),
> KillThis varchar(256),
> id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT
> BY 1),
> CONSTRAINT MESSAGES_id_pk PRIMARY KEY(id)
> );
> alter table Messages drop column KillThis;
> However, this DID NOT EXPOSE THE BUG. So there is something else at work
> causing this problem. See the attached script to recreate the problem.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
