[ http://issues.apache.org/jira/browse/DERBY-1574?page=comments#action_12423449 ] A B commented on DERBY-1574: ----------------------------
> Here is the stack from the original problem against the trunk showing that > the issue is in the optimizer: For the record, I ran the simple repro against an early version of 10.1(10.1.2.3) and also against 10.0, and the NPE reproduces for both of those codelines, as well. So in case anyone is wondering (I know I was), this is *not* a regression. For what that's worth... > NullPointerException in UPDATE with COALESCE and subquery > --------------------------------------------------------- > > Key: DERBY-1574 > URL: http://issues.apache.org/jira/browse/DERBY-1574 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.1.3.1 > Environment: Java 1.5.0_06 > Reporter: Christian d'Heureuse > Priority: Minor > > The following statements generate a NullPointerException: > CREATE TABLE t1 (i INTEGER); > CREATE TABLE t2 (i INTEGER); > UPDATE t1 > SET i = COALESCE( > (SELECT i FROM t2 WHERE t2.i=t1.i), > 0); > Any further SQL statements generate an internal error in RawStore, e.g.: > SELECT * FROM t1; -- 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
