[DERBY-4284] All Columns become Nullable when Using left join

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.1.1
• Fix Version/s: 10.5.3.1, 10.6.1.0
• Component/s: JDBC, SQL
• Environment: Microsoft Windows XP SP3, Sun JDK 6 Update 14
• Urgency: Normal
• Assignee: Knut Anders Hatlen
• Reporter: Chua Chee Seng
• Created: 22/Jun/09 07:48
• Updated: 21/Jan/11 17:52
• Resolved: 08/Sep/09 14:53

Description

Consider following:-

create table person (
id varchar(20) not null,
name varchar(100) not null
);

create table car (
id varchar(20) not null,
person_id varchar(20) not null,
model varchar(100) not null,
plat_no varchar(100) not null
);

When select :-
select
p.name,
c.model,
c.plat_no
from person p
left join car c on (p.id = c.person_id);

From the ResultSet, get the ResultSetMetaData and inspect each column's isNullable() value, which is always = 1 (always nullable). Expected : column 'p.name' isNullable = 0 (not nullable), but I get 'p.name' isNullable = 1 (nullable)

Issue Links

• relates to: DERBY-2916 Change/error? in 'Ordered null semantics' output from 'SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()' in lang/wisconsin.java
• relates to: DERBY-2775 DataTypeDescriptor should be immutable so that multiple ValueNode referring to the same DTD do not have unexpected state changes.