Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 88967 invoked from network); 26 Jan 2008 16:10:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Jan 2008 16:10:06 -0000 Received: (qmail 74801 invoked by uid 500); 26 Jan 2008 16:09:57 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 74583 invoked by uid 500); 26 Jan 2008 16:09:56 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 74574 invoked by uid 99); 26 Jan 2008 16:09:56 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 26 Jan 2008 08:09:56 -0800 X-ASF-Spam-Status: No, hits=-99.8 required=10.0 tests=ALL_TRUSTED,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 26 Jan 2008 16:09:42 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 1D4E0714264 for ; Sat, 26 Jan 2008 08:09:35 -0800 (PST) Message-ID: <14238935.1201363775117.JavaMail.jira@brutus> Date: Sat, 26 Jan 2008 08:09:35 -0800 (PST) From: "Dyre Tjeldvoll (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Resolved: (DERBY-3343) Subsequent calls to PreparedStatement cause SQLIntegrityConstraintViolationException on column that is "Generated always" In-Reply-To: <33509235.1201058074124.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dyre Tjeldvoll resolved DERBY-3343. ----------------------------------- Resolution: Fixed > Subsequent calls to PreparedStatement cause SQLIntegrityConstraintViolationException on column that is "Generated always" > -------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-3343 > URL: https://issues.apache.org/jira/browse/DERBY-3343 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.3.2.1 > Environment: gentoo linux amd64 > Reporter: William Becker > Assignee: Dyre Tjeldvoll > Fix For: 10.3.2.2, 10.4.0.0 > > Attachments: d3343.diff, d3343.v2.diff, d3343.v3.diff, defaults.sql > > > The following series of statements fails: > j> connect 'jdbc:derby:test;create=true'; > ij> create table t (id int primary key generated always as identity); > 0 rows inserted/updated/deleted > ij> prepare p as 'insert into t(id) values (default)'; > ij> execute p; > 1 row inserted/updated/deleted > ij> execute p; > ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL080123140906700' defined on 'T'. > There is a more detailed discussion about it here: http://www.nabble.com/Generate-Always-and-SQLIntegrityConstraintViolationException-td15012038.html#a15018054 -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.