[DERBY-5954] NPE in SELECT involving subselects and windows functions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2, 10.8.2.2, 10.9.1.0
• Fix Version/s: 10.8.3.3, 10.9.2.2, 10.10.1.1
• Component/s: SQL
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Regression, Seen in production
• Assignee: Dag H. Wanvik
• Reporter: Richard N. Hillegas
• Created: 17/Oct/12 13:40
• Updated: 25/Nov/12 20:14
• Resolved: 06/Nov/12 18:56

Description

A user reports and I have verified an NPE on the following SELECT:

connect 'jdbc:derby:memory:db;create=true';

create table blah ( a int );
insert into blah values (1), (2), (3), (4), (5), (6), (7);

SELECT rn, (SELECT rn FROM (SELECT row_number() over() rn FROM blah ) as T2
where T2.rn = T1.rn+1) rn2
FROM (SELECT row_number() over() rn from blah) as T1;

Issue Links

• relates to: DERBY-5957 0 returned instead of NULL with correlated scalar subquery in select list