You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2006/04/27 01:41:03 UTC
[jira] Created: (DERBY-1258) Wrong value returned in a row trigger
action statement if the table has column names that are identical when
upper-cased.
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
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
[jira] Assigned: (DERBY-1258) Wrong value returned in a row trigger
action statement if the table has column names that are identical when
upper-cased.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1258?page=all ]
Daniel John Debrunner reassigned DERBY-1258:
--------------------------------------------
Assign To: Daniel John Debrunner
> 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
>
> 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
[jira] Resolved: (DERBY-1258) Wrong value returned in a row trigger
action statement if the table has column names that are identical when
upper-cased.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1258?page=all ]
Daniel John Debrunner resolved DERBY-1258:
------------------------------------------
Fix Version: 10.2.0.0
Resolution: Fixed
Fixed & tested.
> 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
[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.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ 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