Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 25695 invoked from network); 5 Nov 2007 16:04:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 5 Nov 2007 16:04:38 -0000 Received: (qmail 74614 invoked by uid 500); 5 Nov 2007 16:02:23 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 74587 invoked by uid 500); 5 Nov 2007 16:02:23 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 74570 invoked by uid 99); 5 Nov 2007 16:02:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Nov 2007 08:02:23 -0800 X-ASF-Spam-Status: No, hits=-1.0 required=10.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.18.6.21] (HELO gmp-eb-mail-1.sun.com) (192.18.6.21) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Nov 2007 16:02:26 +0000 Received: from fe-emea-10.sun.com (gmp-eb-lb-2-fe3.eu.sun.com [192.18.6.12]) by gmp-eb-mail-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id lA5G24TL002017 for ; Mon, 5 Nov 2007 16:02:04 GMT Received: from conversion-daemon.fe-emea-10.sun.com by fe-emea-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JR100F01IHQWU00@fe-emea-10.sun.com> (original mail from Dag.Wanvik@Sun.COM) for derby-user@db.apache.org; Mon, 05 Nov 2007 16:02:04 +0000 (GMT) Received: from khepri23.norway.sun.com ([129.159.112.235]) by fe-emea-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JR100KHTJ7BZV20@fe-emea-10.sun.com> for derby-user@db.apache.org; Mon, 05 Nov 2007 16:02:00 +0000 (GMT) Date: Mon, 05 Nov 2007 17:01:59 +0100 From: Dag.Wanvik@Sun.COM (Dag H. Wanvik) Subject: Re: Dropping columns casues auto_increment field to get lost In-reply-to: Sender: Dag.Wanvik@Sun.COM To: Derby Discussion Message-id: MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT References: User-Agent: Gnus/5.1008 (Gnus v5.10.8) Emacs/22.1 (usg-unix-v) X-Virus-Checked: Checked by ClamAV on apache.org Charlie Hubbard writes: > Hi, > > I have a DB that I've been updating over time, and I've run into what > appears to be a bug. Not totally sure though. After running this > script Messages.ID table looses it's auto incrementing column after > running the script to completion. If you comment out the last three > alter table statements the column's auto increment feature is not > lost. > > I'm running DB 10.3.1000004.561794 > > Any ideas what's causing this problem? Sounds related to https://issues.apache.org/jira/browse/DERBY-1645 but I though that was fixed in 10.3? Dag