db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicolas Dufour <nicolas.duf...@neometsys.fr>
Subject Select and null problem
Date Wed, 26 Oct 2005 20:06:59 GMT
Hi

I m trying to do a pretty simple insert :

insert into foo (fields ........) select value1, value2,  ....,  field3, 
field5 from foo where id = x

Everything work until when a value is equal to NULL, i have this message :
error: Encountered "null" at line ....

Ok sql has seen a null well good for it ... but why its an error !?

Thanks

Nicolas Dufour

Mime
View raw message