db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chua Chee Seng" <chees...@kzensolutions.com>
Subject All Columns become Nullable when Using left join?
Date Fri, 08 May 2009 08:13:36 GMT
Hi all,


Consider the 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 



Then, use JDBC to execute the following Select query:-






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).  It returns
correct nullable meta value if no left join is in used.  I suspect this
should be a bug?




Best Regards,


Chua Chee Seng

Java Architect

Sun Certified Enterprise Architect for JEE 5 cum ACE for Flex 3 with AIR

Research & Development Devision

M: +60 12 3840727


KZEN Solutions Bhd

Suite B-07-07 & B-07-08,

7th Floor, Block B,

Plaza Mont' Kiara,

No. 2, Jalan Kiara,

50480 Kuala Lumpur,


T: +603 6201 0242

F: +603 6203 5037

W: www.kzensolutions.com <http://www.kzensolutions.com/>  

E: cheeseng@kzensolutions.com 



View raw message