Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 19381 invoked from network); 28 Apr 2006 18:13:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 28 Apr 2006 18:13:17 -0000 Received: (qmail 91106 invoked by uid 500); 28 Apr 2006 18:13:09 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 90974 invoked by uid 500); 28 Apr 2006 18:13:09 -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 90739 invoked by uid 99); 28 Apr 2006 18:13:08 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Apr 2006 11:13:08 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [209.237.227.198] (HELO brutus.apache.org) (209.237.227.198) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Apr 2006 11:13:07 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 556E77142EA for ; Fri, 28 Apr 2006 18:12:42 +0000 (GMT) Message-ID: <19560389.1146247962347.JavaMail.jira@brutus> Date: Fri, 28 Apr 2006 18:12:42 +0000 (GMT+00:00) From: "Daniel John Debrunner (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Closed: (DERBY-1258) Wrong value returned in a row trigger action statement if the table has column names that are identical when upper-cased. In-Reply-To: <78504469.1146094863786.JavaMail.root@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 X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/DERBY-1258?page=all ] Daniel John Debrunner closed DERBY-1258: ---------------------------------------- > Wrong value returned in a row trigger action statement if the table has column names that are identical when upper-cased. > ------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-1258 > URL: http://issues.apache.org/jira/browse/DERBY-1258 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.2.0.0, 10.1.2.0, 10.1.1.1, 10.1.1.2, 10.1.2.1, 10.1.2.2, 10.1.2.3 > Reporter: Daniel John Debrunner > Assignee: Daniel John Debrunner > Fix For: 10.2.0.0 > > If the triggered table has columns I and "i" then any reference to these columns in the action statement for the old or new row will return the value for the first column in the table .with the matching name in upper-case. > > ij> create table tsn (I integer, "i" integer); > > 0 rows inserted/updated/deleted > > ij> create table tsn_t (a integer, b integer); > > 0 rows inserted/updated/deleted > > ij> create trigger tr_sn after insert on tsn > > referencing new as n > > for each row mode db2sql > > insert into tsn_t(a, b) values (n.I, n."i"); > > 0 rows inserted/updated/deleted > > ij> insert into tsn values (1, 234); > > 1 row inserted/updated/deleted > > ij> select * from tsn; > > I |i > > ----------------------- > > 1 |234 > > ij> select * from tsn_t; > > A |B > > ----------------------- > > 1 |1 > See http://wiki.apache.org/db-derby/TriggerImplementation > Test case above will be added to triggerGeneral.sql commented with this bug number. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira