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
