[
https://issues.apache.org/jira/browse/DERBY-3177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543325
]
Charlie Hubbard commented on DERBY-3177:
----------------------------------------
No problem! It's easy working with ya'll. I wouldn't have reverted the code
had I known ya'll were so on top of it. Most of the time issues are logged,
and they are never worked on so I just wanted to say thanks for being so
diligent. Logging is on, and eyes are peeled. :-)
> 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.
